Database schema:
CREATE TABLE club (
  Club_ID NUMBER PRIMARY KEY,
  Name TEXT,
  Manager TEXT,
  Captain TEXT,
  Manufacturer TEXT,
  Sponsor TEXT
);
CREATE TABLE player (
  Player_ID NUMBER PRIMARY KEY,
  Name TEXT,
  Country TEXT,
  Earnings NUMBER,
  Events_number NUMBER,
  Wins_count NUMBER,
  Club_ID NUMBER,
  FOREIGN KEY (Club_ID) REFERENCES club(Club_ID)
);

Question: List the country that have more than one player.
SQL: SELECT Country FROM player GROUP BY Country HAVING COUNT(*)  >  1

Question: List the manufacturers that are associated with more than one club.
SQL: SELECT Manufacturer FROM club GROUP BY Manufacturer HAVING COUNT(*)  >  1

Question: What is the number of distinct countries of all players?
SQL: SELECT COUNT (DISTINCT Country) FROM player

Question: What are the names of players in ascending order of wins count?
SQL: SELECT Name FROM player ORDER BY Wins_count ASC

Question: What are the names of players and the corresponding clubs that they are in?
SQL: SELECT T2.Name ,  T1.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID

Question: Show names of clubs that have players with more than 2 win counts.
SQL: SELECT T1.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID WHERE T2.Wins_count  >  2

Question: What are the names of clubs, ordered descending by the average earnings of players within each?
SQL: SELECT T1.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID GROUP BY T1.Club_ID ORDER BY avg(T2.Earnings) DESC

Question: What is the name of the player with the highest earnings?
SQL: SELECT Name FROM player ORDER BY Earnings DESC LIMIT 1

Question: Which country has produced both players with earnings over 1400000 and players with earnings below 1100000?
SQL: SELECT Country FROM player WHERE Earnings  >  1400000 INTERSECT SELECT Country FROM player WHERE Earnings  <  1100000

Question: Return the name of the player who earns the most money.
SQL: SELECT Name FROM player ORDER BY Earnings DESC LIMIT 1

Question: How many clubs use each manufacturer?
SQL: SELECT Manufacturer ,  COUNT(*) FROM club GROUP BY Manufacturer

Question: What are the distinct countries of players with earnings higher than 1200000?
SQL: SELECT DISTINCT Country FROM player WHERE Earnings  >  1200000

Question: What are the names of clubs who do not have the manufacturer Nike?
SQL: SELECT Name FROM club WHERE Manufacturer != "Nike"

Question: What is the country of the player with the highest earnings among players that have more than 2 win counts?
SQL: SELECT Country FROM player WHERE Wins_count  >  2 ORDER BY Earnings DESC LIMIT 1

Question: How many different countries are players from?
SQL: SELECT COUNT (DISTINCT Country) FROM player

Question: Which countries have produced more than one player?
SQL: SELECT Country FROM player GROUP BY Country HAVING COUNT(*)  >  1

Question: List the name of clubs that do not have players.
SQL: SELECT Name FROM club WHERE Club_ID NOT IN (SELECT Club_ID FROM player)

Question: What are the names of clubs that do not have any players?
SQL: SELECT Name FROM club WHERE Club_ID NOT IN (SELECT Club_ID FROM player)

Question: List the name of clubs in ascending alphabetical order.
SQL: SELECT Name FROM club ORDER BY Name ASC

Question: Which manufacturer is most common among clubs?
SQL: SELECT Manufacturer FROM club GROUP BY Manufacturer ORDER BY COUNT(*) DESC LIMIT 1

Question: Show names of players and names of clubs they are in.
SQL: SELECT T2.Name ,  T1.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID

Question: Count the number of clubs.
SQL: SELECT count(*) FROM club

Question: List the name of clubs whose manufacturer is not "Nike"
SQL: SELECT Name FROM club WHERE Manufacturer != "Nike"

Question: Which manufacturers work for more than 1 club?
SQL: SELECT Manufacturer FROM club GROUP BY Manufacturer HAVING COUNT(*)  >  1

Question: Show the earnings of players from country "Australia" or "Zimbabwe".
SQL: SELECT Earnings FROM player WHERE Country  =  "Australia" OR Country  =  "Zimbabwe"

Question: What are the names of clubs that have players who have won more than twice?
SQL: SELECT T1.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID WHERE T2.Wins_count  >  2

Question: What are the names of clubs, ordered alphabetically?
SQL: SELECT Name FROM club ORDER BY Name ASC

Question: What are the managers and captains of clubs?
SQL: SELECT Manager ,  Captain FROM club

Question: What are the names of players from the club managed by Sam Allardyce?
SQL: SELECT T2.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID WHERE T1.Manager  =  "Sam Allardyce"

Question: Show different manufacturers and the number of clubs they are associated with.
SQL: SELECT Manufacturer ,  COUNT(*) FROM club GROUP BY Manufacturer

Question: Show the country of players with earnings more than 1400000 and players with earnings less than 1100000.
SQL: SELECT Country FROM player WHERE Earnings  >  1400000 INTERSECT SELECT Country FROM player WHERE Earnings  <  1100000