Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the provided Schema to write the following SQL queries: 1. Find all the Australian Players that played in the 2018 World Cup 2. Find

Use the provided Schema to write the following SQL queries:

1. Find all the Australian Players that played in the 2018 World Cup

2. Find the players that have never scored a goal

3. Find all the pool games played by host countries

4. Find all the Australian players linked to an English club team

5. Rank the teams by the number of support staff attending the 2018 World Cup

6. Find the names & number of goals saved by all players

7. Find the game that sold the most tickets

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

9. Find countries that have played in all World Cups

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

image text in transcribed

PS:No data, just write the queries

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] TICKETIMatchlD 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 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] TICKETIMatchlD 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M. Kroenke

1st Edition

0130086509, 978-0130086501

More Books

Students also viewed these Databases questions

Question

4.5 Make informed choices about legal liability?

Answered: 1 week ago

Question

Define Management by exception

Answered: 1 week ago

Question

Explain the importance of staffing in business organisations

Answered: 1 week ago

Question

What are the types of forms of communication ?

Answered: 1 week ago

Question

Explain the process of MBO

Answered: 1 week ago