| 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] 2. AGGREGATE[count, #1] |
+ | easy | |
| SPIDER_dev_648 | Count the number of poker players. | SELECT count(*) FROM poker_player | 1. SELECT[tbl:poker_player] 2. AGGREGATE[count, #1] |
+ | 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] 2. PROJECT[col:poker_player:Earnings, #1] 3. SORT[#2, #2, sortdir:descending] |
+ | 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] 2. PROJECT[col:poker_player:Earnings, #1] 3. SORT[#2, #2, sortdir:descending] |
+ | 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] 2. PROJECT[col:poker_player:Final_Table_Made, #1] 3. UNION[#1, #2] |
- | medium | |
| SPIDER_dev_653 | What is the average earnings of poker players? | SELECT avg(Earnings) FROM poker_player | 1. SELECT[tbl:poker_player] 2. PROJECT[col:poker_player:Earnings, #1] 3. AGGREGATE[avg, #2] |
+ | easy | |
| SPIDER_dev_654 | Return the average earnings across all poker players. | SELECT avg(Earnings) FROM poker_player | 1. SELECT[tbl:poker_player] 2. PROJECT[col:poker_player:Earnings, #1] 3. AGGREGATE[avg, #2] |
+ | 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] 2. PROJECT[col:poker_player:Earnings, #1] 3. SUPERLATIVE[comparative:max:None, #1, #2] 4. PROJECT[col:poker_player:Money_Rank, #3] |
+ | 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] 2. PROJECT[col:poker_player:Earnings, #1] 3. SUPERLATIVE[comparative:max:None, #1, #2] 4. PROJECT[col:poker_player:Money_Rank, #3] |
+ | 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] 2. PROJECT[col:poker_player:Earnings, #1] 3. COMPARATIVE[#1, #2, comparative:<:200000:col:poker_player:Earnings] 4. SELECT[col:poker_player:Final_Table_Made] 5. GROUP[sum, #4, #3] 6. AGGREGATE[max, #5] |
+ | 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] 2. PROJECT[col:poker_player:Earnings, #1] 3. COMPARATIVE[#1, #2, comparative:<:200000:col:poker_player:Earnings] 4. PROJECT[col:poker_player:Final_Table_Made, #3] 5. AGGREGATE[max, #4] |
+ | 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] 2. PROJECT[col:people:Name, #1] |
+ | 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] 2. PROJECT[col:people:Name, #1] |
+ | 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] 2. PROJECT[col:poker_player:Earnings, #1] 3. COMPARATIVE[#1, #2, comparative:>:300000:col:poker_player:Earnings] 4. PROJECT[col:people:Name, #3] |
+ | 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] 2. PROJECT[col:poker_player:Earnings, #1] 3. COMPARATIVE[#1, #2, comparative:>:300000:col:poker_player:Earnings] 4. PROJECT[col:people:Name, #3] |
+ | 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] 2. PROJECT[col:people:Name, #1] 3. PROJECT[col:poker_player:Final_Table_Made, #1] 4. SORT[#2, #3, sortdir:ascending] |
+ | 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] 2. PROJECT[col:people:Name, #1] 3. PROJECT[col:poker_player:Final_Table_Made, #1] 4. GROUP[count, #3, #1] 5. SORT[#2, #4, sortdir:ascending] |
+ | 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] 2. PROJECT[col:poker_player:Earnings, #1] 3. SUPERLATIVE[comparative:min:None, #1, #2] 4. PROJECT[col:people:Birth_Date, #3] |
+ | 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] 2. PROJECT[col:poker_player:Earnings, #1] 3. SUPERLATIVE[comparative:min:None, #1, #2] 4. PROJECT[col:people:Birth_Date, #3] |
+ | 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] 2. PROJECT[col:people:Height, #1] 3. SUPERLATIVE[comparative:max:None, #1, #2] 4. PROJECT[col:poker_player:Money_Rank, #3] |
+ | 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] 2. PROJECT[col:people:Height, #1] 3. SUPERLATIVE[comparative:max:None, #1, #2] 4. PROJECT[col:poker_player:Money_Rank, #3] |
+ | 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] 2. PROJECT[col:people:Height, #1] 3. COMPARATIVE[#1, #2, comparative:>:200:col:people:Height] 4. PROJECT[col:poker_player:Earnings, #3] 5. AGGREGATE[avg, #4] |
+ | 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] 2. COMPARATIVE[#1, #1, comparative:>:200:col:poker_player:Earnings] 3. PROJECT[col:poker_player:Earnings, #2] |
- | 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] 2. PROJECT[col:people:Name, #1] 3. PROJECT[col:poker_player:Earnings, #1] 4. SORT[#2, #3, sortdir:descending] |
+ | 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] 2. PROJECT[col:people:Name, #1] 3. PROJECT[col:poker_player:Earnings, #1] 4. SORT[#2, #3, sortdir:descending] |
+ | 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] 2.(distinct) PROJECT[col:people:Nationality, #1] 3. GROUP[count, #1, #2] 4. UNION[#2, #3] |
+ | 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] 2. PROJECT[tbl:people, #1] 3. GROUP[count, #2, #1] 4. UNION[#1, #3] |
+ | 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[col:people:Nationality] 2. PROJECT[tbl:people, #1] 3. GROUP[count, #2, #1] 4. SUPERLATIVE[comparative:max:None, #1, #3] |
+ | 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] 2. PROJECT[tbl:people, #1] 3. GROUP[count, #2, #1] 4. SUPERLATIVE[comparative:max:None, #1, #3] |
+ | 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] 2. PROJECT[tbl:people, #1] 3. GROUP[count, #2, #1] 4. COMPARATIVE[#1, #3, comparative:>=:2] |
+ | 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] 2. PROJECT[tbl:people, #1] 3. GROUP[count, #2, #1] 4. COMPARATIVE[#1, #3, comparative:>=:2] |
+ | 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] 2. PROJECT[col:people:Name, #1] 3. PROJECT[col:people:Birth_Date, #1] 4. UNION[#2, #3] 5. SORT[#4, #2, sortdir:ascending] |
+ | 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] 2. PROJECT[col:people:Name, #1] 3. PROJECT[col:people:Birth_Date, #1] 4. UNION[#2, #3] 5. SORT[#4, #2, sortdir:ascending] |
+ | medium | |
| SPIDER_dev_681 | Show names of people whose nationality is not "Russia". | SELECT Name FROM people WHERE Nationality != "Russia" | 1. SELECT[tbl:people] 2. PROJECT[col:people:Nationality, #1] 3. COMPARATIVE[#1, #2, comparative:!=:Russia:col:people:Nationality] 4. PROJECT[col:people:Name, #3] |
+ | 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] 2. COMPARATIVE[#1, #1, comparative:!=:Russia:col:people:Nationality] 3. PROJECT[col:people:Name, #2] |
+ | 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] 2. COMPARATIVE[#1, #1, tbl:poker_player] 3. DISCARD[#1, #2] 4. PROJECT[col:people:Name, #3] |
+ | 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] 2. COMPARATIVE[#1, #1, tbl:poker_player] 3. DISCARD[#1, #2] 4. PROJECT[col:people:Name, #3] |
+ | hard | |
| SPIDER_dev_685 | How many distinct nationalities are there? | SELECT count(DISTINCT Nationality) FROM people | 1. SELECT[col:people:Nationality] 2.(distinct) PROJECT[None, #1] 3. AGGREGATE[count, #2] |
+ | easy | |
| SPIDER_dev_686 | Count the number of different nationalities. | SELECT count(DISTINCT Nationality) FROM people | 1. SELECT[col:people:Nationality] 2.(distinct) COMPARATIVE[#1, #1, None] 3. AGGREGATE[count, #2] |
+ | easy |
Exec acc: 0.9487