Given the following schema:

Write an SQL QUERY FOR:

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

b) Find the countries that have played in all World Cups

c) Find the player who scored the most goals in elimination games

d) Find players who have scored goals in all of Icelands games

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