 | Idx | Table      | Column | Primary Key | Foreign Key | 
 | ----------- | ----------- | ----------- | ----------- | ----------- | 
  | 0 |  | * |   |   | 
 | 1 | **Highschooler** | ID | + |   | 
 | 2 |   | name |   |   | 
 | 3 |   | grade |   |   | 
 | 4 | **Friend** | student_id | + | --> 1 | 
 | 5 |   | friend_id |   | --> 1 | 
 | 6 | **Likes** | student_id | + | --> 1 | 
 | 7 |   | liked_id |   | --> 1 | 
 
  | Index | Question  | SQL | gold QDMR | pred QDMR | Exec | SQL hardness |
  | ----------- | ----------- | ----------- |  ----------- | ----------- | ----------- | ----------- | 
 | SPIDER_dev_862 | How many high schoolers are there? | SELECT count(*) FROM Highschooler |  | 1. SELECT[tbl:​Highschooler] <br>2. AGGREGATE[count, #1] <br> | + | easy | 
  | SPIDER_dev_863 | Count the number of high schoolers. | SELECT count(*) FROM Highschooler |  | 1. SELECT[tbl:​Highschooler] <br>2. AGGREGATE[count, #1] <br> | + | easy | 
  | SPIDER_dev_864 | Show the names and grades of each high schooler. | SELECT name ,  grade FROM Highschooler |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[col:​Highschooler:​name, #1] <br>3. PROJECT[col:​Highschooler:​grade, #1] <br>4. UNION[#2, #3] <br> | + | medium | 
  | SPIDER_dev_865 | What are the names and grades for each high schooler? | SELECT name ,  grade FROM Highschooler |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[col:​Highschooler:​name, #1] <br>3. PROJECT[col:​Highschooler:​grade, #1] <br>4. UNION[#2, #3] <br> | + | medium | 
  | SPIDER_dev_866 | Show all the grades of the high schoolers. | SELECT grade FROM Highschooler |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[col:​Highschooler:​grade, #1] <br> | + | easy | 
  | SPIDER_dev_867 | What is the grade of each high schooler? | SELECT grade FROM Highschooler |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[col:​Highschooler:​grade, #1] <br> | + | easy | 
  | SPIDER_dev_868 | What grade is Kyle in? | SELECT grade FROM Highschooler WHERE name  =  "Kyle" |  | 1. SELECT[col:​Highschooler:​grade] <br>2. PROJECT[col:​Highschooler:​grade, #1] <br> | - | easy | 
  | SPIDER_dev_869 | Return the grade for the high schooler named Kyle. | SELECT grade FROM Highschooler WHERE name  =  "Kyle" |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, comparative:​=:​Kyle:​col:​Highschooler:​name] <br>3. PROJECT[col:​Highschooler:​grade, #2] <br> | + | easy | 
  | SPIDER_dev_870 | Show the names of all high schoolers in grade 10. | SELECT name FROM Highschooler WHERE grade  =  10 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[col:​Highschooler:​grade, #1] <br>3. COMPARATIVE[#1, #2, comparative:​=:​10:​col:​Highschooler:​grade] <br>4. PROJECT[col:​Highschooler:​name, #3] <br> | + | easy | 
  | SPIDER_dev_871 | What are the names of all high schoolers in grade 10? | SELECT name FROM Highschooler WHERE grade  =  10 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[col:​Highschooler:​grade, #1] <br>3. COMPARATIVE[#1, #2, comparative:​=:​10:​col:​Highschooler:​grade] <br>4. PROJECT[col:​Highschooler:​name, #3] <br> | + | easy | 
  | SPIDER_dev_872 | Show the ID of the high schooler named Kyle. | SELECT ID FROM Highschooler WHERE name  =  "Kyle" |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, comparative:​=:​Kyle:​col:​Highschooler:​name] <br>3. PROJECT[col:​Highschooler:​ID, #2] <br> | + | easy | 
  | SPIDER_dev_873 | What is Kyle's id? | SELECT ID FROM Highschooler WHERE name  =  "Kyle" |  | 1. SELECT[val:​Highschooler:​name:​Kyle] <br>2. PROJECT[col:​Highschooler:​ID, #1] <br> | + | easy | 
  | SPIDER_dev_874 | How many high schoolers are there in grade 9 or 10? | SELECT count(*) FROM Highschooler WHERE grade  =  9 OR grade  =  10 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[col:​Highschooler:​grade, #1] <br>3. COMPARATIVE[#1, #2, comparative:​=:​10:​col:​Highschooler:​grade] <br>4. COMPARATIVE[#1, #2, comparative:​=:​9:​col:​Highschooler:​grade] <br>5. UNION[#3, #4] <br>6. AGGREGATE[count, #5] <br> | + | medium | 
  | SPIDER_dev_875 | Count the number of high schoolers in grades 9 or 10. | SELECT count(*) FROM Highschooler WHERE grade  =  9 OR grade  =  10 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[col:​Highschooler:​grade, #1] <br>3. COMPARATIVE[#1, #2, comparative:​=:​10:​col:​Highschooler:​grade] <br>4. COMPARATIVE[#1, #2, comparative:​=:​9:​col:​Highschooler:​grade] <br>5. UNION[#3, #4] <br>6. AGGREGATE[count, #5] <br> | + | medium | 
  | SPIDER_dev_876 | Show the number of high schoolers for each grade. | SELECT grade ,  count(*) FROM Highschooler GROUP BY grade |  | 1. SELECT[col:​Highschooler:​grade] <br>2. PROJECT[tbl:​Highschooler, #1] <br>3. GROUP[count, #2, #1] <br>4. UNION[#1, #3] <br> | + | medium | 
  | SPIDER_dev_877 | How many high schoolers are in each grade? | SELECT grade ,  count(*) FROM Highschooler GROUP BY grade |  | 1. SELECT[col:​Highschooler:​grade] <br>2. PROJECT[tbl:​Highschooler, #1] <br>3. GROUP[count, #2, #1] <br>4. UNION[#1, #3] <br> | + | medium | 
  | SPIDER_dev_878 | Which grade has the most high schoolers? | SELECT grade FROM Highschooler GROUP BY grade ORDER BY count(*) DESC LIMIT 1 |  | 1. SELECT[col:​Highschooler:​grade] <br>2. PROJECT[tbl:​Highschooler, #1] <br>3. GROUP[count, #2, #1] <br>4. SUPERLATIVE[comparative:​max:​None, #1, #3] <br> | + | hard | 
  | SPIDER_dev_879 | Return the grade that has the greatest number of high schoolers. | SELECT grade FROM Highschooler GROUP BY grade ORDER BY count(*) DESC LIMIT 1 |  | 1. SELECT[col:​Highschooler:​grade] <br>2. PROJECT[tbl:​Highschooler, #1] <br>3. GROUP[count, #2, #1] <br>4. SUPERLATIVE[comparative:​max:​None, #1, #3] <br> | + | hard | 
  | SPIDER_dev_880 | Show me all grades that have at least 4 students. | SELECT grade FROM Highschooler GROUP BY grade HAVING count(*)  >=  4 |  | 1. SELECT[col:​Highschooler:​grade] <br>2. PROJECT[col:​Highschooler:​grade, #1] <br>3. GROUP[count, #2, #1] <br>4. COMPARATIVE[#1, #3, comparative:​>=:​4] <br> | + | easy | 
  | SPIDER_dev_881 | Which grades have 4 or more high schoolers? | SELECT grade FROM Highschooler GROUP BY grade HAVING count(*)  >=  4 |  | 1. SELECT[col:​Highschooler:​grade] <br>2. PROJECT[tbl:​Highschooler, #1] <br>3. GROUP[count, #2, #1] <br>4. COMPARATIVE[#1, #3, comparative:​>=:​4] <br> | + | easy | 
  | SPIDER_dev_882 | Show the student IDs and numbers of friends corresponding to each. | SELECT student_id ,  count(*) FROM Friend GROUP BY student_id |  | 1. SELECT[col:​Friend:​student_id] <br>2. PROJECT[col:​Friend:​student_id, #1] <br>3. PROJECT[tbl:​Friend, #2] <br>4. GROUP[count, #3, #2] <br>5. UNION[#2, #4] <br> | + | medium | 
  | SPIDER_dev_883 | How many friends does each student have? | SELECT student_id ,  count(*) FROM Friend GROUP BY student_id |  | 1. SELECT[col:​Friend:​student_id] <br>2. PROJECT[tbl:​Friend, #1] <br>3. GROUP[count, #2, #1] <br>4. UNION[#1, #3] <br> | + | medium | 
  | SPIDER_dev_884 | Show the names of high school students and their corresponding number of friends. | SELECT T2.name ,  count(*) FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[col:​Highschooler:​name, #1] <br>3. PROJECT[tbl:​Friend, #1] <br>4. GROUP[count, #3, #1] <br>5. UNION[#2, #4] <br> | - | medium | 
  | SPIDER_dev_885 | What are the names of the high schoolers and how many friends does each have? | SELECT T2.name ,  count(*) FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[col:​Highschooler:​name, #1] <br>3. PROJECT[tbl:​Friend, #1] <br>4. GROUP[count, #3, #1] <br>5. UNION[#2, #4] <br> | - | medium | 
  | SPIDER_dev_886 | What is the name of the high schooler who has the greatest number of friends? | SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id ORDER BY count(*) DESC LIMIT 1 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Friend, #1] <br>3. GROUP[count, #2, #1] <br>4. SUPERLATIVE[comparative:​max:​None, #1, #3] <br>5. PROJECT[col:​Highschooler:​name, #4] <br> | - | extra | 
  | SPIDER_dev_887 | Return the name of the high school student with the most friends. | SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id ORDER BY count(*) DESC LIMIT 1 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Friend, #1] <br>3. GROUP[count, #2, #1] <br>4. SUPERLATIVE[comparative:​max:​None, #1, #3] <br>5. PROJECT[col:​Highschooler:​name, #4] <br> | - | extra | 
  | SPIDER_dev_888 | Show the names of high schoolers who have at least 3 friends. | SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id HAVING count(*)  >=  3 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Friend, #1] <br>3. GROUP[count, #2, #1] <br>4. COMPARATIVE[#1, #3, comparative:​>=:​3] <br>5. PROJECT[col:​Highschooler:​name, #4] <br> | - | medium | 
  | SPIDER_dev_889 | What are the names of high schoolers who have 3 or more friends? | SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id HAVING count(*)  >=  3 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Friend, #1] <br>3. GROUP[count, #2, #1] <br>4. COMPARATIVE[#1, #3, comparative:​>=:​3] <br>5. PROJECT[col:​Highschooler:​name, #4] <br> | - | medium | 
  | SPIDER_dev_890 | Show the names of all of the high schooler Kyle's friends. | SELECT T3.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id JOIN Highschooler AS T3 ON T1.friend_id  =  T3.id WHERE T2.name  =  "Kyle" |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Friend, #1] <br>3. COMPARATIVE[#2, #1, comparative:​=:​Kyle:​col:​Highschooler:​name] <br>4. PROJECT[col:​Highschooler:​name, #3] <br> | - | hard | 
  | SPIDER_dev_891 | Return the names of friends of the high school student Kyle. | SELECT T3.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id JOIN Highschooler AS T3 ON T1.friend_id  =  T3.id WHERE T2.name  =  "Kyle" |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Friend, #1] <br>3. COMPARATIVE[#2, #1, comparative:​=:​Kyle:​col:​Highschooler:​name] <br>4. PROJECT[col:​Highschooler:​name, #3] <br> | - | hard | 
  | SPIDER_dev_892 | How many friends does the high school student Kyle have? | SELECT count(*) FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id WHERE T2.name  =  "Kyle" |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Friend, #1] <br>3. COMPARATIVE[#2, #1, comparative:​=:​Kyle:​col:​Highschooler:​name] <br>4. AGGREGATE[count, #3] <br> | - | medium | 
  | SPIDER_dev_893 | Count the number of friends Kyle has. | SELECT count(*) FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id WHERE T2.name  =  "Kyle" |  | 1. SELECT[val:​Highschooler:​name:​Kyle] <br>2. PROJECT[tbl:​Friend, #1] <br>3. AGGREGATE[count, #2] <br> | - | medium | 
  | SPIDER_dev_894 | Show ids of all students who do not have any friends. | SELECT id FROM Highschooler EXCEPT SELECT student_id FROM Friend |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Friend] <br>3. DISCARD[#1, #2] <br>4. PROJECT[col:​Highschooler:​ID, #3] <br> | - | hard | 
  | SPIDER_dev_895 | What are the ids of high school students who do not have friends? | SELECT id FROM Highschooler EXCEPT SELECT student_id FROM Friend |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Friend] <br>3. DISCARD[#1, #2] <br>4. PROJECT[col:​Highschooler:​ID, #3] <br> | - | hard | 
  | SPIDER_dev_896 | Show names of all high school students who do not have any friends. | SELECT name FROM Highschooler EXCEPT SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Friend] <br>3. DISCARD[#1, #2] <br>4. PROJECT[col:​Highschooler:​name, #3] <br> | - | hard | 
  | SPIDER_dev_897 | What are the names of students who have no friends? | SELECT name FROM Highschooler EXCEPT SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Friend] <br>3. DISCARD[#1, #2] <br>4. PROJECT[col:​Highschooler:​name, #3] <br> | - | hard | 
  | SPIDER_dev_898 | Show the ids of high schoolers who have friends and are also liked by someone else. | SELECT student_id FROM Friend INTERSECT SELECT liked_id FROM Likes |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Friend] <br>3. COMPARATIVE[#2, #2, tbl:​Likes] <br>4. PROJECT[col:​Friend:​student_id, #3] <br> | - | hard | 
  | SPIDER_dev_899 | What are the ids of students who both have friends and are liked? | SELECT student_id FROM Friend INTERSECT SELECT liked_id FROM Likes |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, col:​Friend:​friend_id] <br>3. COMPARATIVE[#1, #1, tbl:​Likes] <br>4. INTERSECTION[#1, #2, #3] <br>5. PROJECT[col:​Friend:​student_id, #4] <br> | - | hard | 
  | SPIDER_dev_900 | Show name of all students who have some friends and also are liked by someone else. | SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id INTERSECT SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.liked_id  =  T2.id |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, col:​Friend:​friend_id] <br>3. COMPARATIVE[#2, #2, tbl:​Likes] <br>4. PROJECT[col:​Highschooler:​name, #3] <br> | - | hard | 
  | SPIDER_dev_901 | What are the names of high schoolers who both have friends and are liked? | SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id INTERSECT SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.liked_id  =  T2.id |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Friend] <br>3. COMPARATIVE[#1, #1, tbl:​Likes] <br>4. INTERSECTION[#1, #2, #3] <br>5. PROJECT[col:​Highschooler:​name, #4] <br> | - | hard | 
  | SPIDER_dev_902 | Count the number of likes for each student id. | SELECT student_id ,  count(*) FROM Likes GROUP BY student_id |  | 1. SELECT[col:​Likes:​student_id] <br>2. PROJECT[tbl:​Likes, #1] <br>3. GROUP[count, #2, #1] <br>4. UNION[#1, #3] <br> | + | medium | 
  | SPIDER_dev_903 | How many likes correspond to each student id? | SELECT student_id ,  count(*) FROM Likes GROUP BY student_id |  | 1. SELECT[col:​Likes:​student_id] <br>2. PROJECT[tbl:​Likes, #1] <br>3. GROUP[count, #2, #1] <br>4. UNION[#1, #3] <br> | + | medium | 
  | SPIDER_dev_904 | Show the names of high schoolers who have likes, and numbers of likes for each. | SELECT T2.name ,  count(*) FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Likes] <br>3. PROJECT[col:​Highschooler:​name, #2] <br>4. GROUP[count, #2, #3] <br>5. UNION[#3, #4] <br> | - | medium | 
  | SPIDER_dev_905 | What are the names of high schoolers who have likes, and how many likes does each have? | SELECT T2.name ,  count(*) FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Likes] <br>3. PROJECT[col:​Highschooler:​name, #2] <br>4. GROUP[count, #2, #3] <br>5. UNION[#3, #4] <br> | - | medium | 
  | SPIDER_dev_906 | What is the name of the high schooler who has the greatest number of likes? | SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id ORDER BY count(*) DESC LIMIT 1 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Likes, #1] <br>3. GROUP[count, #2, #1] <br>4. SUPERLATIVE[comparative:​max:​None, #1, #3] <br>5. PROJECT[col:​Highschooler:​name, #4] <br> | + | extra | 
  | SPIDER_dev_907 | Give the name of the student with the most likes. | SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id ORDER BY count(*) DESC LIMIT 1 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Likes, #1] <br>3. GROUP[count, #2, #1] <br>4. SUPERLATIVE[comparative:​max:​None, #1, #3] <br>5. PROJECT[col:​Highschooler:​name, #4] <br> | + | extra | 
  | SPIDER_dev_908 | Show the names of students who have at least 2 likes. | SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id HAVING count(*)  >=  2 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Likes, #1] <br>3. GROUP[count, #2, #1] <br>4. COMPARATIVE[#1, #3, comparative:​>=:​2] <br>5. PROJECT[col:​Highschooler:​name, #4] <br> | + | medium | 
  | SPIDER_dev_909 | What are the names of students who have 2 or more likes? | SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id GROUP BY T1.student_id HAVING count(*)  >=  2 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Likes, #1] <br>3. GROUP[count, #2, #1] <br>4. COMPARATIVE[#1, #3, comparative:​>=:​2] <br>5. PROJECT[col:​Highschooler:​name, #4] <br> | + | medium | 
  | SPIDER_dev_910 | Show the names of students who have a grade higher than 5 and have at least 2 friends. | SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id WHERE T2.grade  >  5 GROUP BY T1.student_id HAVING count(*)  >=  2 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Friend, #1] <br>3. GROUP[count, #2, #1] <br>4. COMPARATIVE[#1, #3, comparative:​>=:​5] <br>5. COMPARATIVE[#1, #3, comparative:​>=:​2] <br>6. INTERSECTION[#1, #4, #5] <br>7. PROJECT[col:​Highschooler:​name, #6] <br> | - | hard | 
  | SPIDER_dev_911 | What are the names of high schoolers who have a grade of over 5 and have 2 or more friends? | SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id WHERE T2.grade  >  5 GROUP BY T1.student_id HAVING count(*)  >=  2 |  | 1. SELECT[tbl:​Highschooler] <br>2. PROJECT[tbl:​Friend, #1] <br>3. GROUP[count, #2, #1] <br>4. COMPARATIVE[#1, #3, comparative:​>=:​2] <br>5. PROJECT[col:​Highschooler:​name, #1] <br>6. GROUP[count, #5, #1] <br>7. COMPARATIVE[#1, #6, comparative:​>=:​2] <br>8. INTERSECTION[#1, #4, #7] <br>9. PROJECT[col:​Highschooler:​name, #8] <br> | - | hard | 
  | SPIDER_dev_912 | How many likes does Kyle have? | SELECT count(*) FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id WHERE T2.name  =  "Kyle" |  | 1. SELECT[tbl:​Likes] <br>2. COMPARATIVE[#1, #1, comparative:​=:​Kyle:​col:​Highschooler:​name] <br>3. AGGREGATE[count, #2] <br> | + | medium | 
  | SPIDER_dev_913 | Return the number of likes that the high schooler named Kyle has. | SELECT count(*) FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id WHERE T2.name  =  "Kyle" |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, comparative:​=:​Kyle:​col:​Highschooler:​name] <br>3. PROJECT[tbl:​Likes, #2] <br>4. AGGREGATE[count, #3] <br> | + | medium | 
  | SPIDER_dev_914 | Find the average grade of all students who have some friends. | SELECT avg(grade) FROM Highschooler WHERE id IN (SELECT T1.student_id FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id) |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Friend] <br>3. PROJECT[col:​Highschooler:​grade, #2] <br>4. AGGREGATE[avg, #3] <br> | - | hard | 
  | SPIDER_dev_915 | What is the average grade of students who have friends? | SELECT avg(grade) FROM Highschooler WHERE id IN (SELECT T1.student_id FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id) |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Friend] <br>3. PROJECT[col:​Highschooler:​grade, #2] <br>4. AGGREGATE[avg, #3] <br> | - | hard | 
  | SPIDER_dev_916 | Find the minimum grade of students who have no friends. | SELECT min(grade) FROM Highschooler WHERE id NOT IN (SELECT T1.student_id FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id) |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Friend] <br>3. DISCARD[#1, #2] <br>4. PROJECT[col:​Highschooler:​grade, #3] <br>5. AGGREGATE[min, #4] <br> | - | extra | 
  | SPIDER_dev_917 | What is the lowest grade of students who do not have any friends? | SELECT min(grade) FROM Highschooler WHERE id NOT IN (SELECT T1.student_id FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id  =  T2.id) |  | 1. SELECT[tbl:​Highschooler] <br>2. COMPARATIVE[#1, #1, tbl:​Friend] <br>3. DISCARD[#1, #2] <br>4. PROJECT[col:​Highschooler:​grade, #3] <br>5. AGGREGATE[min, #4] <br> | - | extra | 
 ***
 Exec acc: **0.5179**
