Database: poker_player

CREATE TABLE "poker_player" (
"Poker_Player_ID" int,
"People_ID" int,
"Final_Table_Made" real,
"Best_Finish" real,
"Money_Rank" real,
"Earnings" real,
PRIMARY KEY ("Poker_Player_ID"),
FOREIGN KEY ("People_ID") REFERENCES `people`("People_ID")
);
CREATE TABLE "people" (
"People_ID" int,
"Nationality" text,
"Name" text,
"Birth_Date" text,
"Height" real,
PRIMARY KEY ("People_ID")
);

Question: How many poker players are there?
SQL: SELECT count(*) FROM poker_player

Question: Count the number of poker players.
SQL: SELECT count(*) FROM poker_player

Question: List the earnings of poker players in descending order.
SQL: SELECT Earnings FROM poker_player ORDER BY Earnings DESC

Question: What are the earnings of poker players, ordered descending by value?
SQL: SELECT Earnings FROM poker_player ORDER BY Earnings DESC

Question: List the final tables made and the best finishes of poker players.
SQL: SELECT Final_Table_Made ,  Best_Finish FROM poker_player

Question: What are the final tables made and best finishes for all poker players?
SQL: SELECT Final_Table_Made ,  Best_Finish FROM poker_player

Question: What is the average earnings of poker players?
SQL: SELECT avg(Earnings) FROM poker_player

Question: Return the average earnings across all poker players.
SQL: SELECT avg(Earnings) FROM poker_player

Question: What is the money rank of the poker player with the highest earnings?
SQL: SELECT Money_Rank FROM poker_player ORDER BY Earnings DESC LIMIT 1

Question: Return the money rank of the player with the greatest earnings.
SQL: SELECT Money_Rank FROM poker_player ORDER BY Earnings DESC LIMIT 1

Question: What is the maximum number of final tables made among poker players with earnings less than 200000?
SQL: SELECT max(Final_Table_Made) FROM poker_player WHERE Earnings  <  200000

Question: Return the maximum final tables made across all poker players who have earnings below 200000.
SQL: SELECT max(Final_Table_Made) FROM poker_player WHERE Earnings  <  200000

Question: What are the names of poker players?
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID

Question: Return the names of all the poker players.
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID

Question: What are the names of poker players whose earnings is higher than 300000?
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Earnings  >  300000

Question: Give the names of poker players who have earnings above 300000.
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Earnings  >  300000

Question: List the names of poker players ordered by the final tables made in ascending order.
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Final_Table_Made

Question: What are the names of poker players, ordered ascending by the number of final tables they have made?
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Final_Table_Made

Question: What is the birth date of the poker player with the lowest earnings?
SQL: SELECT T1.Birth_Date FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Earnings ASC LIMIT 1

Question: Return the birth date of the poker player with the lowest earnings.
SQL: SELECT T1.Birth_Date FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Earnings ASC LIMIT 1

Question: What is the money rank of the tallest poker player?
SQL: SELECT T2.Money_Rank FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Height DESC LIMIT 1

Question: Return the money rank of the poker player with the greatest height.
SQL: SELECT T2.Money_Rank FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Height DESC LIMIT 1

Question: What is the average earnings of poker players with height higher than 200?
SQL: SELECT avg(T2.Earnings) FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Height  >  200

Question: Give average earnings of poker players who are taller than 200.
SQL: SELECT avg(T2.Earnings) FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Height  >  200

Question: What are the names of poker players in descending order of earnings?
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Earnings DESC

Question: Return the names of poker players sorted by their earnings descending.
SQL: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Earnings DESC

Question: What are different nationalities of people and the corresponding number of people from each nation?
SQL: SELECT Nationality ,  COUNT(*) FROM people GROUP BY Nationality

Question: How many people are there of each nationality?
SQL: SELECT Nationality ,  COUNT(*) FROM people GROUP BY Nationality

Question: What is the most common nationality of people?
SQL: SELECT Nationality FROM people GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1

Question: Give the nationality that is most common across all people.
SQL: SELECT Nationality FROM people GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1

Question: What are the nationalities that are shared by at least two people?
SQL: SELECT Nationality FROM people GROUP BY Nationality HAVING COUNT(*)  >=  2

Question: Return the nationalities for which there are two or more people.
SQL: SELECT Nationality FROM people GROUP BY Nationality HAVING COUNT(*)  >=  2

Question: List the names and birth dates of people in ascending alphabetical order of name.
SQL: SELECT Name ,  Birth_Date FROM people ORDER BY Name ASC

Question: What are the names and birth dates of people, ordered by their names in alphabetical order?
SQL: SELECT Name ,  Birth_Date FROM people ORDER BY Name ASC

Question: Show names of people whose nationality is not "Russia".
SQL: SELECT Name FROM people WHERE Nationality != "Russia"

Question: What are the names of people who are not from Russia?
SQL: SELECT Name FROM people WHERE Nationality != "Russia"

Question: List the names of people that are not poker players.
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM poker_player)

Question: What are the names of people who do not play poker?
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM poker_player)

Question: How many distinct nationalities are there?
SQL: SELECT count(DISTINCT Nationality) FROM people

Question: Count the number of different nationalities.
SQL: SELECT count(DISTINCT Nationality) FROM people