[
  {
    "question": "Which student is advised by professor with ID 234?",
    "SQL": "SELECT T2.p_id, T2.yearsInProgram FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 234",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by more than one person?",
    "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 GROUP BY T2.p_id HAVING COUNT(*) > 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",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 240?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with ID 165?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 63?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 63",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is being advised by professor 213?",
    "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 = 213 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level does the person teaching course_id 161 belong to?",
    "SQL": "SELECT 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": "Which courses are taught by Professor X?",
    "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 T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "how many courses has the person with p_id 150 taught?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor 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 course does person with id 235 teach?",
    "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 = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are 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 INNER JOIN person AS T3 ON T1.p_id = T3.p_id WHERE T3.p_id = 351 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are being advised by Professors?",
    "SQL": "SELECT T1.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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the professor teaching the course with course_id 144?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.course_id = 144",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person 204?",
    "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 = 204",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with 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": "Which student is advised by professor?",
    "SQL": "SELECT T1.p_id, T1.yearsInProgram FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T1.professor = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course taught by person with p_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 course was taught by person with p_id 290?",
    "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 = 290",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches course 80?",
    "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 = 80",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching course ID 29?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 29",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course ID 52?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 52",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course that person 150 teaches?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which course level is associated with course id 110",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 110",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 27?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.course_id = 27",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course with course_id 114?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by a specific professor?",
    "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": "Which course has the highest level?",
    "SQL": "SELECT course_id FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with id 169?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 169",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the course with course_id '77'?",
    "SQL": "SELECT T1.professor FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.course_id = 77",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a professor position?",
    "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 AND T3.hasPosition = 'Faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 129?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 129",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by the person with p_id 234?",
    "SQL": "SELECT T2.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": "What courses is person with p_id 298 teaching?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by Professor Jane?",
    "SQL": "SELECT T2.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 professor's position in the program?",
    "SQL": "SELECT hasPosition FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course with course_id 51?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 51",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with ID 165?",
    "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.p_id = 165 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 331?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most courses?",
    "SQL": "SELECT T2.p_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id GROUP BY T2.p_id ORDER BY COUNT(T1.course_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor Smith?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE hasPosition = 'Professor')",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is teaching the course with course_id 66?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 66",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is course ID 151?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 151",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with id 331?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the courses taught by a professor who has been in the program for more than 5 years?",
    "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.student = 0 AND T3.yearsInProgram = 'Year_5'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the Post_Generals phase of the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'Post_Generals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with id 415?",
    "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 = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the year of the program of the student who is advised by the person with p_id 300?",
    "SQL": "SELECT T2.yearsInProgram FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 300",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with the course ID 44?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 44",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with id 342?",
    "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 = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with id 240?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor 82?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 82",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level does the person with ID 165 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 = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person 179?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 179",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a person with the p_id of 267?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 267",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with id 93?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 93",
    "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": "Which person is a student and has a position?",
    "SQL": "SELECT hasPosition FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course id 101?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the answer to life, the universe, and everything?",
    "SQL": "SELECT 42",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor with professor id 201?",
    "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 = 201 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by Professor John Doe?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1 AND T1.hasPosition = 'Faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching the course with course_id 147?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.course_id = 147",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with ID 201?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by the person with p_id 415?",
    "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 = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching a course at Level_500?",
    "SQL": "SELECT T2.hasPosition FROM course AS T1 INNER JOIN person AS T2 ON T1.course_id = T2.p_id WHERE T1.courseLevel = 'Level_500' AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with p_id 342?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by the person with p_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 taught by professors with a tenure position?",
    "SQL": "SELECT T1.course_id, T2.p_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 = 'Faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a course level of 'Level_500'?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "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": "What is the course level of the course with course_id 29?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 29",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor with the hasPosition 'Faculty'?",
    "SQL": "SELECT COUNT(*) 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": "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 the course with ID 97?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches the Level_500 course?",
    "SQL": "SELECT T2.p_id 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 professors with a position in the program?",
    "SQL": "SELECT T1.hasPosition, T1.yearsInProgram 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.professor = 1 AND T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID who teaches the course with course_id 9?",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 9",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are not currently advised by anyone?",
    "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 AND T2.p_id IS NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 93?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 93",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor 181?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 181",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by a professor?",
    "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": "Which courses are taught by professor?",
    "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, 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 professors are advised by students?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 0 AND T2.p_id_dummy IN ( SELECT p_id FROM person WHERE student = 1 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which professor is advising the most students?",
    "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 GROUP BY T1.p_id ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by Professor 181?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 181",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are taught by person p_id 278?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 278",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently advised by professor 185?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id_dummy = 185",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which student has been advised by person with p_id 5",
    "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 = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 46?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 46",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has a courseLevel of 'Level_500'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is 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": "Which person is currently advised by another person and also teaches a course?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor X?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 335?",
    "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 = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor 57?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 57",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 107?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 407?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 407",
    "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 students are advised by Professor X?",
    "SQL": "SELECT T2.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": "How many courses are Level_300?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_300'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 40?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 40",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 165?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 24?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 24",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is 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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Write an SQL query to find the professor who has advised a student in the program",
    "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 AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 72?",
    "SQL": "SELECT T1.courseLevel 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": "What is the course level for the course with ID 141?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 141",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the courseLevel of the course with course_id 4?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 4",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the program?",
    "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 T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor(s) is/are teaching the course with course_id 146?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.course_id = 146",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 370?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 370",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 41?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 41",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the level of the course which is taught by person with id 407?",
    "SQL": "SELECT T1.courseLevel 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": "Which courses are taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 34?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 34",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 375?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches the course with courseID 108?",
    "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 = 108",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level of difficulty?",
    "SQL": "SELECT course_id FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the professor with p_id 415?",
    "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 = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by which professor?",
    "SQL": "SELECT T1.p_id, T2.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 = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professors with positions in the program?",
    "SQL": "SELECT T3.p_id AS student_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.professor = 1 AND T3.yearsInProgram != 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with id 373?",
    "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 = 373",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 138?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 138",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors in the database?",
    "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": "Which course is taught by which professor?",
    "SQL": "SELECT T1.course_id, T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor John?",
    "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 courses are taught by professor 211?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with id 331?",
    "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 = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is a professor?",
    "SQL": "SELECT * FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor 407?",
    "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.p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 248?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 248",
    "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 that is taught by professor 324?",
    "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.p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in total?",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor John Doe?",
    "SQL": "SELECT COUNT(*) FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = 'Professor' AND person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course_id 165?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at Level_400?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor 331?",
    "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 = 331",
    "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 have been taught by Professor Smith?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a specific professor?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 40",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course with course_id 160?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 160",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is advising a student and is currently in phase 0?",
    "SQL": "SELECT T1.p_id, T1.hasPosition, T2.p_id_dummy FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T1.inPhase = 0 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 51?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 51",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by Professor Jane?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.professor = 1 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 189?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 189",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by the person with p_id 99?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 99",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) is/are taught by professor with id 107?",
    "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 = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have a position as 'Faculty'?",
    "SQL": "SELECT DISTINCT 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": "Which course level does the course with ID 104 have?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with id 331?",
    "SQL": "SELECT 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": "Which is the course level of the course with course id 30?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 30",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who is also a student?",
    "SQL": "SELECT T1.p_id FROM person AS T1 JOIN advisedBy 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 taught by professor with ID 240?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is advised by which student?",
    "SQL": "SELECT T1.p_id, T1.p_id_dummy, T2.professor FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest courseLevel?",
    "SQL": "SELECT course_id, courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the student in the program with more than 7 years of experience?",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND yearsInProgram = 'Year_7'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is teaching the course with course_id 147?",
    "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 = 147",
    "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": "Which course is taught by Professor A?",
    "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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with ID 297?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = (SELECT course_id FROM taughtBy WHERE p_id = 297)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level is the course with course_id 11?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 11",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is taught by person with p_id 52?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 52",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with ID 415?",
    "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 = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor with p_id 150?",
    "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.p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professor with p_id 240?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with the ID 98?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 98",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is currently in the program but has not published any papers? How many such professors are there?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND student = 0 AND hasPosition = 'Faculty_eme' AND p_id NOT IN ( SELECT p_id FROM advisedBy )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 79?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 79",
    "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.hasPosition = 'Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 18?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is advising whom in the database?",
    "SQL": "SELECT T2.p_id, T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by someone who is 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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who taught which course?",
    "SQL": "SELECT T2.p_id, T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course, taught by a student, is at Level_500?",
    "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.student = 1 AND T1.courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course levels are taught by professor 52?",
    "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 = 52",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with id 165?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the university?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 324?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 231?",
    "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 = 231",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student was advised by professor 407?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 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 course level does person with id 347 teach?",
    "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 = 347",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor 324?",
    "SQL": "SELECT T1.courseLevel 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 student has been advised by professor 335?",
    "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 = 335 AND T1.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": "What courses is a specific student enrolled in?",
    "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",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor 79?",
    "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.p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are Level_300?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_300'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which course has been taught by professor 351?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which SQL query will give the course level of the course taught by a specific professor?",
    "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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching the Level_500 course?",
    "SQL": "SELECT T2.hasPosition FROM course AS T1 INNER JOIN person AS T2 ON T1.course_id = T2.p_id WHERE T1.courseLevel = 'Level_500' AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has a professor assigned to teach it?",
    "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 taught by professor with p_id 235?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person was taught by in phase of the program?",
    "SQL": "SELECT T2.p_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.inPhase = '1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with id 324?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 331?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a specific professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 181",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by Professor X?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.professor = 1 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with p_id 99?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 99",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level course is professor 248 teaching?",
    "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 = 248",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 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": "Which course is taught by professor with id 326?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 326",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with id 46?",
    "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 = 46",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by person with id 292?",
    "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 = 292",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with 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": "What is the course level of the course with course id 52?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 52",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course 134?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 134",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with id 168?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 168",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who has both a professor and a student role in the database?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is associated with the course with the course ID 125?",
    "SQL": "SELECT T1.professor FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.course_id = 125",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a specific professor?",
    "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 = 40",
    "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 course level is associated with course_id 79?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "how many courses are taught by professor 171?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 171",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 165?",
    "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 = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the courseLevel of course with course_id 107?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by person with id 29?",
    "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 = 29",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that has been taught by person with p_id 248?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 248",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor X?",
    "SQL": "SELECT COUNT(*) 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": "Which course is taught by professor with ID 165?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor?",
    "SQL": "SELECT T2.professor FROM advisedBy AS T1 INNER JOIN person AS T2 ON T2.p_id = T1.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has been taught by person with id 107?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 107",
    "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": "Which course is taught by person with p_id 248?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 248",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by Professor X?",
    "SQL": "SELECT 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 T3.p_id = T2.p_id_dummy WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 235?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches the course Level_400?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor John Doe?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = (SELECT p_id FROM person WHERE professor = 1 AND yearsInProgram > 0)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level does the course with course ID 160 belong to?",
    "SQL": "SELECT 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 professors are there in the university",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor 5?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 5 AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 324?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with id 394?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with ID 240?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with positions in the program?",
    "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 AND T3.hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course, taught by person with ID 331, has a course level of Level_500?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 331 AND T1.courseLevel = 'Level_500'",
    "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 who? Provide a list of students and their advisors.",
    "SQL": "SELECT T1.p_id AS student, T2.p_id AS advisor FROM advisedBy AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with id 171?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 171",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with the p_id 211?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 211",
    "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": "How many courses are taught by person with ID 331?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor with p_id 342?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id INNER JOIN taughtBy AS T3 ON T1.p_id = T3.p_id WHERE T3.p_id = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with p_id 213?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by the person with p_id 351?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching a course at Level_500?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T3.courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 137?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 137",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor?",
    "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 of the course taught by person with p_id 342?",
    "SQL": "SELECT T1.courseLevel 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": "What level is the course with course_id 61?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 61",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 16?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 16",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course taught by Professor John?",
    "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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with p_id 375?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the courseLevel of the course taught by person 342?",
    "SQL": "SELECT T1.courseLevel 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": "Which course is taught by person with ID 201?",
    "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 = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are taught by professor p_id 364?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 364",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with id 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": "Who are the professors in the program?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level of course is taught by person with ID 107?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with p_id 324?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is advising person with ID 6?",
    "SQL": "SELECT T1.p_id_dummy FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 6",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 415?",
    "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 = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a student in the program for at least 2 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 T2.p_id = T3.p_id WHERE T3.student = 1 AND T3.yearsInProgram >= 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by the person with id 235?",
    "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 = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is being advised by professor 29?",
    "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 = 29",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by Professor John?",
    "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 course is professor with ID 259 teaching?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 259",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is a professor or a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 OR student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is being advised by professor 331?",
    "SQL": "SELECT T2.student 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 = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with p_id 292?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 292",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by Professor X?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.hasPosition = 'professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course does person 179 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 = 179",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person 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 course does person with id 212 teach?",
    "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 = 212",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by Prof. Smith?",
    "SQL": "SELECT T2.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.p_id = (SELECT p_id FROM person WHERE student = 1 LIMIT 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the course Level_500?",
    "SQL": "SELECT T2.hasPosition FROM course AS T1 INNER JOIN person AS T2 ON T1.course_id = T2.p_id WHERE T1.courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 46?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 46",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by the person with ID 104?",
    "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 = 104 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor John Doe?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor 213?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that is taught by person 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": "What is the level of the course taught by professor with id 298?",
    "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.p_id = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with specific positions?",
    "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 = 'Faculty_adj'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor 319?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 319 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's name who taught the Level_500 course?",
    "SQL": "SELECT T2.p_id 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": "Who is the professor in charge of teaching the course with course_id 147?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 147",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with id 52?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 52",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by Professor with id 171?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 171",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor John?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 201?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with a position 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.hasPosition = '1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person 98?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 98",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in Pre_Quals phase?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'Pre_Quals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with ID 164?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 164",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a level of 500?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID for the person who has a position and is in the phase?",
    "SQL": "SELECT p_id FROM person WHERE hasPosition = 1 AND inPhase = 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 professors are there in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position of 'Faculty'?",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course AS c JOIN taughtBy AS t ON c.course_id = t.course_id JOIN person AS p ON t.p_id = p.p_id WHERE p.hasPosition = 'Faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor with p_id 201?",
    "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.p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 235?",
    "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 = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 331?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 324?",
    "SQL": "SELECT T1.courseLevel 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": "What is the professor's id who teaches the course with id 51?",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_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": "Who is a professor in the program?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by Professor Smith?",
    "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 course is taught by professor 150?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is taught by which professor?",
    "SQL": "SELECT T1.p_id, T2.p_id, T1.professor, T1.student FROM person AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with id 168?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 168",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with ID 104?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor 52?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 52",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person 351?",
    "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 = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching course with course ID 104?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.course_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 5?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor 104?",
    "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.p_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course_id 129?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 129",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with p_id 279?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 279",
    "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": "Which course is taught by the person with p_id 407?",
    "SQL": "SELECT T1.courseLevel 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": "Which courses are 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": "Which student has been advised by more than one professor?",
    "SQL": "SELECT T2.p_id, T2.yearsInProgram FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1 GROUP BY T2.p_id HAVING COUNT(T1.p_id_dummy) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 101?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses does person p_id 40 teach?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 40",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level?",
    "SQL": "SELECT course_id, courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the professor teaching the course with courseID 89?",
    "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 = 89 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with id 240?",
    "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 = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is associated with course ID 5?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course, taught by Professor Smith, has the highest level?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id IN (SELECT p_id FROM person WHERE hasPosition = '1') ORDER BY T1.courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course_id 62?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 62",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course that Professor X is teaching?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id INNER JOIN taughtBy AS T3 ON T3.p_id = T1.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by whom?",
    "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",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor 394?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by which person?",
    "SQL": "SELECT T1.course_id, T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 370?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 370",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course taught by person with id 72?",
    "SQL": "SELECT T1.courseLevel 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": "What is the course level of the course with ID 120?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 120",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 234?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 234",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with id 415?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person was taught by professor with id 165?",
    "SQL": "SELECT T2.p_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": "Which person in the database is a student and has no position?",
    "SQL": "SELECT * FROM person WHERE student = 1 AND hasPosition = 0",
    "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 person in the database is a student and has a position?",
    "SQL": "SELECT hasPosition FROM person WHERE student = 1 AND hasPosition = '1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 351?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) are taught by professor with ID 394?",
    "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 = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching the highest level course?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T1.course_id = T3.course_id ORDER BY T3.courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level does the course with course_id 8 have?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 8",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 27?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 27",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 34?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 34",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor X?",
    "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 person with id 364?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 364",
    "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",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the courseLevel of course 77?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 77",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that professor 370 teaches?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 370",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses is person with p_id 319 teaching?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 319",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 331?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's student's year in the program?",
    "SQL": "SELECT T1.yearsInProgram 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 courses are taught by Professor 407?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 165?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 57?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 57",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with id 394?",
    "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 = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with ID 103?",
    "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 = 103",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest course level?",
    "SQL": "SELECT course_id, courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course with ID 84?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 84",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 319?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 319",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has Level_400?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with more than 4 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 T3.p_id = T2.p_id WHERE T3.yearsInProgram = 'Year_5'",
    "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 T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'Professor John'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most number of courses?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id GROUP BY T2.professor ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 24?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 24",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with id 211?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by Professor Y?",
    "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.professor = 1 AND T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by professor 331?",
    "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 = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by Professor Alice?",
    "SQL": "SELECT COUNT(*) FROM advisedBy JOIN person ON advisedBy.p_id = person.p_id WHERE person.hasPosition = 'Faculty_adj' AND advisedBy.p_id_dummy IN (SELECT p_id FROM person WHERE hasPosition = 'Student')",
    "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 of course with ID 110?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 110",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 331?",
    "SQL": "SELECT 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 taught by Professor X?",
    "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 course has the highest course 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 professor 407?",
    "SQL": "SELECT T1.courseLevel 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": "How many courses are taught by professor John?",
    "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 person is advised by person with p_id 342?",
    "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 = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 141?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 141 AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches course with ID 104?",
    "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 = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with ID 331?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with p_id 364?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 364",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 167?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 167",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course with id 7?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 7",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor 5?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 0 AND T1.p_id_dummy = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level of course is taught by person 324?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with id 165?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the professor teaching the course with course ID 11?",
    "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 = 11",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors have advised at least one student?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.student = 0",
    "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 courses are taught by person with p_id 297?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 297",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 335?",
    "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 = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each person?",
    "SQL": "SELECT T1.p_id, COUNT(T2.course_id) FROM person AS T1 INNER JOIN taughtBy 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 a professor with a position in the post-generals phase?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.hasPosition = '0' AND T2.inPhase = 'Post_Generals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with id 335?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with id 150?",
    "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 = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest course level?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = (SELECT MAX(courseLevel) FROM course)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the professor who teaches course with id 168?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.course_id = 168",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by a specific professor?",
    "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": "Which person is advised by another person?",
    "SQL": "SELECT T1.p_id, T1.p_id_dummy FROM advisedBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = '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 level of the course taught by professor 79?",
    "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.p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 211?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 211",
    "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": "Which courses are taught by person with id 319?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 319",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level and what is its course ID?",
    "SQL": "SELECT MAX(courseLevel), course_id FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 79?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor who has been in the program for more than 7 years?",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.student = 0 AND person.yearsInProgram = 'Year_7' AND person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are advising students?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "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": "What is the level of the course taught by person 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 course is 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 the person with p_id 5?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that is taught by professor with ID 150?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T1.p_id = T3.p_id WHERE T3.p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with id 335?",
    "SQL": "SELECT T2.student FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T1.p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 342?",
    "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 = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course does Professor John teach?",
    "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 professor has advised the student with p_id 342?",
    "SQL": "SELECT T2.professor FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 342 AND T2.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": "Which students are advised by professors?",
    "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 course has a course level of Level_500?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course id 115?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 115",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professor with p_id 189?",
    "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 = 189",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by more than one professor?",
    "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 GROUP BY T2.p_id HAVING COUNT(DISTINCT T1.p_id_dummy) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level is associated with course 161?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 161",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 44?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 44",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by Professor X?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id IN ( SELECT p_id FROM person WHERE professor = 1 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course is being taught by person with p_id 213?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching which course?",
    "SQL": "SELECT T2.p_id, T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 370",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor 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",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the professor in charge of course with courseLevel of 'Level_400'?",
    "SQL": "SELECT T2.hasPosition FROM course AS T1 INNER JOIN person AS T2 ON T1.course_id = T2.p_id WHERE T1.courseLevel = 'Level_400' AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course_id 139?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 139",
    "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": "How many students are currently in Phase 2 of the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'Phase_2'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor 213?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is taught by the person with ID 331?",
    "SQL": "SELECT 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": "Which course is taught by person with ID 22?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 22",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with ID 211?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level is course_id 53?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 53",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the Level_400 course level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with course_id 85?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 85",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor p_id 234?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 234",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course taught by professor 394?",
    "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.p_id = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what courses are taught by professor 278?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 278",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the student in the third year of the program?",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND yearsInProgram = 'Year_3'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with p_id 342?",
    "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 = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person teaches the course with course ID 77?",
    "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 = 77",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course with id 48?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 48",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by a professor?",
    "SQL": "SELECT DISTINCT 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": "What is the course level of the course taught by person with p_id 248?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 248",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who taught the most students?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1 GROUP BY T2.professor ORDER BY COUNT(T1.p_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor 165?",
    "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 = 165 AND T2.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": "How many courses are taught by professors?",
    "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": "Which professors are currently teaching Level_500 courses?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T3.courseLevel = 'Level_500' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with ID 297?",
    "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 = 297",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor p_id 171?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 171",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 394?",
    "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 = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "who are the students supervised by professor in department of computer science",
    "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 = 1",
    "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 course level of the course with course ID 80?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 80",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the university?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor 393?",
    "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 = 393 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor 351?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course id 151?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 151",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 407?",
    "SQL": "SELECT T1.courseLevel 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": "How many courses are taught by each professor?",
    "SQL": "SELECT T1.p_id, COUNT(T2.course_id) FROM person AS T1 INNER JOIN taughtBy 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 the person with id 248?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 248",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course does professor 181 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 = 181",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor X?",
    "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 student is currently in the Pre_Quals phase and has been in the program for more than one year?",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND inPhase = 'Pre_Quals' AND yearsInProgram = 'Year_2'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course levels are present in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 394?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching the course with course_id 88?",
    "SQL": "SELECT T2.hasPosition FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 88",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by Professor X?",
    "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 IN ( SELECT p_id FROM person WHERE professor = 1 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course taught by person 72?",
    "SQL": "SELECT T1.courseLevel 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 a specific professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with ID 104?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "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": "Which course is taught by professor 150?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with ID 5?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are there in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor with p_id 154?",
    "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 = 154",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor John?",
    "SQL": "SELECT COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T2.p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course that is taught by person with ID 46?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 46",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 169?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 169",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who teaches the course at Level_400?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel = 'Level_400' AND T2.p_id IN (SELECT p_id FROM person WHERE professor = 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, 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 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with p_id 292?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 292",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 158?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 158",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 98?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 98",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course_id 63?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 63",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with id 375?",
    "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 = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is a student?",
    "SQL": "SELECT p_id FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course taught by professor 201?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the professor advising the student with p_id 150?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id_dummy = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with ID 378?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 378",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the course level for course id 2?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 201?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor 235?",
    "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.p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 335?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course 117?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 117",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with p_id 235?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by person 211?",
    "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 = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the student in phase 'Post_Quals'?",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND inPhase = 'Post_Quals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor 201?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T1.p_id = T3.p_id WHERE T3.p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor 201?",
    "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 T3.p_id = T2.p_id WHERE T3.p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has been advised by person with p_id 384?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 384",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor 165?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor 165?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 88?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 88",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course ID 51?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 51",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is a professor and has been in the program for more than 5 years?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has more than one professor teaching it?",
    "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 HAVING COUNT(T2.p_id) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 201?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 103?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 103",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the student who is advised by person with id 342?",
    "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 = 342 AND T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course_id 115?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 115",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor 324?",
    "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 = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with id 141?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 141",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the Level_500 level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "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": "Which courses are taught by professor 213?",
    "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.p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course that has a course level of 'Level_300'?",
    "SQL": "SELECT courseLevel FROM course WHERE courseLevel = 'Level_300'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with ID 335?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 335",
    "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": "Which professor has advised more students?",
    "SQL": "SELECT T1.p_id, COUNT(T2.p_id_dummy) AS student_count FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 GROUP BY T1.p_id ORDER BY student_count DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with id 394?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by a professor?",
    "SQL": "SELECT T1.student FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id_dummy WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level does course 97 belong to?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with p_id 5?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with id 48?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 48",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID who is also a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course does the person with ID 394 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 = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 144?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 144",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is being 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 WHERE T1.p_id_dummy IN ( SELECT p_id FROM person WHERE student = 1 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor X?",
    "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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the database?",
    "SQL": "SELECT COUNT(course_id) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course that has the ID 50?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 50",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by someone who taught the course 'Level_400'?",
    "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 IN (SELECT T2.p_id FROM taughtBy AS T2 INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.courseLevel = 'Level_400')",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course ID 160?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 160",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 131?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 131",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by Professor John Doe?",
    "SQL": "SELECT T2.p_id, T2.p_id_dummy FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = 'Professor' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the student count in the person table?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by p_id 319?",
    "SQL": "SELECT T2.p_id_dummy FROM advisedBy AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id AND T1.p_id_dummy = T2.p_id_dummy WHERE T2.p_id = 319",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 298?",
    "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 = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the professor teaching course with id 165?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor X?",
    "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 a professor 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 AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 22?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 22",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the Level_500 course level?",
    "SQL": "SELECT T1.course_id, T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T1.p_id WHERE T3.professor = 1 AND T2.courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by which professors?",
    "SQL": "SELECT T1.course_id, T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level does the person with the ID 207 teach in?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 207",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course with course_id 154?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 154",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 150?",
    "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 = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with id 118?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 118",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person 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": "Which course is taught by person with id 150?",
    "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 = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has a courseLevel of 'Level_400'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has a course level of Level_400?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is teaching which course?",
    "SQL": "SELECT T2.p_id, T1.course_id 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 course level of the course with course id 48?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 48",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with ID 82?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 82",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the course with ID 120?",
    "SQL": "SELECT T1.professor FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.course_id = 120",
    "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 professor ID of the student with ID 154?",
    "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 = 154",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 46?",
    "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 = 46",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course does Professor John teach?",
    "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.student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is the course with id 103?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 103",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 231?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 231",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with id 335?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor X?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = (SELECT p_id FROM person WHERE hasPosition = 'Professor')",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with p_id 64?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 64",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 179?",
    "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 = 179 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 80?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 80",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest level of course offered in the database?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course does the person with p_id 22 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 = 22",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by person with p_id 101?",
    "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 = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the university?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with id 351?",
    "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 = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 35?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 35",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor with ID 104?",
    "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 = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with ID 394?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is being advised by Professor John?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = '1' AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor with p_id 234?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T2.p_id_dummy = 234",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's position in the program?",
    "SQL": "SELECT hasPosition FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are 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": "How many students are currently in the post-qualifications phase of the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE inPhase = 'Post_Quals' AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with ID 213?",
    "SQL": "SELECT T1.courseLevel 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": "Which students are advised by whom?",
    "SQL": "SELECT T1.p_id, T1.p_id_dummy 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": "How many courses are taught by professor 319?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 319",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 101?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level is the course taught by person with p_id 240?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is teaching which course?",
    "SQL": "SELECT T2.p_id, T1.course_id 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 level of the course taught by professor with ID 104?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 18?",
    "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 = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is associated with course ID 51?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 51",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with id 351?",
    "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 = 351",
    "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_dummy = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 248?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 248",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with id 179?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 179",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses does person with p_id 335 teach?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 107?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 21?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 21",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 335?",
    "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 = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by person 407?",
    "SQL": "SELECT T2.student FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the course level of the course with course_id 41?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 41",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is Level_400?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 331?",
    "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 = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor X?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.student = 0",
    "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 level of the course taught by person with ID 165?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a specific person?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with ID 351?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor X?",
    "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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person teaches the course with course_id 162?",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 162",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by which professors?",
    "SQL": "SELECT T1.p_id, T1.p_id_dummy, T2.professor FROM advisedBy AS T1 INNER JOIN person AS T2 ON T2.p_id = T1.p_id_dummy WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses does Professor X teach?",
    "SQL": "SELECT COUNT(*) FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1 AND person.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 courseLevel of the course with course_id 162?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 162",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course, Level_500, does Professor Jane teach?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = ( SELECT p_id FROM person WHERE professor = 1 ) AND T2.courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 75?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 75",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with ID 324?",
    "SQL": "SELECT T1.courseLevel 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 course is taught by professor with id 75?",
    "SQL": "SELECT 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": "Which courses are taught by a professor 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 T3.p_id = T2.p_id WHERE T3.yearsInProgram = 'Year_5'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that is taught by person with id 240?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course id 138?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 138",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who is also 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 = 1 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 415?",
    "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 = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 331?",
    "SQL": "SELECT 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": "Which courses are taught by professor with p_id 72?",
    "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.p_id = 72 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 235?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course that is taught by person with id 101?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches a Level_400 course?",
    "SQL": "SELECT T1.professor FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.courseLevel = 'Level_400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by professor with ID 375?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T2.p_id_dummy = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy",
    "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": "What is the name of the professor who is advising a student?",
    "SQL": "SELECT T1.p_id, T1.hasPosition FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that is taught by professor 415?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T1.p_id WHERE T3.p_id = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with the highest course level?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is teaching course with course_id 75?",
    "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 = 75",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with p_id 351?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course ID 157?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 157",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 351?",
    "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 = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level is associated with the course that has been taught by professor 351?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with id 298?",
    "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 = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor has advised more than one student?",
    "SQL": "SELECT T1.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.professor = 1 AND T3.student = 1 GROUP BY T1.p_id HAVING COUNT(T1.p_id_dummy) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has been advised by which person?",
    "SQL": "SELECT T1.p_id, T2.p_id_dummy FROM advisedBy AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor 1?",
    "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.p_id = 115 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_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 course has a course level of Level_500?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by Professor X?",
    "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 level of the course that is taught by person with p_id 335?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with id 18?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 324?",
    "SQL": "SELECT T1.courseLevel 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 person(s) is/are advised by person with id 5?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 44?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 44",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a specific professor?",
    "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 = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 248?",
    "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 = 248",
    "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 person is advised by someone with a position as 'Faculty'?",
    "SQL": "SELECT T1.p_id FROM advisedBy 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 with p_id 240?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by Professor John?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = 'Professor' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which student is a professor?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor with ID 18?",
    "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.p_id = 18 AND T3.professor = 1",
    "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": "How many courses are taught by the person with p_id 179?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 179",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor?",
    "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 324?",
    "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 = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor with a position in the program?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 331?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with the highest course_id?",
    "SQL": "SELECT courseLevel FROM course ORDER BY course_id DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 407?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course that person 211 teaches?",
    "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 = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with id 319?",
    "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 = 319",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are there in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person, who is a student, has a position assigned?",
    "SQL": "SELECT * FROM person WHERE student = 1 AND hasPosition = '1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 394?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 394",
    "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 students are there in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses have been taught by person with ID 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 course is taught by person with ID 407?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 32?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 32",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is assigned to teach course with course id 104?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by the person with p_id 267?",
    "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 = 267",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the post-generals phase of the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE inPhase = 'Post_Generals' AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course id 67?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 67",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person 211?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 211",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "how many courses are there in each level?",
    "SQL": "SELECT COUNT(*) , courseLevel FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 150?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 150",
    "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": "What is the level of the course that person 331 teaches?",
    "SQL": "SELECT 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": "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 courses are taught by Professor X?",
    "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": "What is the level of the course with course_id 158?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 158",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the professor's ID that teaches the course level 500 ?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel = 'Level_500' AND T2.p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is course 150?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 150",
    "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 of the course with course_id 61?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 61",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is currently in the Pre_Quals phase and has been in the program for Year_1?",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND hasPosition = '0' AND inPhase = 'Pre_Quals' AND yearsInProgram = 'Year_1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is assigned to teach which course?",
    "SQL": "SELECT T1.p_id, T1.course_id FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level does course with id 147 have?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 147",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the student's current phase in the program?",
    "SQL": "SELECT inPhase FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 415?",
    "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 = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is a student?",
    "SQL": "SELECT p_id FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course ID 49?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 49",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 12?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 12",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level is 'course_id' 129?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 129",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by someone else in the program?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T1.hasPosition = 0",
    "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": "How many courses are taught by person with id 342?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with id 147?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 147",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by a professor with more than 5 years in the program?",
    "SQL": "SELECT T1.p_id FROM advisedBy 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": "How many courses are taught by professor with ID 298?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses does a particular student teach?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id IN ( SELECT p_id FROM person WHERE student = 1 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 64?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 64",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with id 378?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 378",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "how many people are students ?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor has advised a student?",
    "SQL": "SELECT DISTINCT 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": "What is the course level of the course taught by professor 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": "Who is advising person with ID 239?",
    "SQL": "SELECT T2.hasPosition FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T1.p_id = 239",
    "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 professors are there in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching the course with 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 394?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by the professor with ID 407?",
    "SQL": "SELECT T1.courseLevel 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": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advising student 217?",
    "SQL": "SELECT T1.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.p_id = 217",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course did Professor X teach?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by another person in the system?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with p_id 248?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 248",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students have completed their program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by person with p_id 342?",
    "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 = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) is/are taught by professor with ID 213?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by person with p_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",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course_id 167?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 167",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with a position 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.hasPosition = '1' AND T1.professor = '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 of the course with id 75?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 75",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 263?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 263",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has Professor 180 taught?",
    "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": "Who is teaching the Level_500 course?",
    "SQL": "SELECT T2.hasPosition FROM course AS T1 INNER JOIN person AS T2 ON T1.course_id = T2.p_id WHERE T1.courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level 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 INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor X?",
    "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 T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course, Level_500, is taught by Professor Alice?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T1.course_id = T3.course_id WHERE T2.hasPosition = 'Professor' AND T3.courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is teaching which course?",
    "SQL": "SELECT T2.p_id, T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) is/are taught by Professor John?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by a professor?",
    "SQL": "SELECT COUNT(*) FROM advisedBy AS T1 INNER 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": "What is the course level of the course taught by person with p_id 248?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 248",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a specific professor ?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 103",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 66?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 66",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with id 44?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 44",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the database?",
    "SQL": "SELECT COUNT(course_id) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID of the person who is advised by 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",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with the course_id 157?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 157",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with ID 104?",
    "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 = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with id 72?",
    "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 = 72",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor has taught in which course?",
    "SQL": "SELECT T1.p_id, T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "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": "Which students are advised by the professor with p_id 154?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 154",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the professor advised by and what courses they teach?",
    "SQL": "SELECT T2.p_id, T2.hasPosition, T3.courseLevel FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T1.p_id_dummy = T3.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 298?",
    "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 = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course that person 18 is studying?",
    "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.p_id = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the student in the program and what is their position?",
    "SQL": "SELECT hasPosition FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for a course taught by person with ID 103?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 103",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by person 335?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person 213?",
    "SQL": "SELECT T1.courseLevel 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 professor with p_id 278?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 278",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor A?",
    "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 students are advised by person with 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": "How many students are there in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 319?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 319",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor X?",
    "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 professor p_id 335?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with id 54?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 54",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professor 101?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 11?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 11",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with p_id 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": "Which professor is advising the student with ID 292?",
    "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 = 292 AND T2.student = 1 AND T2.professor = 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": "Which students are advised by a professor?",
    "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 AND T1.professor = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with id 394?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 394",
    "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": "How many courses are taught by professor 213?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 351?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course (courseLevel) is taught by professor (p_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 course level has the highest number of courses?",
    "SQL": "SELECT courseLevel FROM course GROUP BY courseLevel ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by Professor with p_id 298?",
    "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.p_id = 298 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT T2.professor, COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 GROUP BY T2.professor",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is a professor and has a position in the program?",
    "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 AND T1.hasPosition = 'Faculty' AND T1.yearsInProgram > 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 44?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 44",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is currently advised by another student?",
    "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",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have Level_500 as their course level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches a course at Level_500?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.courseLevel = 'Level_500' AND 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 students are advised by Professor John?",
    "SQL": "SELECT T1.student FROM person AS T1 JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 375?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 375",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor 290?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id = 290)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the student status of the person with p_id 163?",
    "SQL": "SELECT student FROM person WHERE p_id = 163",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 324?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is a student in the pre-qualification phase of the program?",
    "SQL": "SELECT * FROM person WHERE student = 1 AND inPhase = 'Pre_Quals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by p_id 212?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id_dummy = 212",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 351?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id INNER JOIN taughtBy AS T3 ON T2.course_id = T3.course_id WHERE T1.p_id = 351",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with ID 141?",
    "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 = 141",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 18?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a specific professor?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 231",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of course 152?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 152",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has a year of program that is Year_1 and is advised by a professor?",
    "SQL": "SELECT 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.professor = 1 AND T1.student = 1 AND T1.yearsInProgram = 'Year_1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professors?",
    "SQL": "SELECT T1.p_id, T1.yearsInProgram 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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 415?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 415",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by Professor 331?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with id 298?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses does person 234 teach?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 234",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) is taught by person with p_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 courses are taught by person with ID 165?",
    "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 = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses is person with p_id 18 teaching?",
    "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 = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with course_id '103'?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 103",
    "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 student = 1 AND inPhase = 'Pre_Quals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by the person with ID 104?",
    "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 = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors in the database?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 75?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 75",
    "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": "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": "How many students are there in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 378?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 378",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has professor 165 teaching?",
    "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 = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches which course?",
    "SQL": "SELECT T1.p_id, T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) is/are taught by Professor X?",
    "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 courses are taught by a specific person?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with ID 324?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 324",
    "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": "Which course was taught by person with p_id 407?",
    "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 = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor taught which course?",
    "SQL": "SELECT T1.professor, T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's position in the program?",
    "SQL": "SELECT hasPosition FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 172?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 172",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "who teaches the most level 500 courses?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.courseLevel = 'Level_500' GROUP BY T1.p_id ORDER BY COUNT(T2.p_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has been advised by another person in the program?",
    "SQL": "SELECT T1.p_id, T1.p_id_dummy 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": "Which students are advised by which professors?",
    "SQL": "SELECT T1.student, T1.professor FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by Professor X?",
    "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": "Who is the professor assigned to teach the course with course_id 16?",
    "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 = 16",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by Professor Smith?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = '1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor 342 and which course does he teach?",
    "SQL": "SELECT T1.p_id, T3.course_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN taughtBy AS T3 ON T2.p_id = T3.p_id WHERE T1.p_id_dummy = 342 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 351?",
    "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.p_id = 351",
    "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 student = 1 AND inPhase = 'Post_Generals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by the person with id 107?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by whom?",
    "SQL": "SELECT T1.p_id, T2.p_id FROM advisedBy AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course is taught by person 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": "What course is taught by person with p_id 407?",
    "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 = 407",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor with p_id 180?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T2.p_id_dummy = 180",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 27?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 27",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by the person with p_id 331?",
    "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 = 331",
    "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 level of the course with ID 146?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 146",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course ID 19?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 19",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with id 394?",
    "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 = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with 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": "What is the highest level course that is being taught by a professor?",
    "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.professor = 1 ORDER BY T1.courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest course level?",
    "SQL": "SELECT course_id, courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 267?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 267",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 378?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 378",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course does the professor with professor_id 324 teach?",
    "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 = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by which professor?",
    "SQL": "SELECT T1.course_id, T2.p_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the course with course_id 123?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course, if any, is taught by a professor who has been in the program for more than a year?",
    "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 = 'Year_1' AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with id 165?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with p_id 189?",
    "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 = 189",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with p_id 52?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 52",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with ID 165?",
    "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 = 165",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are taught by professor with ID 72?",
    "SQL": "SELECT T1.courseLevel 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": "Which course is taught by Professor X?",
    "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 courses are taught by professor with p_id 378?",
    "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 = 378",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches which course?",
    "SQL": "SELECT T2.p_id, T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 335?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor John?",
    "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 AND T3.student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor 57?",
    "SQL": "SELECT 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": "What is the course level of the course with course_id 122?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 122",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is a student and has a position in the program?",
    "SQL": "SELECT * FROM person WHERE student = 1 AND hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 324?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor 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": "Which course is taught by person with ID 394?",
    "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 = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who teaches the course with course_id 19?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 19",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor?",
    "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 professor is advising student 314?",
    "SQL": "SELECT T2.professor FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 314 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with p_id 141?",
    "SQL": "SELECT T1.courseLevel 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": "How many courses are taught by professor 79?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 79",
    "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 courses are taught by the person with professor ID 46?",
    "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 = 46",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 181?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 181",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by which professor?",
    "SQL": "SELECT T1.p_id, T1.p_id_dummy, T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id AND T1.p_id_dummy = T2.p_id WHERE T2.student = 1 AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with id 324?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T1.p_id = T3.p_id WHERE T3.p_id = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course was taught by person with 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": "How many courses are taught by professor 40?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 40",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is currently advised by professor 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",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 351?",
    "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 = 351",
    "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 level of the course taught by person with id 201?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor ID of the person who has been advised by someone?",
    "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 students are advised by which professors?",
    "SQL": "SELECT T2.p_id, T3.p_id_dummy FROM person AS T2 INNER JOIN advisedBy AS T3 ON T2.p_id = T3.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 324?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 324",
    "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 T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT T2.p_id, COUNT(*) 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 courseLevel of the course with course_id 104 ?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 104",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by another person?",
    "SQL": "SELECT T1.p_id, T1.p_id_dummy 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",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 171?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 171",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is not advised by anyone?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 RIGHT JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id IS NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person 324?",
    "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 = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with id 51?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 51",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that is taught by professor 240?",
    "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.p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course is taught by person with id 364?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 364",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is a student and has no position?",
    "SQL": "SELECT hasPosition, student FROM person WHERE student = 1 AND hasPosition = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's course level?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course is taught by person p_id 278?",
    "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 = 278",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by a particular professor?",
    "SQL": "SELECT T2.p_id_dummy 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 course is taught by person with ID 335?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by a person with a specific position?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = '1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person 150?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 150",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with p_id 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": "What is the course level for the course with id 41?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 41",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor 107?",
    "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 = 107",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 231?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 231",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with ID 342?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor with id 101?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 101 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are enrolled in the Level_500 course?",
    "SQL": "SELECT COUNT(T1.p_id) FROM advisedBy AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T3.courseLevel = 'Level_500'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students have been advised by professors in the program?",
    "SQL": "SELECT T2.student FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy IN ( SELECT p_id FROM person WHERE professor = 1 )",
    "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 level of the course with course_id 18?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.course_id = 18",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching a course Level_500?",
    "SQL": "SELECT T2.p_id 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 course has the highest level?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student was advised by Professor X?",
    "SQL": "SELECT T2.p_id AS StudentID 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 level of the course taught by professor with p_id 79?",
    "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.p_id = 79",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is associated with the course having course_id as 146?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 146",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a specific professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 248",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level of difficulty?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student has been advised by at least one 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",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor with ID 240?",
    "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 = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level has the most courses?",
    "SQL": "SELECT courseLevel FROM course GROUP BY courseLevel ORDER BY COUNT(*) DESC LIMIT 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": "Which course(s) does professor 324 teach?",
    "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 = 324",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 101?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 101",
    "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 student is advised by Professor 'John Doe'?",
    "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 = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with id 331?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 103?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 103",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with ID 201?",
    "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 = 201",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with id 394?",
    "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 = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is 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 T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'Faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a specific professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 364",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the professor with id 331?",
    "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 = 331",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professors in the program?",
    "SQL": "SELECT T2.p_id, T2.yearsInProgram FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id AND T1.p_id_dummy = T2.p_id WHERE T2.hasPosition = 0 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses is person with p_id 240 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 = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 394?",
    "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 = 394",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position as 'Faculty'?",
    "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 AND T3.hasPosition = 'Faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 342?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 342",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person 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": "Which course was taught by person with ID 298?",
    "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 = 298",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching which course?",
    "SQL": "SELECT T1.professor, T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course taught by Professor X?",
    "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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by person 432?",
    "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 = 432",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level is associated with course_id 56?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 56",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by the person with p_id 319?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 319",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by professor inPhase 'Post_Generals'?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = '1' AND T2.inPhase = 'Post_Generals'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors with more than 3 years of experience in the program?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.yearsInProgram = 'Year_3'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a specific person?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 189",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are being advised by professor with p_id 378?",
    "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 = 378 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by someone with a position in the program?",
    "SQL": "SELECT T2.p_id, T2.p_id_dummy FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is advising person with id 96?",
    "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 = 96",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which student is advised by which professor?",
    "SQL": "SELECT T1.p_id, T1.p_id_dummy FROM advisedBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_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": "Which professor teaches the course with courseID 12?",
    "SQL": "SELECT T2.professor FROM course AS T1 INNER JOIN person AS T2 ON T1.course_id = T2.p_id WHERE T1.course_id = 12",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor X?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 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 course_id 21?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 21",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What course level is the course taught by person with id 240?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches which course?",
    "SQL": "SELECT T1.course_id, T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor 240?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 240",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that professor 335 teaches?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 335",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 57?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 57",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with ID 5?",
    "SQL": "SELECT T1.course_id, T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who teaches the course with course_id 157?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 157",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students have been advised by professor?",
    "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 IN ( SELECT p_id FROM person WHERE professor = 1 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What level is the course with ID 148?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 148",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor XYZ?",
    "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 = 213",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course with course_id 46?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 46",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(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 is teaching a course that is at a higher level than Level_300?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel > 'Level_300'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_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": "Which course is taught by person with id 235?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 235",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professor whose ID is 179?",
    "SQL": "SELECT T3.p_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN advisedBy AS T3 ON T2.p_id = T3.p_id WHERE T1.p_id = 179",
    "db_id": "computer_student",
    "evidence": ""
  }
]