Question: Using the tables provided, write SQL queries to answer the following: 1) Find all the players that have never scored a goal 2) Rank the

 Using the tables provided, write SQL queries to answer the following:

Using the tables provided, write SQL queries to answer the following:

1) Find all the players that have never scored a goal

2) Rank the teams by the number of support staff attending the 2018 World Cup

COUNTRY[Name, Population] TOURNAMENT Year, Country] TEAM[Year, ID, Country] MEMBER[ID, Namel HOMECLUB[Name, Country] SUPPORTSTAFF[ID, Role] PLAYER[ID, Position, HomeClubName] TEAMMEMBER[Year, TeamID, MemberID MATCH[ID, Date, Time, Stadium, HomeYear, HomeTeamID, AwayYear, AwayTeamID] POOLGAME[ID] ELIMINATIONGAME[ID, Stage, HomePenalties, AwayPenalties] GOALS[PlayerID, MatchID, Count] SAVES PlayerlD, MatchID, Count] CUSTOMER[ID, Name, Email, CountryName TICKETI Match ID. Ticket, CustomerID, Price Foreign Keys TOURNAMENT.Country references COUNTRY.Name TEAM.Country references COUNTRY.Name TEAM.Year references TOURNAMENT.Year SUPPORTSTAFF.ID references MEMBER.ID HOMECLUB.Country references COUNTRY.Name PLAYER.ID references MEMBER.ID PLAYER.HomeClubName references HOMECLUB.Name TEAMMEMBER. (Year, TeamlD) references TEAM.(Year, ID) TEAMMEMBER.MemberID references MEMBER.ID MATCH.(HomeYear, HomeTeamlD) references Team.(Year, ID) MATCH.(AwayYear, AwayTeamID) references Team.(Year, ID) POOLGAME.ID references MATCH.ID ELIMINATIONGAME.ID references MATCH.ID GOALS.PlayerlD references PLAYER.ID GOALS.MatchID references MATCH.ID SAVES.PlayerlD references PLAYER.ID SAVES.MatchID references MATCH.ID TICKET CustomerlD references CUSTOMER.ID TICKET MatchID references Match.ID COUNTRY[Name, Population] TOURNAMENT Year, Country] TEAM[Year, ID, Country] MEMBER[ID, Namel HOMECLUB[Name, Country] SUPPORTSTAFF[ID, Role] PLAYER[ID, Position, HomeClubName] TEAMMEMBER[Year, TeamID, MemberID MATCH[ID, Date, Time, Stadium, HomeYear, HomeTeamID, AwayYear, AwayTeamID] POOLGAME[ID] ELIMINATIONGAME[ID, Stage, HomePenalties, AwayPenalties] GOALS[PlayerID, MatchID, Count] SAVES PlayerlD, MatchID, Count] CUSTOMER[ID, Name, Email, CountryName TICKETI Match ID. Ticket, CustomerID, Price Foreign Keys TOURNAMENT.Country references COUNTRY.Name TEAM.Country references COUNTRY.Name TEAM.Year references TOURNAMENT.Year SUPPORTSTAFF.ID references MEMBER.ID HOMECLUB.Country references COUNTRY.Name PLAYER.ID references MEMBER.ID PLAYER.HomeClubName references HOMECLUB.Name TEAMMEMBER. (Year, TeamlD) references TEAM.(Year, ID) TEAMMEMBER.MemberID references MEMBER.ID MATCH.(HomeYear, HomeTeamlD) references Team.(Year, ID) MATCH.(AwayYear, AwayTeamID) references Team.(Year, ID) POOLGAME.ID references MATCH.ID ELIMINATIONGAME.ID references MATCH.ID GOALS.PlayerlD references PLAYER.ID GOALS.MatchID references MATCH.ID SAVES.PlayerlD references PLAYER.ID SAVES.MatchID references MATCH.ID TICKET CustomerlD 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!