(Sports league): Download the sports league database on the book website, and write SQL queries for the following: A Show the first names, last names, and phone numbers of all players with skill level “A,” followed by their team nicknames. Sort the results alphabetically first by team nickname and then by player last name. B Show the nicknames and number of players for all teams with at least three players, sorted alphabetically by team nickname. C Create a query producing a list of team IDs and nicknames, with a count of their players whose ranking is either “A” or “B.” We want one count per team, including all players who have either ranking. The results should appear sorted by the number of such players, with largest number of players first. Teams with the same number of such players should be listed in alphabetical order by nickname. If a team has no “A”‐ or “B”‐rated players, it need not appear. D Create a query showing for each game the date played, the home team nickname, the home team score, the visiting team nickname, and the visiting team score. Sort the result from earliest to latest date played, and within the same date played, sort alphabetically by home team nickname.
The post Sort the result from earliest to latest date played, and within the same date played, sort alphabetically by home team nickname. appeared first on Best Custom Essay Writing Services | EssayBureau.com.