Database: poker_player
Schema: 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 (easy): How many poker players are there?
SQL: SELECT count(*) FROM poker_player

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

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

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

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

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

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

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

Question (medium): 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 (medium): 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 (easy): 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 (easy): 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 (easy): 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 (easy): 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 (medium): 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 (medium): 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 (medium): 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 (medium): 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 (hard): 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 (hard): 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 (hard): 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 (hard): 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 (medium): 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 (medium): 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 (medium): 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 (medium): 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 (medium): 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 (medium): How many people are there of each nationality?
SQL: SELECT Nationality ,  COUNT(*) FROM people GROUP BY Nationality

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

Question (hard): 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 (easy): What are the nationalities that are shared by at least two people?
SQL: SELECT Nationality FROM people GROUP BY Nationality HAVING COUNT(*)  >=  2

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

Question (medium): 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 (medium): 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 (easy): Show names of people whose nationality is not "Russia".
SQL: SELECT Name FROM people WHERE Nationality != "Russia"

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

Question (hard): 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 (hard): 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 (easy): How many distinct nationalities are there?
SQL: SELECT count(DISTINCT Nationality) FROM people

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