[
  {
    "question": "What is the professor of person ID 51?",
    "SQL": "SELECT hasPosition FROM person WHERE p_id = 51",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course ID 141?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 141",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor with ID 179?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 179",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor ID 235?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id = 235)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the count of students who are in the post-generals phase?",
    "SQL": "SELECT COUNT(*) FROM person WHERE inPhase = 'Post_Generals' AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by each professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with p_id 52?",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course AS c JOIN taughtBy AS t ON c.course_id = t.course_id WHERE t.p_id = 52",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs that are taught by professor number 79?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are currently being taught by professor 171?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 171",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 175?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 175",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of students for each advisor?",
    "SQL": "SELECT CAST(COUNT(p_id) AS REAL) / COUNT(DISTINCT p_id_dummy) AS avgnum FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with course_id = 107?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 63?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 63",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors who have been in the program for more than 2 years?",
    "SQL": "SELECT COUNT(T1.course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram = 'Year_3'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 13?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 13",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 171?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 171",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has a professor position?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by Professor 165?",
    "SQL": "SELECT COUNT(*) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1 AND T2.p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students advised by each professor?",
    "SQL": "SELECT COUNT(*) FROM advisedBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by a professor with a position in the program?",
    "SQL": "SELECT COUNT(DISTINCT T1.p_id) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 0 AND T2.student = 1 AND T2.hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with courseLevel 'Level_500'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is both a professor and a student?",
    "SQL": "SELECT T2.p_id FROM person AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are level 500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are offered at the Level_500?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has both a professor and student role?",
    "SQL": "SELECT * FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person ID 204?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 204",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 181?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 181",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor who teaches the course with course_id 120?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 120",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have course level as 'Level_500'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has both the 'professor' and 'student' roles?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 18?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with ID 86?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 86",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find all the course IDs for master/graduate courses.",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 364?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 364",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) are taught by professor with ID 72?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 72",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by each professor?",
    "SQL": "SELECT COUNT(*) AS num FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1 GROUP BY taughtBy.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest courseLevel?",
    "SQL": "SELECT course_id FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 319?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 319",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in phase 0 of the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 335?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person IDs are advised by person ID 235?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses that Level_500 students are allowed to take?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by Professor Smith?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = '1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors?",
    "SQL": "SELECT DISTINCT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's name who teaches the most courses?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.p_id ORDER BY COUNT(T2.course_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram = 'Year_5' AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are all the students that are advised by a professor?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.student = 1 AND T2.professor = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the students who are advised by Professor Smith?",
    "SQL": "SELECT T1.p_id FROM person AS T1 JOIN advisedBy AS T2 ON T1.p_id = T2.p_id JOIN person AS T3 ON T2.p_id_dummy = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the students who have been advised by person with ID 79.",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching course ID 162?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 162",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by a specific professor with ID 79?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 240?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT COUNT(p_id) AS total_students FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of courses taught by each professor?",
    "SQL": "SELECT CAST(COUNT(course_id) AS REAL) / COUNT(DISTINCT p_id) AS avgnum FROM taughtBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND yearsInProgram = 'Year_5'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the course level of course with id 50",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 50",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor ID 181?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 181",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with ID 21?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 21",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor with a professor ID greater than 100?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1 AND p_id > 100)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs for courses taught by person ID 100?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 100",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the students in the person table.",
    "SQL": "SELECT p_id FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are Level_500 courses?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person in the person table is a professor?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has the most courses taught by them?",
    "SQL": "SELECT T1.student FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.p_id ORDER BY COUNT(T2.course_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor ID 298?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are Level 500 courses?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with ID 235?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by person with ID 324?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest student population?",
    "SQL": "SELECT T2.course_id FROM advisedBy AS T1 INNER JOIN course AS T2 ON T2.course_id = T1.p_id GROUP BY T2.course_id ORDER BY COUNT(T1.p_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person ID 255?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 255",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are Level_500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 373?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 373",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the student with ID 3?",
    "SQL": "SELECT T2.yearsInProgram FROM person AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 3",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 240?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor P_id 255?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 255",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is advising person with ID 242?",
    "SQL": "SELECT T1.p_id_dummy FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 242",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor 57?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 57",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a person with the id 40?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 40",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person IDs are currently advised by another person?",
    "SQL": "SELECT p_id FROM advisedBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at level 500?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the number of courses taught by a professor with ID 79.",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all course IDs for courses that are at Level 300.",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_300'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor 231?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 231",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by professor 335?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 335 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "how many students are there?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is currently a student and has been in the program for more than 4 years?",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND yearsInProgram LIKE 'Year_%'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is a professor and has a position in the program?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND hasPosition = 'Faculty' AND student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT SUM(student) AS total_students FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(p_id) AS num_students, p_id_dummy AS professor_id FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professor 415?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 324?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor 180?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 180",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor 72?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 72 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the IDs of all courses taught by a professor?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors advised by in the database?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course ID 93?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 93",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor John?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of course ID 139?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 139",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with id 97?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs of all courses taught by person ID 327?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 327",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by professor with ID 218?",
    "SQL": "SELECT COUNT(p_id) FROM advisedBy WHERE p_id_dummy = 218",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor ID 255?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 255",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 46?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 46",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course taught by professor 351?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are all the course levels that exist in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'Pre_Quals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level courses are being taught by professor ID 235?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of years a student has been in the program?",
    "SQL": "SELECT AVG(yearsInProgram) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 324?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID teaching course ID 166?",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 166",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor(s) is/are teaching the course with ID 27?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.course_id = 27",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 171?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 171",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are offered at Level_500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course ID 68?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 68",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 154?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 154",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 158?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 158",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 407?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the course IDs for professional or master/graduate courses.",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which is the advisor and the student id of the first advisor in the advisedBy table?",
    "SQL": "SELECT p_id, p_id_dummy FROM advisedBy LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses does person ID 331 teach?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which of these courses has course id 151?",
    "SQL": "SELECT * FROM course WHERE course_id = 151",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many years of experience does a student have in the program?",
    "SQL": "SELECT yearsInProgram FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 362?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T1.p_id_dummy = 362",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which is the course with the highest level of difficulty?",
    "SQL": "SELECT course_id FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 8?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 8",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by Professor Dr. Smith?",
    "SQL": "SELECT COUNT(*) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = 'Faculty' AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor Smith?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.student = 0 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT SUM(student) AS total_students FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the percentage of students among the total people in the database?",
    "SQL": "SELECT CAST(COUNT(student) AS REAL) * 100 / (SELECT COUNT(*) FROM person) FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of years in the program for students who have advised at least one person?",
    "SQL": "SELECT AVG(T2.yearsInProgram) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels have courses taught by professor with ID 255?",
    "SQL": "SELECT DISTINCT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 255",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 298?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Is the person with ID 115 a professor?",
    "SQL": "SELECT professor FROM person WHERE p_id = 115",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 22?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 22",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 228?",
    "SQL": "SELECT p_id_dummy FROM advisedBy WHERE p_id = 228",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor with the highest number of students they have advised?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.hasPosition ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by Professor Smith?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id = (SELECT p_id FROM person WHERE hasPosition = '1' AND professor = '1' AND student = '1')",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 293?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 293",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a course level of 'Level_400'?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT SUM(student) FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching course ID 93?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 93",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 82?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 82",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the 400 level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are level 500?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are supervised by a professor with an in-phase status of 'Pre_Quals'?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND p_id IN (SELECT p_id FROM advisedBy WHERE p_id_dummy IN (SELECT p_id FROM person WHERE professor = 1 AND inPhase = 'Pre_Quals'))",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by person with ID 381?",
    "SQL": "SELECT p_id_dummy FROM advisedBy WHERE p_id = 381",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor with ID 293?",
    "SQL": "SELECT T2.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 293",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person ID 180?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 180",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with the highest level?",
    "SQL": "SELECT course_id , courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person ID 45?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 45",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(p_id) AS num_students, COUNT(p_id_dummy) AS num_advisors FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor teaching the course with ID 36?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.course_id = 36",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs and their corresponding course levels for master's courses?",
    "SQL": "SELECT course_id, courseLevel FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by the person with ID 275?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id_dummy = 275",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the course IDs for professional or master/graduate courses.",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the advisors for student ID 331?",
    "SQL": "SELECT T1.p_id_dummy FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1 AND T1.p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by at least one professor?",
    "SQL": "SELECT COUNT(DISTINCT p_id) FROM advisedBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 120?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 120",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 351?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 9?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 9",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 72?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 72",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 1?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor with the ID 324?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest average student enrollment?",
    "SQL": "SELECT c.course_id FROM course c JOIN advisedBy a ON c.course_id = a.p_id GROUP BY c.course_id ORDER BY AVG(a.p_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in Phase 'Post_Quals'?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'Post_Quals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are available at Level 500?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor 52?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 52",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor teaching course ID 170?",
    "SQL": "SELECT T2.hasPosition FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 170",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "A query that lists all the student IDs that are advised by a specific professor.",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor with ID 394?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is both a professor and a student?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor of person ID 159?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 159",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the student ID 163 advised by?",
    "SQL": "SELECT p_id_dummy FROM advisedBy WHERE p_id = 163",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 57?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 57",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is the advisor to a student?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by person ID 331?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id_dummy = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many years of experience do students in the program have?",
    "SQL": "SELECT AVG(yearsInProgram) AS avg_years FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average course level for courses taught by professor with ID 235?",
    "SQL": "SELECT AVG(CAST(T1.courseLevel AS REAL)) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT T1.p_id, COUNT(T2.p_id) AS student_count FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with p_id 293?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 293",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 164?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 164",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 179?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 179",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 324?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor ID 185?",
    "SQL": "SELECT DISTINCT p_id FROM advisedBy WHERE p_id_dummy = 185",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors with a yearsInProgram greater than 5?",
    "SQL": "SELECT COUNT(*) FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id INNER JOIN course ON taughtBy.course_id = course.course_id WHERE person.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the database?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by professor with ID 331?",
    "SQL": "SELECT COUNT(p_id) FROM advisedBy WHERE p_id_dummy = (SELECT p_id FROM person WHERE p_id = 331 AND professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 116?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 116",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who teaches course ID 18?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the Pre_Quals phase of the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE inPhase = 'Pre_Quals' AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by each professor?",
    "SQL": "SELECT COUNT(course_id) AS totalCourses , p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are all the course IDs that are taught by person ID 411?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 411",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 213?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have students advised by person ID 426?",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN advisedBy a ON t.p_id = a.p_id WHERE a.p_id = 426",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professor with ID 324?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are Level_400?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are level 500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the names of all persons who are both students and professors.",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses?",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with p_id 79?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the names of all students who are being advised by person with ID 331.",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor ID 248?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 248",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the student's ID and the name of the person with the highest years in program?",
    "SQL": "SELECT p_id, inPhase FROM person WHERE yearsInProgram = ( SELECT MAX(yearsInProgram) FROM person )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by professor with ID 370?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 370",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all students who are advised by professor with ID 270?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 270",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person with the highest yearsInProgram?",
    "SQL": "SELECT p_id FROM person ORDER BY yearsInProgram DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are all the professors in the system?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by person with ID 212?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 212",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the number of courses taught by each professor.",
    "SQL": "SELECT COUNT(course_id), p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course ID 66?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 66",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(*) AS student_count, COUNT(DISTINCT p_id_dummy) AS professor_count FROM advisedBy WHERE p_id_dummy = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by person 384?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 384",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course IDs have a student who has been in the program for 3 years?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.yearsInProgram = 'Year_3'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs and the corresponding course levels for all courses?",
    "SQL": "SELECT course_id, courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) does professor 342 teach?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(course_id), p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person IDs are advisors to the person with ID 234?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 234",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by professor with ID 79?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id_dummy = 79 AND T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are offered by professors?",
    "SQL": "SELECT DISTINCT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's name who is teaching the course with the highest courseLevel?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel = ( SELECT MAX(courseLevel) FROM course )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at Level 300?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_300'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course ID 76?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 76",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the course IDs that are taught by person ID 364.",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 364",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by person with ID 335?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are there in the person table?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with ID 76?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 76",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's name who teaches course ID 56?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.course_id = 56",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is course 173?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 173",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(course_id) AS numCourses, p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with ID 415?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the courses that have more than one professor teaching them.",
    "SQL": "SELECT T1.course_id FROM course AS T1 JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id HAVING COUNT(DISTINCT T2.p_id) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has advised the most students?",
    "SQL": "SELECT p_id FROM advisedBy GROUP BY p_id ORDER BY COUNT(p_id_dummy) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with the highest number of students advised?",
    "SQL": "SELECT T1.course_id FROM course AS T1 JOIN advisedBy AS T2 ON T1.course_id = T2.p_id GROUP BY T1.course_id ORDER BY COUNT(T2.p_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many different courses are being taught by person with ID 150?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses of level Level_400 are there?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with ID 279?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 279",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with ID 115?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 115",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor ID 40?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 40",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of students for each advisor?",
    "SQL": "SELECT CAST(COUNT(p_id) AS REAL) / COUNT(DISTINCT p_id_dummy) AS avgnum FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by person ID 407?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course ID 61?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 61",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by at least two professors?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 GROUP BY T1.course_id HAVING COUNT(T1.p_id) >= 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by a professor who has been in the program for more than 3 years?",
    "SQL": "SELECT DISTINCT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram > 3",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course with course ID 166?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 166",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently advised by person with ID 5?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students currently enrolled in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the database?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a faculty position?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1 AND hasPosition = 'Faculty')",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the people who are both professors and students.",
    "SQL": "SELECT * FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with ID 235?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have a position in the program?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person ID 107?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors in the program?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor ID of the person who is teaching course ID 122?",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 122",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of course with course ID 71?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 71",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 375?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 80?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 80",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the students advised by professor ID 407?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 407 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that Professor 235 is teaching?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course IDs are being taught by professor with ID 240?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are level 500?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 72?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 72",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor 211?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id_dummy = 211 AND T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person ID 375?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the course IDs for professional or master/graduate courses.",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT SUM(student) FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in Phase 1 of the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'Phase_1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at Level_400?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by professor with ID 27?",
    "SQL": "SELECT COUNT(*) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 27",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are being advised by a person who has been in the program for more than 3 years?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.yearsInProgram > 3",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 120?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 120",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with ID 324?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by person ID 61?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 61",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor with ID 293?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 293",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program for at least 5 years?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND yearsInProgram >= 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with ID 213?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level is course ID 45?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 45",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs and their corresponding course levels for all courses?",
    "SQL": "SELECT course_id, courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by professor 290?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 290",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest level course taught by person with ID 79?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 79 ORDER BY T2.courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a person with a professor position?",
    "SQL": "SELECT COUNT(DISTINCT T2.course_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is course 131?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 131",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 44?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 44",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each advisor?",
    "SQL": "SELECT COUNT(p_id) AS num_students FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person with ID 189?",
    "SQL": "SELECT p_id FROM person WHERE p_id = 189",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors have advised students?",
    "SQL": "SELECT DISTINCT T2.professor FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by professor ID 211?",
    "SQL": "SELECT COUNT(p_id) FROM advisedBy WHERE p_id_dummy = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with ID 324?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have a course level of 'Level_500'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professor 267?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 267",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are advising students?",
    "SQL": "SELECT T1.professor FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by each professor?",
    "SQL": "SELECT COUNT(course_id), p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 72?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 72",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person ID 104?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students have advised by person ID 41?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 41 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 410?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 410",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "SQL query to find the number of students who are advised by a particular professor",
    "SQL": "SELECT COUNT(DISTINCT p_id) FROM advisedBy WHERE p_id_dummy IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 324?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with id 326?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 326",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students have advised by person with ID 426?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id = 426",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(T1.p_id_dummy) AS NumberOfStudents, T1.p_id_dummy AS StudentID FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.student = 1 AND T2.professor = 0 GROUP BY T1.p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professor with ID 22?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 22",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by both professors and students?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 324?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with the highest number of students?",
    "SQL": "SELECT T1.course_id, T2.student FROM course AS T1 INNER JOIN person AS T2 ON T2.student = 1 WHERE T2.yearsInProgram > 0 ORDER BY T2.yearsInProgram DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) are taught by professor with ID 120?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 120",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 17?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 17",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course with course ID 35?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 35",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students enrolled in the course with course ID 124?",
    "SQL": "SELECT COUNT(student) FROM person WHERE p_id IN (SELECT student FROM advisedBy WHERE p_id = (SELECT p_id FROM taughtBy WHERE course_id = 124))",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who has the position 'Faculty_adj'?",
    "SQL": "SELECT T1.p_id FROM person AS T1 WHERE T1.hasPosition = 'Faculty_adj'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest course level available?",
    "SQL": "SELECT MAX(courseLevel) AS highest_level FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 324?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all the courses that have a professor as a teacher?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by Professor?",
    "SQL": "SELECT T1.student FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students in the program?",
    "SQL": "SELECT COUNT(p_id) AS student_count FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 107?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are currently being taught by professors?",
    "SQL": "SELECT COUNT(DISTINCT T2.course_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at level 500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor with ID 46?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 46",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest level course?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor ID of the person teaching course ID 101?",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are Level_400?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the level of Level_500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor ID 181?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 181",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor with ID 10?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person ID 293?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 293",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) are taught by professor with ID 351?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 104?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 394?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with id 231?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 231",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course IDs are taught by professional or master/graduate students?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel IN ('Level_400', 'Level_500')",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are level 500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1 AND hasPosition = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of course ID 68?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 68",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by professor with ID 342?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id_dummy WHERE T2.p_id = 342 AND T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by person with p_id 22?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 22",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by person with id 98?",
    "SQL": "SELECT T1.course_id, T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 98",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor with the ID 331?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professors?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 331?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of students for each advisor?",
    "SQL": "SELECT CAST(COUNT(p_id) AS REAL) / COUNT(DISTINCT p_id_dummy) AS avgnum FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the count of all students in the database?",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is both a professor and a student?",
    "SQL": "SELECT * FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by professor with ID 101?",
    "SQL": "SELECT COUNT(*) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T1.p_id_dummy = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 303?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 303",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND hasPosition = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with p_id 103?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 103",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs of all courses that have Level_200 as their course level?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_200'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there for Level_500 students?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students in the program?",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 335?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 134?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 134",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 31?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 31",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in Phase 'In_Prep'?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'In_Prep'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) is/are taught by professor with p_id 46?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 46",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students have an advisor with id 79?",
    "SQL": "SELECT COUNT(p_id) FROM advisedBy WHERE p_id_dummy = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students currently in the program?",
    "SQL": "SELECT SUM(student) AS total_students FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by the person with ID 213?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor ID 378?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 378",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has the most advisors?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1 GROUP BY T1.p_id ORDER BY COUNT(T1.p_id_dummy) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT SUM(student) FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 115?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.p_id = 115",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the program?",
    "SQL": "SELECT COUNT(*) AS student_count FROM person WHERE student = 1 AND inPhase = 'Enrolled'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest course level in the database?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professors ?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course ID of the course taught by professor 415?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor with ID 351?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor ID 211?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 165?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 297?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 297",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by person with ID 335?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with ID 46?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 46",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by person with ID 298?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is course ID 32?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 32",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND yearsInProgram > 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with course ID 161?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 161",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the student with ID 138?",
    "SQL": "SELECT student FROM person WHERE p_id = 138",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the total number of advisors and the average number of students for each advisor?",
    "SQL": "SELECT COUNT(*) , CAST(COUNT(p_id) AS REAL) / COUNT(DISTINCT p_id_dummy) AS avgnum FROM advisedBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(course_id), p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level does a student with the id 368 have ?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.p_id = 368",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 342?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course ID for the course taught by Professor 375?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor 79?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with ID 375?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 101?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id_dummy = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person with the most years in the program?",
    "SQL": "SELECT p_id FROM person ORDER BY yearsInProgram DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) have courseLevel 'Level_400'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 390?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 390",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course that is being taught by professor with ID 5?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are there in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 103?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 103",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has advised another person?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 JOIN advisedBy AS T2 ON T1.p_id = T2.p_id_dummy WHERE T1.p_id != T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all courses taught by a professor with more than 5 years of experience?",
    "SQL": "SELECT DISTINCT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have been taught by professor with ID 72?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 72",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students enrolled in each course?",
    "SQL": "SELECT COUNT(*) FROM taughtBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by person ID 116?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id = 116",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person(s) are both a professor and a student?",
    "SQL": "SELECT * FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor 290?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 290",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the count of distinct students in the 'advisedBy' table?",
    "SQL": "SELECT COUNT(DISTINCT p_id_dummy) FROM advisedBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are offered at Level_500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 107?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 38?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 38",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List the number of courses taught by each professor in the person table.",
    "SQL": "SELECT COUNT(course_id) AS numCourses, p_id AS professorID FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1) GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the students advised by professor with ID 45?",
    "SQL": "SELECT DISTINCT p_id_dummy FROM advisedBy WHERE p_id = 45",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with ID 137?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 137",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with ID 5?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by a specific professor?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person ID 267?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 267",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT T2.professor, COUNT(T1.p_id) AS num_advised FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.professor = 1 GROUP BY T2.professor",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 364?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 364",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 45?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.p_id = 45",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who has advised at least three students?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.p_id HAVING COUNT(T2.p_id_dummy) >= 3",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "The course with course ID 103 is at what level?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 103",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the advisors for the student with p_id 107?",
    "SQL": "SELECT T1.p_id_dummy FROM advisedBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with ID 146?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 146",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level does the course with ID 135 have?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 135",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) are taught by professor with ID 79?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest course level in the database?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 165?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 375?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each person?",
    "SQL": "SELECT p_id, COUNT(course_id) AS numCoursesTaught FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in total?",
    "SQL": "SELECT COUNT(course_id) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the count of students in the person table?",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the count of courses taught by each professor?",
    "SQL": "SELECT COUNT(*) AS num FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are there in the database?",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at level 400?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is advising person ID 415?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor ID 211?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has a position and is in phase?",
    "SQL": "SELECT * FROM person WHERE hasPosition = '1' AND inPhase = '1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professor with ID 124?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 124",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the student with the highest yearsInProgram?",
    "SQL": "SELECT p_id FROM person WHERE student = 1 ORDER BY yearsInProgram DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the total number of advisors for p_id 150?",
    "SQL": "SELECT COUNT(p_id) FROM advisedBy WHERE p_id_dummy = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest course ID?",
    "SQL": "SELECT MAX(course_id) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 417?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 417",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students who are advised by each professor?",
    "SQL": "SELECT COUNT(DISTINCT T2.p_id) AS num_students, T1.p_id AS professor FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id_dummy WHERE T1.professor = 1 GROUP BY T1.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 23?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 23",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by person ID 380?",
    "SQL": "SELECT T1.student FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id_dummy WHERE T2.p_id = 380",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professors who have more than 5 years of experience?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T1.p_id_dummy = T3.p_id WHERE T3.student = 1 AND T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professor with ID 235?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID for the course with ID 49?",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 49",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by more than one person?",
    "SQL": "SELECT course_id FROM taughtBy GROUP BY course_id HAVING COUNT(p_id) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the students advised by person with ID 426?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id_dummy WHERE T2.p_id = 426 AND T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs taught by person with ID 279?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 279",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by person ID 407?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by each professor?",
    "SQL": "SELECT COUNT(course_id) AS totalCourses FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the person IDs of all students who are advised by someone with position 1.",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T1.p_id_dummy = T3.p_id WHERE T2.student = 1 AND T3.hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by more than one person?",
    "SQL": "SELECT p_id FROM advisedBy GROUP BY p_id HAVING COUNT(p_id_dummy) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 159?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T1.p_id_dummy = 159",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 12?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 12",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course 83?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 83",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course that is taught by person with id 107?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the students who have advised by professor 419.",
    "SQL": "SELECT p_id_dummy FROM advisedBy WHERE p_id = 419",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the person IDs who are both professors and students.",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT T2.p_id, COUNT(DISTINCT T1.p_id) AS num_students FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.professor = 1 GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the count of professors who are also students?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are currently being taught?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person IDs are advised by person ID 165?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who has been in the program for more than 5 years?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 407?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor ID of the person who is both a professor and a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Fill in the following sentence with the number of students for a particular person. This person has an ID of 340 and is a student. We want to know how many students this person has advised.",
    "SQL": "SELECT COUNT(*) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.p_id = 340 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Select the number of courses each professor is teaching.",
    "SQL": "SELECT T2.p_id, COUNT(DISTINCT T1.course_id) AS numberOfCourses FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who has the position of 'Faculty'?",
    "SQL": "SELECT p_id FROM person WHERE hasPosition = 'Faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor ID 180?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 180",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are teaching the course with course ID 153?",
    "SQL": "SELECT T2.hasPosition FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 153",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person ID 375?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with p_id 204?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 204",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person who is a student?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE student = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which level courses are taught by person ID 165?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 3 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram = 'Year_4' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor ID 32?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 32",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = '0'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by person with ID 407?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the students advised by person with ID 279?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 279",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor 351?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest course level among all courses?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 155?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 155",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses of each level are there?",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of students for each advisor?",
    "SQL": "SELECT CAST(COUNT(p_id) AS REAL) / COUNT(DISTINCT p_id_dummy) AS avgnum FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor with p_id 101?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with the highest courseLevel?",
    "SQL": "SELECT course_id, courseLevel FROM course WHERE courseLevel = (SELECT MAX(courseLevel) FROM course)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person IDs are advised by person ID 168?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 168",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students advised by each professor?",
    "SQL": "SELECT COUNT(*) , T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T2.p_id_dummy = T3.p_id WHERE T3.student = 1 GROUP BY T1.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 51?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 51",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by the person with ID 240?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses offered by professors?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by professor ID 190?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 190",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 335?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses at the Level_500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is both a professor and a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person ID 240?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is both a professor and a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students currently in the program?",
    "SQL": "SELECT SUM(student) FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List the IDs of all courses that are taught by person with ID 98.",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 98",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are all the course IDs that are being taught by a professor with ID 165?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students being advised by each professor?",
    "SQL": "SELECT COUNT(T1.p_id_dummy), T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T2.p_id = T1.p_id WHERE T2.professor = 1 GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest course level in the database?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the course IDs taught by professors with more than 10 years in the program.",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are enrolled in course ID 150?",
    "SQL": "SELECT COUNT(DISTINCT p_id) FROM advisedBy WHERE p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the student ID of the student who has the most advanced position?",
    "SQL": "SELECT p_id FROM person WHERE hasPosition = 'PostDoc' ORDER BY yearsInProgram DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for a specific course?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with ID 147?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 147",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course_id 82?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 82",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 368?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 368",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the course IDs taught by professors.",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest level of course offered in the database?",
    "SQL": "SELECT MAX(courseLevel) AS highestLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the count of students who are currently in phase 'Post_Generals'?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'Post_Generals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT T1.p_id, COUNT(T2.p_id) AS num_students FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id_dummy WHERE T1.professor = 1 GROUP BY T1.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is both a professor and a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest number of students?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses offered at Level_300?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_300'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase != 'Post_Generals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 135?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 135",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the student IDs and the names of the advisors for each student.",
    "SQL": "SELECT T1.p_id, T2.p_id_dummy FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND hasPosition = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor ID 407?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor 171?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 171",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs of all the courses taught by professor with ID 267?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 267",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person ID 47?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 47",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in each level of the program?",
    "SQL": "SELECT hasPosition, COUNT(*) AS num FROM person GROUP BY hasPosition",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "The number of distinct courses taught by a specific professor.",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with ID 7?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 7",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses is professor with p_id 63 teaching?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 63",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students in the person table?",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course taught by the professor with ID 324?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor ID 57?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 57",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with ID 72?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 72",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 107?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "who is the student who has been in the program for 6 years?",
    "SQL": "SELECT p_id FROM person WHERE yearsInProgram LIKE 'Year_%' AND student = 1 LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID who is teaching course with ID 51?",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 51",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are there in total?",
    "SQL": "SELECT SUM(student) AS total_students FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with course ID 143?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 143",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course ID 162?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 162",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the master/graduate level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 298?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor 267?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 267",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor has advised the most students?",
    "SQL": "SELECT T2.hasPosition, COUNT(DISTINCT T1.p_id_dummy) AS num_students FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1 GROUP BY T1.p_id ORDER BY num_students DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by professor with ID 79?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of years students have been in the program?",
    "SQL": "SELECT AVG(yearsInProgram) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses with courseLevel 'Level_500'?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the student ID and the student status of the person with person ID 23?",
    "SQL": "SELECT student, hasPosition FROM person WHERE p_id = 23",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs that are taught by professors in Year_3 of the program?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1 AND T2.yearsInProgram = 'Year_3'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT DISTINCT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with ID 155?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 155",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor p_id 150?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 57?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 57",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor with ID 331?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 118?",
    "SQL": "SELECT p_id_dummy FROM advisedBy WHERE p_id = 118",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 27?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 27",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level has the most courses?",
    "SQL": "SELECT courseLevel FROM course GROUP BY courseLevel ORDER BY COUNT(course_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in Level 500 courses?",
    "SQL": "SELECT COUNT(DISTINCT T1.p_id) FROM person AS T1 JOIN advisedBy AS T2 ON T1.p_id = T2.p_id JOIN course AS T3 ON T2.p_id_dummy = T3.course_id WHERE T1.student = 1 AND T3.courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest course level in the course table?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 18?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course 120?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 120",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(DISTINCT T2.p_id) AS num_students, T2.p_id_dummy AS professor_id FROM advisedBy AS T2 JOIN person AS T1 ON T1.p_id = T2.p_id_dummy GROUP BY T2.p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are currently teaching in the program?",
    "SQL": "SELECT COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the person IDs of students.",
    "SQL": "SELECT p_id FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 297?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 297",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are there in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses offered at the 400 level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "The query is to find the number of students currently in the program.",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the total number of advised relationships between students and advisors.",
    "SQL": "SELECT COUNT(*) FROM advisedBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 156?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 156",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 134?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 134",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course ID of the course taught by professor with p_id 292?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 292",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with id 150?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students who are part of the 'Pre_Quals' phase?",
    "SQL": "SELECT SUM(student) FROM person WHERE inPhase = 'Pre_Quals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in Level_400?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the course with ID 153?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 153",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT SUM(student) FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 30?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 30",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 150?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor with p_id 235?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the total number of courses taught by each professor?",
    "SQL": "SELECT COUNT(course_id) AS total_num FROM taughtBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by Professor 407?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor with ID 235?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 201?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are all the unique student IDs in the database?",
    "SQL": "SELECT DISTINCT p_id FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at Level_500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the names of all professors who have taught a course.",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are offered by person with ID 150?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor ID 1?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is a student?",
    "SQL": "SELECT p_id FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(DISTINCT p_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(*) AS num_students, T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1 AND T2.professor = 0 GROUP BY T1.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by more than 2 professors?",
    "SQL": "SELECT course_id FROM taughtBy GROUP BY course_id HAVING COUNT(DISTINCT p_id) > 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of years in the program for students?",
    "SQL": "SELECT CAST(SUM(yearsInProgram) AS REAL) / COUNT(*) AS avgyears FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1 AND hasPosition = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by person ID 63?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id_dummy = 63 AND T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with ID 83?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 83",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the post-qualifications phase?",
    "SQL": "SELECT COUNT(*) FROM person WHERE inPhase = 'Post_Quals' AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors have more than 1 student?",
    "SQL": "SELECT T2.p_id, COUNT(*) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 GROUP BY T1.p_id HAVING COUNT(*) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with ID 150?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.p_id = 150 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students have a professor assigned to them?",
    "SQL": "SELECT COUNT(DISTINCT p_id) FROM advisedBy WHERE p_id IN (SELECT p_id FROM person WHERE student = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 151?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 151",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with ID 36?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 36",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the database?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of students advised by each professor?",
    "SQL": "SELECT CAST(COUNT(DISTINCT p_id) AS REAL) / COUNT(DISTINCT p_id_dummy) AS avgnum FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is advising person with ID 37?",
    "SQL": "SELECT T1.p_id_dummy FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 37",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are all the distinct students who are advised by professor ID 180?",
    "SQL": "SELECT DISTINCT p_id FROM advisedBy WHERE p_id_dummy = 180",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor with ID 370?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 370",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 290?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 290",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the person table?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course ID 125?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 125",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor with p_id 375?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person ID 165?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor 255?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.p_id = 255",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a person with a professor position?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 12?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 12",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(p_id) FROM advisedBy WHERE p_id_dummy IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with course ID 131?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 131",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person ID 79?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 18?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the student count for the advisor with p_id 124?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id_dummy = 124",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with ID 56?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 56",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by professor ID 171?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 171",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches the course with ID 24?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 24",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 234?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 234",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 407?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by each person?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students have advised by a professor?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1 AND T2.professor = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by professor with ID 57?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id = 57",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the students who are advised by professor ID 180.",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T1.p_id = 180 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 114?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are Level_400?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 290?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 290",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are currently not in the program?",
    "SQL": "SELECT p_id FROM person WHERE inPhase = '0' AND professor = '1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the course IDs for professional or master/graduate courses.",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each advisor?",
    "SQL": "SELECT COUNT(p_id_dummy) AS num_students, p_id FROM advisedBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses level 400?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(p_id) / COUNT(DISTINCT p_id_dummy) AS avgnum FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the course IDs taught by a specific professor.",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is both a student and a professor?",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in Phase 'Post_Generals'?",
    "SQL": "SELECT COUNT(*) FROM person WHERE inPhase = 'Post_Generals' AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of course with course ID 170?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 170",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor ID 240?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) is/are taught by professor ID 240?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students who have a position as a professor?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT SUM(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has the highest number of courses taught?",
    "SQL": "SELECT p_id FROM taughtBy GROUP BY p_id ORDER BY COUNT(course_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor ID of the person who is both a professor and a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with ID 3?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 3",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the course IDs for professional or master/graduate courses.",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of years students have spent in the program?",
    "SQL": "SELECT AVG(yearsInProgram) AS avg_years FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 211?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students in the system?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 290?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 290",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professor with ID 123?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average years in program for students?",
    "SQL": "SELECT AVG(yearsInProgram) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each advisor?",
    "SQL": "SELECT COUNT(p_id) AS numStudents, p_id_dummy AS advisorID FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many people are currently in the program?",
    "SQL": "SELECT COUNT(*) AS totalPeople FROM person WHERE inPhase = '1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 114?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with ID 144?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 144",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all the courses taught by a professor with ID 23?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 23",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by person ID 240?",
    "SQL": "SELECT T1.student FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id_dummy = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 28?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 28",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with ID 71?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 71",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the names of all courses taught by person with ID 235.",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the Level_500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 124?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 124",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of courses per professor?",
    "SQL": "SELECT CAST(COUNT(course_id) AS REAL) / COUNT(DISTINCT p_id) AS avgnum FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching course ID 161?",
    "SQL": "SELECT T2.hasPosition FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 161",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(DISTINCT p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all professors in the database?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a course level of 'Level_500'?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students for each professor?",
    "SQL": "SELECT COUNT(DISTINCT p_id) AS numStudents FROM person WHERE professor = 1 GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 335?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor p_id 351?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors advised by student ID 124?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 124 AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor who has been in the program for more than 5 years?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the count of students who are also advisors?",
    "SQL": "SELECT COUNT(*) FROM advisedBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 407?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by professor ID 335?",
    "SQL": "SELECT COUNT(DISTINCT p_id_dummy) FROM advisedBy WHERE p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor with ID 200?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 200",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professor with ID 326?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 326",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 378?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 378",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the database?",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the course IDs for undergraduate courses.",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_100'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students advised by each professor?",
    "SQL": "SELECT COUNT(*) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has been in the program for more than 5 years?",
    "SQL": "SELECT * FROM person WHERE yearsInProgram = 'Year_6'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course IDs are taught by professors who have a position of 'Faculty'?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = 'Faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who teaches course ID 21?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 21",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with ID 179?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 179",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with ID 248?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 248",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 156?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 156",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who teaches the course with the highest course ID?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id ORDER BY T2.course_id DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all the courses taught by a specific person?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 180",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are being taught by person with ID 165?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 159?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 159",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 21?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 21",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses at Level_300?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_300'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than one student?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id HAVING COUNT(DISTINCT T2.p_id) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are offered at the Level_500 level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by professor 319?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 319",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by person with p_id 201?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses at Level_300?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_300'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course ID is taught by person with ID 342?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the student with the highest years in program?",
    "SQL": "SELECT p_id FROM person WHERE student = 1 ORDER BY yearsInProgram DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position of 'Faculty'?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = 'Faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses at Level_400?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID who is teaching the course with ID 148?",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 148",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the student IDs of students who are advised by professor with ID 101.",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the courses that are taught by person with ID 107.",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course that is being taught by professor with ID 79?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 165?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 165 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average years in program for students in the post-quals phase?",
    "SQL": "SELECT AVG(yearsInProgram) FROM person WHERE inPhase = 'Post_Quals' AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are being advised by professor 104?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT T2.p_id AS professor_id, COUNT(T1.course_id) AS course_count FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with ID 91?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 91",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course levels are available in the course table?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with ID 68?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 68",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c INNER JOIN taughtBy t ON c.course_id = t.course_id INNER JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the students who are advised by a professor with ID 101.",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id_dummy = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a course level greater than 'Level_300'?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel > 'Level_300'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID who teaches a Level_500 course?",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id IN (SELECT course_id FROM course WHERE courseLevel = 'Level_500')",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(p_id) AS numStudents, COUNT(DISTINCT p_id_dummy) AS numProfessors FROM advisedBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are all the professors who are teaching course ID 103?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.course_id = 103",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by professor ID 201?",
    "SQL": "SELECT COUNT(p_id) FROM advisedBy WHERE p_id_dummy = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor ID 75?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 75",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs that are taught by professor 18?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are being advised by a professor?",
    "SQL": "SELECT COUNT(DISTINCT p_id) FROM advisedBy WHERE p_id_dummy IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with id 103?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 103",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the students who are also advisors",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students associated with each advisor?",
    "SQL": "SELECT COUNT(p_id) AS student_count FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest level of a course?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Identify all courses that are taught by a person who has a position in the program and is a student.",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 1 AND p.hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with course ID 61?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 61",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(T1.course_id) AS numCourses, T2.p_id AS professorID FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professor with ID 5?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are all the unique course IDs that are taught by professors?",
    "SQL": "SELECT DISTINCT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest level of a course in the database?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching the course with course ID 36?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.course_id = 36",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person ID 235?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program for more than 2 years?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1 AND yearsInProgram = 'Year_3'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professors with more than 10 years in the program?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE yearsInProgram > 10)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List the names of all people who are both professors and students.",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND hasPosition = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses that are either professional or master/graduate courses?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 79?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses at level 500?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course IDs are taught by professor 235?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT T1.hasPosition, COUNT(T2.p_id) AS numberOfStudents FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id_dummy WHERE T1.professor = 1 GROUP BY T1.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 27?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 27",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 152?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 152",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the phase of 1?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students enrolled in the database?",
    "SQL": "SELECT SUM(student) FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professor with ID 351?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the post-qualifications phase?",
    "SQL": "SELECT COUNT(*) FROM person WHERE hasPosition = 0 AND inPhase = 'Post_Quals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT SUM(student) FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the Level_400?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with ID 279?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 279",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by a professor with ID 349?",
    "SQL": "SELECT COUNT(p_id) FROM advisedBy WHERE p_id_dummy IN (SELECT p_id FROM person WHERE p_id = 349)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 100?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 100",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course taught by professor with id 235?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the course IDs for undergraduate or master/graduate courses.",
    "SQL": "SELECT course_id FROM course WHERE courseLevel IN ('Level_400', 'Level_500')",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many advisors does each student have?",
    "SQL": "SELECT COUNT(p_id_dummy) FROM advisedBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students have been advised by professor 14?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 14 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course ID 120?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 120",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(p_id) AS num_students, p_id_dummy AS advisor_id FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level of course does professor 1 teach?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are Level 500?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor ID 218?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T1.p_id_dummy = 218",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 72?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 72",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of course with course ID 170?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 170",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are involved in teaching the course with course ID 49?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 49",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the course IDs for professional or master/graduate courses.",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person IDs are advised by person ID 124?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 124",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching course with ID 19?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.course_id = 19",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is currently not a student?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 0 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the student IDs of students who are advised by a professor with ID 393.",
    "SQL": "SELECT p_id_dummy FROM advisedBy WHERE p_id = 393",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(T1.p_id), T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.professor = 1 GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs of the courses taught by person ID 373?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 373",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by another person in the program?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy IN ( SELECT p_id FROM person WHERE student = 1 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by professor ID 231?",
    "SQL": "SELECT COUNT(p_id_dummy) FROM advisedBy WHERE p_id = 231",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many different courses are taught by professor with ID 331?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with ID 65?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 65",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professor ID 201?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest course level in the database?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND inPhase = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by a specific professor?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id_dummy IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with ID 394?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many years a student has been in the program?",
    "SQL": "SELECT yearsInProgram FROM person WHERE student = 1 LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(p_id) AS student_count, COUNT(DISTINCT p_id_dummy) AS professor_count FROM advisedBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with p_id 99?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T1.p_id = 99",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 139?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 139",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 331?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 9?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 9",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professor ID 342?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 53?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 53",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor ID 79?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with the highest course ID?",
    "SQL": "SELECT course_id, courseLevel FROM course ORDER BY course_id DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are currently being taught by person with ID 333?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 333",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 7?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 7",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many different students have been advised by each professor?",
    "SQL": "SELECT COUNT(DISTINCT p_id) AS num_students, p_id_dummy AS professor_id FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is teaching course ID 62?",
    "SQL": "SELECT T2.p_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 62",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor ID teaching the course with ID 68?",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 68",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program for more than a year?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND yearsInProgram = 'Year_2'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the professor of student p_id 22",
    "SQL": "SELECT professor FROM person WHERE p_id = 22",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor with ID 235?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in Level_500 courses?",
    "SQL": "SELECT COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are being advised by professor with ID 165?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(DISTINCT course_id) AS num_courses, p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is both a professor and a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advising person ID 375?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by person ID 124?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 124",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is a professor and is advising someone?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who is currently in Phase 2?",
    "SQL": "SELECT T2.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.inPhase = 'Phase_2'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 335?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by a specific person?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person IDs are taught by both professor and student types?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 INTERSECT SELECT p_id FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT p_id, COUNT(p_id_dummy) FROM advisedBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1) AND p_id_dummy IN (SELECT p_id FROM person WHERE student = 1) GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are being taught by professor 101?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average course level of courses taught by professor with ID 75?",
    "SQL": "SELECT AVG(T1.courseLevel) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 75",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 118?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 118",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are being advised by the person with ID 129?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id_dummy = 129",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT T2.p_id, COUNT(T1.course_id) as numCourses FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 278?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 278",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each person?",
    "SQL": "SELECT COUNT(p_id) AS numberOfStudents, p_id_dummy FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the number of courses taught by each professor",
    "SQL": "SELECT COUNT(course_id), p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor 319?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 319",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of students for each advisor?",
    "SQL": "SELECT CAST(COUNT(p_id) AS REAL) / COUNT(DISTINCT p_id_dummy) AS avgnum FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest level of course among the courses taught by person with p_id 213?",
    "SQL": "SELECT MAX(T2.courseLevel) FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with ID 351?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are currently being taught by professors?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 52?",
    "SQL": "SELECT T2.p_id AS studentID FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 52",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest level of course?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students have been advised by each advisor?",
    "SQL": "SELECT COUNT(p_id) AS count, p_id_dummy FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT p_id_dummy, COUNT(*) AS num_students FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 104?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor 211?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course IDs are taught by more than one professor?",
    "SQL": "SELECT course_id FROM taughtBy GROUP BY course_id HAVING COUNT(DISTINCT p_id) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(DISTINCT T1.course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 161?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 161",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in total?",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 213?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor ID 290?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 290",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each advisor?",
    "SQL": "SELECT COUNT(p_id), p_id_dummy FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(T1.course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who is currently in the program?",
    "SQL": "SELECT T2.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.inPhase = '1' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses offered by the professor who teaches course ID 138?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM taughtBy WHERE course_id = 138)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are being taught by professor with ID 234?",
    "SQL": "SELECT DISTINCT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 234",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have professors teaching them?",
    "SQL": "SELECT DISTINCT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professors?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at each level?",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with the position 'Faculty'?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = 'Faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 407?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which course is taught by person 141",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 141",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by each person?",
    "SQL": "SELECT COUNT(course_id), p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the program?",
    "SQL": "SELECT SUM(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id IN ( SELECT p_id FROM person WHERE professor = 1 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each person?",
    "SQL": "SELECT p_id, COUNT(course_id) AS num_courses FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 119?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 119",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs and course levels of all courses?",
    "SQL": "SELECT course_id, courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by the person with ID 394?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with ID 71?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 71",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 125?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 125",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professor 351?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 240?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses each person is teaching?",
    "SQL": "SELECT COUNT(*) AS number_of_courses FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students enrolled in each course?",
    "SQL": "SELECT T1.course_id, COUNT(T2.p_id) AS total_students FROM course AS T1 INNER JOIN advisedBy AS T2 ON T2.p_id = T2.p_id_dummy GROUP BY T1.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has been advised by at least 3 other persons?",
    "SQL": "SELECT p_id FROM advisedBy GROUP BY p_id HAVING COUNT(p_id_dummy) >= 3",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 77?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 77",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which person who teaches courses also has a faculty position?",
    "SQL": "SELECT T1.p_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 275?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 275",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are level 500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students who are advised by at least one professor?",
    "SQL": "SELECT COUNT(DISTINCT p_id) FROM advisedBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the student IDs of all the students who are advised by person ID 235?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses offered?",
    "SQL": "SELECT COUNT(course_id) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 114?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by professor with id 266?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id_dummy = 266",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course ID and course level for the course taught by professor 331?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the master/graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are Level 500 courses?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor ID 141?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 141",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are in each level?",
    "SQL": "SELECT COUNT(*) AS number_of_courses, courseLevel FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor ID for the person who is both a professor and a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are currently being taught by professors?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 29?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 29",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 52?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 52",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(course_id) AS numCourses FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at level 400?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person ID 180?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 180",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 235?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with p_id 22?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 22",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with ID 213?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 79?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average years in the program for students who are in the Pre_Quals phase?",
    "SQL": "SELECT AVG(yearsInProgram) FROM person WHERE student = 1 AND inPhase = 'Pre_Quals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 65?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 65",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person ID 231?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 231",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are being advised by person ID 101?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 2?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all the courses taught by professor ID 15?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 15",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level has the most number of courses?",
    "SQL": "SELECT courseLevel FROM course GROUP BY courseLevel ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT COUNT(p_id) AS studentCount, COUNT(DISTINCT p_id_dummy) AS professorCount FROM advisedBy WHERE p_id_dummy IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by whom?",
    "SQL": "SELECT T2.p_id, T1.p_id_dummy FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course ID for the course taught by person with ID 40?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 40",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor X?",
    "SQL": "SELECT COUNT(*) FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by Professor Smith?",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND p_id IN (SELECT p_id_dummy FROM advisedBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1))",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of people who are both professors and students?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level?",
    "SQL": "SELECT course_id FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in phase Post_Quals?",
    "SQL": "SELECT COUNT(*) FROM person WHERE inPhase = 'Post_Quals' AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 122?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 122",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 255?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 255",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there?",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course ID of the course taught by person ID 171?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 171",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students advised by each professor?",
    "SQL": "SELECT COUNT(p_id), p_id_dummy FROM advisedBy GROUP BY p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  }
]