 | Idx | Table      | Column | Primary Key | Foreign Key | 
 | ----------- | ----------- | ----------- | ----------- | ----------- | 
  | 0 |  | * |   |   | 
 | 1 | **poker_player** | Poker_Player_ID | + |   | 
 | 2 |   | People_ID |   | --> 7 | 
 | 3 |   | Final_Table_Made |   |   | 
 | 4 |   | Best_Finish |   |   | 
 | 5 |   | Money_Rank |   |   | 
 | 6 |   | Earnings |   |   | 
 | 7 | **people** | People_ID | + |   | 
 | 8 |   | Nationality |   |   | 
 | 9 |   | Name |   |   | 
 | 10 |   | Birth_Date |   |   | 
 | 11 |   | Height |   |   | 
 
  | Index | Question  | SQL | gold QDMR | pred QDMR | Exec | SQL hardness |
  | ----------- | ----------- | ----------- |  ----------- | ----------- | ----------- | ----------- | 
 | SPIDER_dev_647 | How many poker players are there? | SELECT count(*) FROM poker_player |  | 1. SELECT[tbl:​poker_player] <br>2. AGGREGATE[count, #1] <br> | + | easy | 
  | SPIDER_dev_648 | Count the number of poker players. | SELECT count(*) FROM poker_player |  | 1. SELECT[tbl:​poker_player] <br>2. AGGREGATE[count, #1] <br> | + | easy | 
  | SPIDER_dev_649 | List the earnings of poker players in descending order. | SELECT Earnings FROM poker_player ORDER BY Earnings DESC |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. SORT[#2, #2, sortdir:​descending] <br> | + | easy | 
  | SPIDER_dev_650 | What are the earnings of poker players, ordered descending by value? | SELECT Earnings FROM poker_player ORDER BY Earnings DESC |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. PROJECT[col:​poker_player:​Earnings, #1] <br>4. SORT[#2, #3, sortdir:​descending] <br> | + | easy | 
  | SPIDER_dev_651 | List the final tables made and the best finishes of poker players. | SELECT Final_Table_Made ,  Best_Finish FROM poker_player |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Final_Table_Made, #1] <br>3. PROJECT[col:​poker_player:​Best_Finish, #1] <br>4. UNION[#2, #3] <br> | + | medium | 
  | SPIDER_dev_653 | What is the average earnings of poker players? | SELECT avg(Earnings) FROM poker_player |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. AGGREGATE[avg, #2] <br> | + | easy | 
  | SPIDER_dev_654 | Return the average earnings across all poker players. | SELECT avg(Earnings) FROM poker_player |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. AGGREGATE[avg, #2] <br> | + | easy | 
  | SPIDER_dev_655 | What is the money rank of the poker player with the highest earnings? | SELECT Money_Rank FROM poker_player ORDER BY Earnings DESC LIMIT 1 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. SUPERLATIVE[comparative:​max:​None, #1, #2] <br>4. PROJECT[col:​poker_player:​Money_Rank, #3] <br> | + | medium | 
  | SPIDER_dev_656 | Return the money rank of the player with the greatest earnings. | SELECT Money_Rank FROM poker_player ORDER BY Earnings DESC LIMIT 1 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. SUPERLATIVE[comparative:​max:​None, #1, #2] <br>4. PROJECT[col:​poker_player:​Money_Rank, #3] <br> | + | medium | 
  | SPIDER_dev_657 | What is the maximum number of final tables made among poker players with earnings less than 200000? | SELECT max(Final_Table_Made) FROM poker_player WHERE Earnings  <  200000 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. COMPARATIVE[#1, #2, comparative:​<:​200000:​col:​poker_player:​Earnings] <br>4. PROJECT[col:​poker_player:​Final_Table_Made, #3] <br>5. AGGREGATE[max, #4] <br> | + | easy | 
  | SPIDER_dev_658 | Return the maximum final tables made across all poker players who have earnings below 200000. | SELECT max(Final_Table_Made) FROM poker_player WHERE Earnings  <  200000 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. COMPARATIVE[#1, #2, comparative:​<:​200000:​col:​poker_player:​Earnings] <br>4. PROJECT[col:​poker_player:​Final_Table_Made, #3] <br>5. AGGREGATE[max, #4] <br> | + | easy | 
  | SPIDER_dev_659 | What are the names of poker players? | SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​people:​Name, #1] <br> | + | easy | 
  | SPIDER_dev_660 | Return the names of all the poker players. | SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​people:​Name, #1] <br> | + | easy | 
  | SPIDER_dev_661 | What are the names of poker players whose earnings is higher than 300000? | SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Earnings  >  300000 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. COMPARATIVE[#1, #2, comparative:​>:​300000:​col:​poker_player:​Earnings] <br>4. PROJECT[col:​people:​Name, #3] <br> | + | medium | 
  | SPIDER_dev_662 | Give the names of poker players who have earnings above 300000. | SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Earnings  >  300000 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. COMPARATIVE[#1, #2, comparative:​>:​300000:​col:​poker_player:​Earnings] <br>4. PROJECT[col:​people:​Name, #3] <br> | + | medium | 
  | SPIDER_dev_663 | List the names of poker players ordered by the final tables made in ascending order. | 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 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​people:​Name, #1] <br>3. PROJECT[col:​poker_player:​Final_Table_Made, #1] <br>4. SORT[#2, #3, sortdir:​ascending] <br> | + | medium | 
  | SPIDER_dev_664 | What are the names of poker players, ordered ascending by the number of final tables they have made? | 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 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​people:​Name, #1] <br>3. PROJECT[col:​poker_player:​Final_Table_Made, #1] <br>4. GROUP[count, #3, #1] <br>5. SORT[#2, #4, sortdir:​ascending] <br> | + | medium | 
  | SPIDER_dev_665 | What is the birth date of the poker player with the lowest earnings? | 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 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. SUPERLATIVE[comparative:​min:​None, #1, #2] <br>4. PROJECT[col:​people:​Birth_Date, #3] <br> | + | hard | 
  | SPIDER_dev_666 | Return the birth date of the poker player with the lowest earnings. | 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 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. SUPERLATIVE[comparative:​min:​None, #1, #2] <br>4. PROJECT[col:​people:​Birth_Date, #3] <br> | + | hard | 
  | SPIDER_dev_667 | What is the money rank of the tallest poker player? | 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 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​people:​Height, #1] <br>3. SUPERLATIVE[comparative:​max:​None, #1, #2] <br>4. PROJECT[col:​poker_player:​Money_Rank, #3] <br> | + | hard | 
  | SPIDER_dev_668 | Return the money rank of the poker player with the greatest height. | 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 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​people:​Height, #1] <br>3. SUPERLATIVE[comparative:​max:​None, #1, #2] <br>4. PROJECT[col:​poker_player:​Money_Rank, #3] <br> | + | hard | 
  | SPIDER_dev_669 | What is the average earnings of poker players with height higher than 200? | SELECT avg(T2.Earnings) FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Height  >  200 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​people:​Height, #1] <br>3. COMPARATIVE[#1, #2, comparative:​>:​200:​col:​people:​Height] <br>4. PROJECT[col:​poker_player:​Earnings, #3] <br>5. AGGREGATE[avg, #4] <br> | + | medium | 
  | SPIDER_dev_670 | Give average earnings of poker players who are taller than 200. | SELECT avg(T2.Earnings) FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Height  >  200 |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​poker_player:​Earnings, #1] <br>3. COMPARATIVE[#2, #2, comparative:​>:​200:​col:​poker_player:​Earnings] <br>4. PROJECT[col:​poker_player:​Earnings, #3] <br> | - | medium | 
  | SPIDER_dev_671 | What are the names of poker players in descending order of earnings? | SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Earnings DESC |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​people:​Name, #1] <br>3. PROJECT[col:​poker_player:​Earnings, #1] <br>4. SORT[#2, #3, sortdir:​descending] <br> | + | medium | 
  | SPIDER_dev_672 | Return the names of poker players sorted by their earnings descending. | SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Earnings DESC |  | 1. SELECT[tbl:​poker_player] <br>2. PROJECT[col:​people:​Name, #1] <br>3. PROJECT[col:​poker_player:​Earnings, #1] <br>4. SORT[#2, #3, sortdir:​descending] <br> | + | medium | 
  | SPIDER_dev_673 | What are different nationalities of people and the corresponding number of people from each nation? | SELECT Nationality ,  COUNT(*) FROM people GROUP BY Nationality |  | 1. SELECT[tbl:​people] <br>2.*(distinct)* PROJECT[None, #1] <br>3. PROJECT[tbl:​people, #2] <br>4. GROUP[count, #3, #2] <br>5. UNION[#2, #4] <br> | - | medium | 
  | SPIDER_dev_674 | How many people are there of each nationality? | SELECT Nationality ,  COUNT(*) FROM people GROUP BY Nationality |  | 1. SELECT[col:​people:​Nationality] <br>2. PROJECT[tbl:​people, #1] <br>3. GROUP[count, #2, #1] <br>4. UNION[#1, #3] <br> | + | medium | 
  | SPIDER_dev_675 | What is the most common nationality of people? | SELECT Nationality FROM people GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1 |  | 1. SELECT[tbl:​people] <br>2. PROJECT[col:​people:​Nationality, #1] <br>3. GROUP[count, #1, #2] <br>4. SUPERLATIVE[comparative:​max:​None, #2, #3] <br> | + | hard | 
  | SPIDER_dev_676 | Give the nationality that is most common across all people. | SELECT Nationality FROM people GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1 |  | 1. SELECT[col:​people:​Nationality] <br>2. PROJECT[tbl:​people, #1] <br>3. GROUP[count, #2, #1] <br>4. SUPERLATIVE[comparative:​max:​None, #1, #3] <br> | + | hard | 
  | SPIDER_dev_677 | What are the nationalities that are shared by at least two people? | SELECT Nationality FROM people GROUP BY Nationality HAVING COUNT(*)  >=  2 |  | 1. SELECT[col:​people:​Nationality] <br>2. PROJECT[tbl:​people, #1] <br>3. GROUP[count, #2, #1] <br>4. COMPARATIVE[#1, #3, comparative:​>=:​2] <br> | + | easy | 
  | SPIDER_dev_678 | Return the nationalities for which there are two or more people. | SELECT Nationality FROM people GROUP BY Nationality HAVING COUNT(*)  >=  2 |  | 1. SELECT[col:​people:​Nationality] <br>2. PROJECT[tbl:​people, #1] <br>3. GROUP[count, #2, #1] <br>4. COMPARATIVE[#1, #3, comparative:​>=:​2] <br> | + | easy | 
  | SPIDER_dev_679 | List the names and birth dates of people in ascending alphabetical order of name. | SELECT Name ,  Birth_Date FROM people ORDER BY Name ASC |  | 1. SELECT[tbl:​people] <br>2. PROJECT[col:​people:​Name, #1] <br>3. PROJECT[col:​people:​Birth_Date, #1] <br>4. UNION[#2, #3] <br>5. SORT[#4, #2, sortdir:​ascending] <br> | + | medium | 
  | SPIDER_dev_680 | What are the names and birth dates of people, ordered by their names in alphabetical order? | SELECT Name ,  Birth_Date FROM people ORDER BY Name ASC |  | 1. SELECT[tbl:​people] <br>2. PROJECT[col:​people:​Name, #1] <br>3. PROJECT[col:​people:​Birth_Date, #1] <br>4. UNION[#2, #3] <br>5. SORT[#4, #2, sortdir:​ascending] <br> | + | medium | 
  | SPIDER_dev_681 | Show names of people whose nationality is not "Russia". | SELECT Name FROM people WHERE Nationality != "Russia" |  | 1. SELECT[tbl:​people] <br>2. PROJECT[col:​people:​Nationality, #1] <br>3. COMPARATIVE[#1, #2, comparative:​!=:​Russia:​col:​people:​Nationality] <br>4. PROJECT[col:​people:​Name, #3] <br> | + | easy | 
  | SPIDER_dev_682 | What are the names of people who are not from Russia? | SELECT Name FROM people WHERE Nationality != "Russia" |  | 1. SELECT[tbl:​people] <br>2. COMPARATIVE[#1, #1, comparative:​!=:​Russia:​col:​people:​Nationality] <br>3. PROJECT[col:​people:​Name, #2] <br> | + | easy | 
  | SPIDER_dev_683 | List the names of people that are not poker players. | SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM poker_player) |  | 1. SELECT[tbl:​people] <br>2. COMPARATIVE[#1, #1, tbl:​poker_player] <br>3. DISCARD[#1, #2] <br>4. PROJECT[col:​people:​Name, #3] <br> | + | hard | 
  | SPIDER_dev_684 | What are the names of people who do not play poker? | SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM poker_player) |  | 1. SELECT[tbl:​people] <br>2. COMPARATIVE[#1, #1, tbl:​poker_player] <br>3. DISCARD[#1, #2] <br>4. PROJECT[col:​people:​Name, #3] <br> | + | hard | 
  | SPIDER_dev_685 | How many distinct nationalities are there? | SELECT count(DISTINCT Nationality) FROM people |  | 1. SELECT[col:​people:​Nationality] <br>2.*(distinct)* PROJECT[None, #1] <br>3. AGGREGATE[count, #2] <br> | + | easy | 
  | SPIDER_dev_686 | Count the number of different nationalities. | SELECT count(DISTINCT Nationality) FROM people |  | 1.*(distinct)* SELECT[col:​people:​Nationality] <br>2. AGGREGATE[count, #1] <br> | + | easy | 
 ***
 Exec acc: **0.9487**
