Database schema:
CREATE TABLE platform (
  Platform_ID NUMBER PRIMARY KEY,
  Platform_name TEXT,
  Market_district TEXT,
  Download_rank NUMBER
);
CREATE TABLE game (
  Game_ID NUMBER PRIMARY KEY,
  Title TEXT,
  Release_Date TEXT,
  Franchise TEXT,
  Developers TEXT,
  Platform_ID NUMBER,
  Units_sold_Millions NUMBER,
  FOREIGN KEY (Platform_ID) REFERENCES platform(Platform_ID)
);
CREATE TABLE player (
  Player_ID NUMBER PRIMARY KEY,
  Rank_of_the_year NUMBER,
  Player_name TEXT,
  Position TEXT,
  College TEXT
);
CREATE TABLE game_player (
  Player_ID NUMBER PRIMARY KEY,
  Game_ID NUMBER,
  If_active OTHERS,
  FOREIGN KEY (Game_ID) REFERENCES game(Game_ID),
  FOREIGN KEY (Player_ID) REFERENCES player(Player_ID)
);

Question: What are the names of all players in alphabetical order?
SQL: SELECT Player_name FROM player ORDER BY Player_name ASC

Question: Return the names and ids of all platforms with the download rank of 1.
SQL: SELECT Platform_name ,  Platform_ID FROM platform WHERE Download_rank  =  1

Question: List the Title and Developers of all games ordered by units sold from large to small.
SQL: SELECT Title ,  Developers FROM game ORDER BY Units_sold_Millions DESC

Question: List all player names in ascending alphabetical order.
SQL: SELECT Player_name FROM player ORDER BY Player_name ASC

Question: How many games are there from each Franchise?
SQL: SELECT Franchise ,  COUNT(*) FROM game GROUP BY Franchise

Question: What are the names and ranks of players who have played the game with the title "Super Mario World"?
SQL: SELECT T3.Player_name ,  T3.rank_of_the_year FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T1.Title  =  "Super Mario World"

Question: What are the maximum and minimum rank of the year of players.
SQL: SELECT max(Rank_of_the_year) ,  min(Rank_of_the_year) FROM player

Question: What are the titles and platform names of all games?
SQL: SELECT T1.Title ,  T2.Platform_name FROM game AS T1 JOIN platform AS T2 ON T1.Platform_ID  =  T2.Platform_ID

Question: Show the title of games that are not played by any player who is in the Guard position.
SQL: SELECT Title FROM game EXCEPT SELECT T1.Title FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.Position  =  "Guard"

Question: How many players have rank of the year smaller than 3?
SQL: SELECT count(*) FROM player WHERE Rank_of_the_year  <=  3

Question: What are all the distinct franchises?
SQL: SELECT DISTINCT Franchise FROM game

Question: Which franchise has the most games?
SQL: SELECT Franchise FROM game GROUP BY Franchise ORDER BY COUNT(*) DESC LIMIT 1

Question: Please list the title of games with platforms that have market district in Asia or USA.
SQL: SELECT T1.Title FROM game AS T1 JOIN platform AS T2 ON T1.Platform_ID  =  T2.Platform_ID WHERE T2.Market_district  =  "Asia" OR T2.Market_district  =  "USA"

Question: Please show the names and rank of players that have played the game titled "Super Mario World".
SQL: SELECT T3.Player_name ,  T3.rank_of_the_year FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T1.Title  =  "Super Mario World"

Question: Give the maximum and minimum rank of the year across all players.
SQL: SELECT max(Rank_of_the_year) ,  min(Rank_of_the_year) FROM player

Question: Show the distinct developer of games played by players that go to college "Auburn".
SQL: SELECT DISTINCT T1.Developers FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.College  =  "Auburn"

Question: List the name of each franchise and the number of games belonging to that franchise.
SQL: SELECT Franchise ,  COUNT(*) FROM game GROUP BY Franchise

Question: What are the names and id of platforms whose download rank is 1?
SQL: SELECT Platform_name ,  Platform_ID FROM platform WHERE Download_rank  =  1

Question: Return the average number of units sold in millions among games played by players who have the position Guard.
SQL: SELECT avg(Units_sold_Millions) FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.Position  =  "Guard"

Question: Return the average number of units sold in millions for games not developed by Nintendo.
SQL: SELECT avg(Units_sold_Millions) FROM game WHERE developers != 'Nintendo'

Question: Count the number of games.
SQL: SELECT count(*) FROM game

Question: What is the average units sold in millions of the games that are not developed by Nintendo?
SQL: SELECT avg(Units_sold_Millions) FROM game WHERE developers != 'Nintendo'

Question: What are the names of players who do not play any games?
SQL: SELECT Player_name FROM player WHERE Player_ID NOT IN (SELECT Player_ID FROM game_player)

Question: List the name of franchise that have the most number of games.
SQL: SELECT Franchise FROM game GROUP BY Franchise ORDER BY COUNT(*) DESC LIMIT 1

Question: Please list the title and platform name of games.
SQL: SELECT T1.Title ,  T2.Platform_name FROM game AS T1 JOIN platform AS T2 ON T1.Platform_ID  =  T2.Platform_ID

Question: What are the names of franchises that have two or more games?
SQL: SELECT Franchise FROM game GROUP BY Franchise HAVING COUNT(*)  >=  2

Question: What are the names and market districts of all platforms?
SQL: SELECT Platform_name ,  Market_district FROM platform

Question: List the names of franchises that have at least two games.
SQL: SELECT Franchise FROM game GROUP BY Franchise HAVING COUNT(*)  >=  2

Question: What are the names and colleges of all players, ordered by rank of year descending?
SQL: SELECT Player_name ,  College FROM player ORDER BY Rank_of_the_year DESC

Question: What are the titles and developers of all games, sorted by units sold descending?
SQL: SELECT Title ,  Developers FROM game ORDER BY Units_sold_Millions DESC

Question: How many games are there?
SQL: SELECT count(*) FROM game

Question: List the name of players that do not play any game.
SQL: SELECT Player_name FROM player WHERE Player_ID NOT IN (SELECT Player_ID FROM game_player)