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 titles of games that have platforms in the market districts of Asia or the 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: Count the number of players that have a rank of year of at most 3.
SQL: SELECT count(*) FROM player WHERE Rank_of_the_year  <=  3

Question: Return all platform names and corresponding market districts.
SQL: SELECT Platform_name ,  Market_district FROM platform

Question: Show the title of games that are played by both players from college "Oklahoma" and players from college "Auburn".
SQL: 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.College  =  "Oklahoma" INTERSECT 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.College  =  "Auburn"

Question: What are the different developers of games that are played by players that attend Auburn college?
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: What is the average number of units sold in millions of games played by players with 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: List names and colleges of all players in descending order of rank of the year.
SQL: SELECT Player_name ,  College FROM player ORDER BY Rank_of_the_year DESC

Question: Show all distinct franchises of games.
SQL: SELECT DISTINCT Franchise FROM game

Question: What are the titles of games not played by any players who play 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: What are the titles of games that are played by players from Oklahoma college or Auburn college?
SQL: 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.College  =  "Oklahoma" INTERSECT 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.College  =  "Auburn"