Answer all questions:

Answer all questions in MySQL asap:

/* e. List the coach ID and coach name of all coaches who are head coaches, along with the ID, name and position of each coach who is supervised by them. Also include the club name. (All head coaches would only supervise coaches from the same team)*/

/* f. List all the stadiums that have not been used in a match. List the stadium ID and name. Sort the output by stadium name in ascending order. */

/* g. Delete the player Paulo Retre */

/* h. In the match_club_player table, for the Match with ID 4, change the number of goals from 0 to 2, for Adam Taggart, who plays for Perth Glory.*/

A-League Tipper Database MATCH STADIUM Matt chID played at StadiumID SUA Match Start Stadium Name Stadium City Round hosts OStadium State Attendance Stadium ID [FK] ostadiumCapacity ClubID IFK belongs OWnS owned by has MATCH CLUB belongs CLUB has ClubID Matt ChID FK1 ClubName ClubID FK2 ClubCity Score Club State OS tatus (Home/Away) oClub Phone belongs ClubEmail belongs to coaches 11 has MATCH CLUB PLAYER MatchIDClub ID FK1 Player ID FK2 ONum Goals be has PLAYER PlayerID 11 oPlayerName Player Number Player Position supervises has ClubID FK COACH S a S a CoachID LOH CoachName supervised Position Field Player DOB by Goal Keeper Player ID FK ClubID IFK 11 PlayerID FK NumAssists. Supervisor ID FK2 ONum Goal Kicks Num Pass Ses Numsaves. ONum Tackles NumGoals Conceded