please answer this question, thank you

QUESTION 6 Given the following relational schema of the Sports Day Event at Sekolah Kebangsaan Paya Datuk: GAME (GameCode, GameLevel, GameVenue) GAME_TEAM (GameCode*, TeamID*, Date, Time, Venue, Score) PLAYER (PlayerNo, PlayerName, PlayerAddress, PlayerPosition, PlayerGender, PlayerDOB, Age, TeamlD*) TEAM (TeamID, TeamName. CoachID) COACH (Coach ID, CoachFName, CoachLName, Coach_Phone) Write the IBM DB2 SQL commands for the following questions: a) Create the PLAYER table. (4 marks) b) Add a new record to the COACH table that consists of the following values: c) Coach ID C0010 CoachFName YUSRI CoachLName RAMLI Coach_Phone 0111-4556789 TeamID T005 (2 marks) List the details of all players whose second character of the player name is the 'A' letter. Arrange the results in descending order by the player name. (3 marks) Find the three teams with the highest score. (3 marks) Display the team name of The Red Warrior, with their player number and the player name, including the coach who is in charge for the team. (4 marks) Delete the TEAM table from the database. (1 mark) d) e) f) g) Calculate how many players for each team. Display the team with the number of players that is equals or greater than 5