Question: Use the Schema to write the following SQL queries in PHPadmin: 1. Find the game that sold the most tickets 2. Find the player who

Use the Schema to write the following SQL queries in PHPadmin:

1. Find the game that sold the most tickets

2. Find the player who scored the most goals in elimination games

3. Find countries that have played in all World Cups

4. Find players who have scored goals in all of Icelands games

PS: not using WITH or ON and there are no data for the question

Use the Schema to write the following SQL queries in PHPadmin: 1.

COUNTRYName Population] TOURNAMENTIYear, Country] TEAMIYear ID Countryl MEMBER[ID, Name] HOMECLUBIName, Country] SUPPORTSTAFFIID, Role] PLAYER[ID, Position, HomeClubName] TEAMMEMBERIYear TeamID MemberlD MATCHIID, Date, Time, Stadium, HomeYear, HomeTeamID, AwayYear, AwayTeamID] POOLGAMEID ELIMINATIONGAME[ID Stage, HomePenalties, AwayPenalties GOALS PlaverlD, MatchID, Count] SAVES PlaverlD MatchID. Count) CUSTOMERID, Name, Email, CountryName] TICKETIMatchiD Ticket CustomerID, Price) Foreign Keys: TOURNAMENT.Country references COUNTRY.Name TEAM.Country references COUNTRY.Name TEAM. Year references TOURNAMENT.Year SUPPORTSTAFF.ID references MEMBERS.ID PLAYER.ID references MEMBERS.ID PLAYER.HomeClubName references HOMECLUB.Name TEAMMEMBER. (Year, TeamID) references TEAM.(Year, TeamiD) TEAMMEMBER.MemberID references MEMBER.ID MATCH.(HomeYear, HomeTeamID) references Team. (Year, TeamID) MATCH.(AwayYear, AwayTeamID) references Team.(Year, TeamID) POOLGAME.ID references MATCH.ID ELIMINATIONGAME.ID references MATCH.ID GOALS.PlayerlD references PLAYER.ID GOALS MatchID references MATCH.ID SAVES.PlayerID references PLAYER.ID SAVES MatchID references MATCH.ID TICKET.CustomeriD references CUSTOMER.ID TICKET MatchID references Match.ID

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!