[
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with ID 180?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 180"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with a certain level of experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel, t.course_id, p.hasPosition, p.inPhase, p.yearsInProgram FROM course c, taughtBy t, person p WHERE c.course_id = t.course_id AND t.p_id = p.p_id AND p.hasPosition = '1' AND p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by a faculty with more than 0 years in the program?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND person.yearsInProgram > 0 AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with the ID 9?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 9"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor with a course level 'Level_400'?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 0 AND c.courseLevel = 'Level_400' GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by the professor with id 331?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id = (SELECT p_id FROM person WHERE professor = 1))"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course with course id 97?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have not held any positions?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = '0'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has a student with a course level of Level_500?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM taughtBy, course WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id IN (SELECT p_id FROM person WHERE student = 1 AND hasPosition = 0 AND inPhase = 0 AND yearsInProgram = 0) AND course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors have taught courses at the Level_400 level?",
    "evidence": "",
    "SQL": "SELECT DISTINCT p_id FROM person WHERE professor = 1 AND EXISTS (SELECT * FROM taughtBy WHERE taughtBy.p_id = person.p_id AND taughtBy.course_id IN (SELECT course_id FROM course WHERE courseLevel = 'Level_400'))"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with ID 52?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy, course WHERE taughtBy.p_id = 52 AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 107?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 107"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with p_id 279?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 279"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with the course_id 23?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 23"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has a level of Level_500?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel='Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with id 23?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 23"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a person with a position of Faculty?",
    "evidence": "",
    "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.hasPosition = 'Faculty'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a person who has been in the program for 9 years?",
    "evidence": "",
    "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.yearsInProgram = 'Year_9'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 124?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 124"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors with more than 3 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = 'Year_4' AND p.student = 0 GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the course with ID 97?",
    "evidence": "",
    "SQL": "SELECT p.student FROM person p JOIN taughtBy t ON p.p_id = t.p_id WHERE t.course_id = 97 AND p.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 150?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 150"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a student who is in phase 0?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.inPhase = '0' AND p.student = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been in the program for 2 years or more?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram >= 2"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 0 AND p.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What level of course is taught by professor 189?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 189"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has a professor who has taught a course at Level_400?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.professor = 1 AND c.courseLevel = 'Level_400' GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a professor in Year 2?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = 'Year_2' AND p.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor with more than one year of experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 108?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 108"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors in the Level_500?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = '1' AND c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 101?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 101"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors in Level_500?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel, t.p_id FROM taughtBy t JOIN course c ON t.course_id = c.course_id WHERE c.courseLevel = 'Level_500' AND t.p_id IN (SELECT p_id FROM person WHERE hasPosition='1') "
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by Professor 324?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 324"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have more than 3 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND person.yearsInProgram > 'Year_3' GROUP BY course.course_id, course.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by Faculty Adjunct professors?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = 'Faculty Adjunct' AND person.student = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with id 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors who have more than 5 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram >= 'Year_5' GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the course with course ID 121?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM taughtBy AS t JOIN course AS c ON t.course_id = c.course_id JOIN person AS p ON t.p_id = p.p_id WHERE c.course_id = 121"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with 'Level_400' course level?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND course.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course ID 138?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 138"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with ID 83?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 83"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has the highest level?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = (SELECT course_id FROM course ORDER BY courseLevel DESC LIMIT 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with at least 8 years in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t, person p WHERE c.course_id = t.course_id AND t.p_id = p.p_id AND p.yearsInProgram = 'Year_8'"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors have taught a course of Level_500?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND p_id IN (SELECT p_id FROM taughtBy WHERE course_id IN (SELECT course_id FROM course WHERE courseLevel = 'Level_500'))"
  },
  {
    "db_id": "computer_student",
    "question": "What course does the person with ID 131 teach?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE p_id = 131)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course ID 4?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 4"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches the course with ID 149?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 149"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest level of course taught by the professor with ID 40?",
    "evidence": "",
    "SQL": "SELECT MAX(courseLevel) FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 40"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor with id 1 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1) AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the professor with id 240?",
    "evidence": "",
    "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.p_id = 240"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses have been taught by professors who have also advised students?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.professor = 1 AND EXISTS (SELECT * FROM advisedBy ab WHERE ab.p_id = p.p_id)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses have been taught by the professor with the highest number of students?",
    "evidence": "",
    "SQL": "SELECT * FROM taughtBy JOIN person ON taughtBy.p_id = person.p_id JOIN course ON taughtBy.course_id = course.course_id WHERE person.student = (SELECT MAX(student) FROM person) GROUP BY taughtBy.course_id, course.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the course with ID 15?",
    "evidence": "",
    "SQL": "SELECT person.professor AS professor FROM person INNER JOIN taughtBy ON person.p_id = taughtBy.p_id WHERE taughtBy.course_id = 15"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has person 407 taught?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 407"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does professor 82 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 82"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 35?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 35"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor 204?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 204"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor who has been in the program for at least 2 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 0 AND p.yearsInProgram >= 2"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with course ID 146?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 146"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the course with ID 115?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM person p JOIN taughtBy tb ON p.p_id = tb.p_id WHERE tb.course_id = 115"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 129?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 129"
  },
  {
    "db_id": "computer_student",
    "question": "What level is the course with course_id 85?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 85"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is a professor teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Who is the professor that has taught a course in Level_500?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM person p JOIN taughtBy t ON p.p_id = t.p_id JOIN course c ON t.course_id = c.course_id WHERE c.courseLevel='Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors with less than 5 years in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram < 'Year_5'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by the professor who has a position?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE person.p_id = taughtBy.p_id AND person.hasPosition = '1' AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of a course taught by the professor who has been teaching for the most years?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel FROM course c INNER JOIN taughtBy t ON c.course_id = t.course_id INNER JOIN person p ON t.p_id = p.p_id WHERE p.professor = 1 ORDER BY p.yearsInProgram DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has a person with ID 415 taught?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, course.course_id FROM course, taughtBy WHERE taughtBy.p_id = 415 GROUP BY course.course_id, course.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has a student in 'Year_2' phase?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.inPhase = 'Year_2' AND p.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with more than 0 years of experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor with ID 326 teaching?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 326"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has a level of 'Level_500'?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 170?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 170"
  },
  {
    "db_id": "computer_student",
    "question": "Which level courses are offered by professors who have been in the program for more than 6 years?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel FROM course c, taughtBy t, person p WHERE p.yearsInProgram = 'Year_6' AND c.course_id = t.course_id AND p.p_id = t.p_id AND p.hasPosition = '1' GROUP BY c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 30?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 30"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with ID 213?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 213"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by professor 240?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id = 240)"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses has Professor X taught?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest course level taught by a professor?",
    "evidence": "",
    "SQL": "SELECT MAX(courseLevel) AS highest_level FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by the professors who have been in the program for more than 2 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t, person p WHERE p.p_id = t.p_id AND p.yearsInProgram > '0' AND c.course_id = t.course_id GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have taught more than one course?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.student = 0 AND p.professor = 1 GROUP BY c.course_id, c.courseLevel HAVING COUNT(tb.p_id) > 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for the course with id 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors who have taught courses with course levels of 'Level_400'?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.professor = 1 AND c.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, person, taughtBy WHERE taughtBy.p_id = person.p_id AND person.yearsInProgram > 0 GROUP BY course.course_id, course.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of a course taught by a professor with a p_id of 335?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id = 335)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 107?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 107"
  },
  {
    "db_id": "computer_student",
    "question": "What course was taught by a professor?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 342?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 342"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has a student with a course level of Level_500?",
    "evidence": "",
    "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 = 1 AND course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a professor with ID 165?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 165"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with the id 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has person with id 107 taught?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id = (SELECT p_id FROM person WHERE p_id = 107) AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Who is teaching the course with course ID 51?",
    "evidence": "",
    "SQL": "SELECT person.professor FROM person, taughtBy WHERE person.p_id = taughtBy.p_id AND taughtBy.course_id = 51"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with ID 1?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been in the program for more than 6 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN person p ON tb.p_id = p.p_id JOIN course c ON tb.course_id = c.course_id WHERE p.yearsInProgram = 'Year_7' ORDER BY c.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which level of courses does the faculty teach?",
    "evidence": "",
    "SQL": "SELECT DISTINCT courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id IN (SELECT p_id FROM person WHERE hasPosition = 'Faculty')"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest level of course that a student is taking?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course does professor 1 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught course 144?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 144 AND p_id IN (SELECT p_id FROM person WHERE professor = 1) LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have advised students?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.professor = 1 AND EXISTS (SELECT 1 FROM advisedBy ab WHERE ab.p_id = p.p_id)"
  },
  {
    "db_id": "computer_student",
    "question": "Which students have not been advised by a professor?",
    "evidence": "",
    "SQL": "SELECT p.student AS student FROM person p WHERE p.hasPosition = '0'"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by a professor who has no position?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE hasPosition = '0') GROUP BY course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors with a 'Year_4' in their yearsInProgram",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel, taughtBy.p_id FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND person.yearsInProgram = 'Year_4'"
  },
  {
    "db_id": "computer_student",
    "question": "What level of courses has been taught by a faculty member?",
    "evidence": "",
    "SQL": "SELECT DISTINCT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has professor 57 taught?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 57"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 164?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 164"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has professor 331 taught?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 331"
  },
  {
    "db_id": "computer_student",
    "question": "What are the IDs of the courses taught by the professor 'Person with id 407'?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 407"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor 298?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 298"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the course with course level Level_500?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM taughtBy t JOIN person p ON t.p_id = p.p_id JOIN course c ON t.course_id = c.course_id WHERE c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of a course with course_id 29?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 29"
  },
  {
    "db_id": "computer_student",
    "question": "What are the levels of courses taught by a professor?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM taughtBy INNER JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with p_id 179?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 179"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor with at least 1 year in the program?",
    "evidence": "",
    "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.yearsInProgram >= 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with the course ID of 153?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 153"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been in the program for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND taughtBy.course_id = course.course_id AND person.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What professor teaches Level_500 courses?",
    "evidence": "",
    "SQL": "SELECT person.p_id, person.professor AS 'Professor' FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with a student having a certain level of education?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 1 AND c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with course id 124?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 124"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is person with id 175 teaching?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 175"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors with more than 10 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND person.yearsInProgram > 10"
  },
  {
    "db_id": "computer_student",
    "question": "What is the average length of years a student stays in the program?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(yearsInProgram AS INTEGER)) FROM person WHERE student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Who has taught the course with id 85?",
    "evidence": "",
    "SQL": "SELECT p.professor AS name FROM taughtBy AS t JOIN person AS p ON t.p_id = p.p_id WHERE t.course_id = 85"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id WHERE tb.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has the person with ID 67 taught?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 67"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a faculty member who has been a professor for more than 3 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 0 AND (SELECT COUNT(yearsInProgram) FROM person WHERE p_id = p.p_id) > 3"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course with ID 19?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 19"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does the professor with ID 1 teach?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id WHERE t.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course ID 18?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 18"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 5 GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by professor 181?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 181"
  },
  {
    "db_id": "computer_student",
    "question": "What are the details of a course that is taught by a certain professor?",
    "evidence": "",
    "SQL": "SELECT * FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor p_id 165?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy, course WHERE taughtBy.p_id = 165 AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with ID 240?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND taughtBy.course_id = course.course_id AND person.p_id = 240"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has a position and is in the Post_Generals phase?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN person p ON tb.p_id = p.p_id JOIN course c ON tb.course_id = c.course_id WHERE p.hasPosition='1' AND p.inPhase='Post_Generals'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 165?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 165"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is a professor with ID 290 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy LEFT JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 290"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with the id 128?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 128"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course taught by professor with ID 292?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE p_id = 292)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with ID 394?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 150?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 150"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course ID 97?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has not been in a position for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course with course_id 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have more than 0 years of experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 16?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 16"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course ID 131?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 131"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught course 85?",
    "evidence": "",
    "SQL": "SELECT p_id AS professor_id FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE course.course_id = 85"
  },
  {
    "db_id": "computer_student",
    "question": "What course does Professor with id 180 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE p_id = 180"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with ID 164?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 164"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors who have taught for more than 4 years?",
    "evidence": "",
    "SQL": "SELECT C.course_id, C.courseLevel FROM course C, taughtBy T, person P WHERE T.p_id = P.p_id AND P.yearsInProgram > 'Year_4' GROUP BY C.course_id, C.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with id 297?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND taughtBy.course_id = course.course_id AND person.p_id = 297"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by professor with p_id 394?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM taughtBy tb, course c WHERE tb.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor with ID 101?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 101"
  },
  {
    "db_id": "computer_student",
    "question": "What course is Professor 189 teaching?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 189"
  },
  {
    "db_id": "computer_student",
    "question": "What course has been taught by Professor 324?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 324"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a person who has been a professor for more than 0 years in the program?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, course.course_id FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND person.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with id 12?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 12"
  },
  {
    "db_id": "computer_student",
    "question": "What level of course is taught by the professor who teaches course 91?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course with id 24?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 24"
  },
  {
    "db_id": "computer_student",
    "question": "What is the courseLevel of course with course_id 27?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 27"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by a professor?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor with ID 415 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 415"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with at least 4 years of program?",
    "evidence": "",
    "SQL": "SELECT DISTINCT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram >= 'Year_4' GROUP BY course.course_id, course.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 331?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 331"
  },
  {
    "db_id": "computer_student",
    "question": "What level of courses does the instructor who teaches course with ID 38 teach?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with ID 181?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = 181"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor 22 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 22"
  },
  {
    "db_id": "computer_student",
    "question": "What level of course did the professor who taught course 170 teach?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE taughtBy.course_id = 170 AND person.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest level of a course?",
    "evidence": "",
    "SQL": "SELECT DISTINCT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with ID 52?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 52"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been in the program for at least 5 years?",
    "evidence": "",
    "SQL": "SELECT * FROM taughtBy NATURAL JOIN course WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE yearsInProgram='Year_5')"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the person with p_id 335?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 335"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by professors?",
    "evidence": "",
    "SQL": "SELECT DISTINCT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a person who has a position?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors teach Level_500 courses?",
    "evidence": "",
    "SQL": "SELECT DISTINCT p_id FROM taughtBy, course WHERE course.courseLevel = 'Level_500' AND course.course_id = taughtBy.course_id AND taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by Professor 99?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 99"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a person who has taught course with course id 153?",
    "evidence": "",
    "SQL": "SELECT * FROM course NATURAL JOIN taughtBy NATURAL JOIN person WHERE course_id = 153"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 97?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a professor who has been in the program for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND person.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors with more than 3 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram > 3"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does faculty member with id 1 teach?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have been in the program for more than 2 years?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 'Year_2' GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with course_id 156?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 156"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 1?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course ID 97?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97"
  },
  {
    "db_id": "computer_student",
    "question": "What course does person with ID 101 teach?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = 101"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor 107 teaching?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 107"
  },
  {
    "db_id": "computer_student",
    "question": "What professor is responsible for teaching course Level_300?",
    "evidence": "",
    "SQL": "SELECT professor FROM person JOIN taughtBy ON person.p_id = taughtBy.p_id WHERE course_id = 18"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by Professor with ID 79?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 79"
  },
  {
    "db_id": "computer_student",
    "question": "What course does professor 201 teach?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 201"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course_id 38?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 38"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by Professor 373?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 373"
  },
  {
    "db_id": "computer_student",
    "question": "What course has a professor?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = 'Faculty_aff'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by a professor who advises at least one student?",
    "evidence": "",
    "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 = 1 AND person.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with over 5 years of experience?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram LIKE '%Year_5%' OR p.yearsInProgram LIKE '%Year_4%' OR p.yearsInProgram LIKE '%Year_3%' OR p.yearsInProgram LIKE '%Year_2%' OR p.yearsInProgram LIKE '%Year_1%'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 'Year_5'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have at least one student in their program?",
    "evidence": "",
    "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"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors have taught a course at Level 500?",
    "evidence": "",
    "SQL": "SELECT professor FROM person WHERE student = 0 AND inPhase = 'Post_Generals' AND yearsInProgram = 'Year_5'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 63?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 63"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a student?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id IN (SELECT p_id FROM person WHERE student = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 129?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 129"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor who taught the course with ID 27?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.professor = 1 AND c.course_id = 27"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 170?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 170"
  },
  {
    "db_id": "computer_student",
    "question": "Which level courses did the student with id 1 take?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel FROM course c, taughtBy t, person p WHERE p.p_id = t.p_id AND p.student = 1 AND c.course_id = t.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with ID 351?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 351"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does Professor 1 teach?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a professor with a course level of 'Level_400'?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE c.courseLevel = 'Level_400' AND p.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the professor with id 319?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 319"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor who has been in the program for more than 5 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM taughtBy t JOIN person p ON t.p_id = p.p_id JOIN course c ON t.course_id = c.course_id WHERE p.yearsInProgram > 'Year_5'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a faculty member who has been a student in the program for more than 0 years?",
    "evidence": "",
    "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.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with ID 108?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 108"
  },
  {
    "db_id": "computer_student",
    "question": "What course has a professor with more than 0 years in the program?",
    "evidence": "",
    "SQL": "SELECT * FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with ID 7?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 7"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a student with id 180?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 180"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor who has 7 years of program experience and has advised at least one student?",
    "evidence": "",
    "SQL": "SELECT * FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE yearsInProgram='Year_7' AND hasPosition=0) GROUP BY course_id)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course_id 24?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 24"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course with id 53?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 53"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by faculty members?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c INNER JOIN taughtBy t ON c.course_id = t.course_id INNER JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = 'Faculty'"
  },
  {
    "db_id": "computer_student",
    "question": "What course has been taught by professor `72`?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 72"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest course level offered by the university?",
    "evidence": "",
    "SQL": "SELECT DISTINCT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "Who has taught a course with a level of 500?",
    "evidence": "",
    "SQL": "SELECT DISTINCT p_id FROM taughtBy, course WHERE course.course_id = taughtBy.course_id AND course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor 1?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 235?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 235"
  },
  {
    "db_id": "computer_student",
    "question": "Which Level_300 course is taught by the professor having `1` as their `p_id`?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE p.p_id = 1 AND c.courseLevel = 'Level_300'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has been taught by a professor who also advises a student?",
    "evidence": "",
    "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.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What level of course is the course with course ID 79?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 79"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the course taught by the person with ID 335?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 335"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with p_id = 375?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 375"
  },
  {
    "db_id": "computer_student",
    "question": "Who is teaching the Level_500 course?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM course AS c, taughtBy AS tb, person AS p WHERE c.course_id = tb.course_id AND tb.p_id = p.p_id AND c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with id 378?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM taughtBy t JOIN course c ON t.course_id = c.course_id WHERE t.p_id = 378"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors who have position?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t INNER JOIN person p ON t.p_id = p.p_id INNER JOIN course c ON t.course_id = c.course_id WHERE p.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses were taught by faculty members who have been in the program for at least 1 year?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE person.hasPosition = 'Faculty' AND person.yearsInProgram >= 1 AND course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 7?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 7"
  },
  {
    "db_id": "computer_student",
    "question": "What level of courses does professor 150 teach?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 150"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by the professor who has advised at least one student?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = 'Faculty' AND EXISTS (SELECT 1 FROM advisedBy WHERE advisedBy.p_id = person.p_id)"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the person with the ID 293?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE taughtBy.p_id = 293 AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors who have at least one student?",
    "evidence": "",
    "SQL": "SELECT C.course_id, C.courseLevel FROM course C, taughtBy TB, person P WHERE P.student = 1 AND C.course_id = TB.course_id AND TB.p_id = P.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who are not advisors for any student?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id, c.courseLevel FROM course c LEFT JOIN taughtBy t ON c.course_id = t.course_id LEFT JOIN advisedBy a ON t.p_id = a.p_id_dummy WHERE a.p_id_dummy IS NULL"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor 52 teaching?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, course.course_id FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 52"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does professor 415 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 415"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 93?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 93"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 213?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = 213"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been in a program for 5 years?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy, person WHERE person.p_id = taughtBy.p_id AND person.yearsInProgram = 'Year_5'"
  },
  {
    "db_id": "computer_student",
    "question": "What course has been taught by professor 72?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 72"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by a professor with the ID 370?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t WHERE t.p_id = (SELECT p_id FROM person WHERE p_id = 370) AND c.course_id = t.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by the professor with ID 297?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id WHERE t.p_id = 297"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been in the program for more than 4 years?",
    "evidence": "",
    "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.yearsInProgram = 'Year_5'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 101?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 101"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses were taught by professor with ID 72?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 72"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor 263?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with the course id 28?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 28"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with the id 7?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 7"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course with id 128?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 128"
  },
  {
    "db_id": "computer_student",
    "question": "What course has been taught by Professor 240?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 240"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been teaching for at least 5 years?",
    "evidence": "",
    "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.yearsInProgram >= 'Year_5' AND person.professor = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a student with a certain number of years in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.inPhase = '0' AND p.yearsInProgram = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is a student with the student ID of 1 taking?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = (SELECT p_id FROM person WHERE student = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Who are the students advised by the professors who teach courses at Level 500?",
    "evidence": "",
    "SQL": "SELECT s.p_id FROM person s, advisedBy ab, taughtBy tb, course c WHERE tb.p_id = ab.p_id AND tb.course_id = c.course_id AND c.courseLevel = 'Level_500' AND ab.p_id_dummy = s.p_id AND s.student = 1 AND s.hasPosition = 0 AND s.inPhase = 'Post_Quals' AND s.yearsInProgram = 'Year_4'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of a course taught by a person with ID 213?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id = 213)"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by the professor with the highest level?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id GROUP BY c.course_id, c.courseLevel ORDER BY c.courseLevel DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the number of courses taught by professor with ID 189?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 189"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has the student with p_id 51 taught?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE student = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Which students have professors who teach course 24?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE professor != 0 AND p_id IN (SELECT p_id FROM taughtBy WHERE course_id = 24)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by the person with id 211?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id = 211)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a student?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id IN (SELECT p_id FROM person WHERE student = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have never had a student?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with p_id 165?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = 165"
  },
  {
    "db_id": "computer_student",
    "question": "Who is the professor for course with ID 41?",
    "evidence": "",
    "SQL": "SELECT professor FROM person WHERE p_id IN (SELECT p_id FROM taughtBy WHERE course_id = 41)"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the students who are advised by a professor?",
    "evidence": "",
    "SQL": "SELECT s.student FROM person s JOIN advisedBy ab ON s.p_id = ab.p_id_dummy WHERE ab.p_id IN (SELECT p_id FROM person WHERE professor = 1) AND s.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a professor who has taught more than 5 courses?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE person.p_id = taughtBy.p_id AND taughtBy.course_id = course.course_id AND (SELECT COUNT(*) FROM taughtBy WHERE taughtBy.p_id = person.p_id) > 5"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with p_id 180?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id = 180 and course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a faculty member who has advised at least one student?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.hasPosition = 'Faculty' AND p.p_id IN (SELECT p_id_dummy FROM advisedBy ab WHERE p_id IN (SELECT p_id FROM person WHERE student = 1))"
  },
  {
    "db_id": "computer_student",
    "question": "Which students have been advised by someone who teaches a course at Level_400?",
    "evidence": "",
    "SQL": "SELECT p.student AS Student_ID FROM person p JOIN advisedBy ab ON p.p_id = ab.p_id JOIN taughtBy tb ON ab.p_id_dummy = tb.p_id WHERE tb.course_id IN (SELECT course_id FROM course WHERE courseLevel='Level_400') AND p.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by the professor?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course id 66?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 66"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with ID 290?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 290"
  },
  {
    "db_id": "computer_student",
    "question": "What level of courses has a professor taught?",
    "evidence": "",
    "SQL": "SELECT DISTINCT courseLevel FROM course WHERE EXISTS (SELECT 1 FROM taughtBy WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1))"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches Level_500 courses?",
    "evidence": "",
    "SQL": "SELECT p.p_id, p.professor FROM person p JOIN taughtBy tb ON p.p_id = tb.p_id JOIN course c ON tb.course_id = c.course_id WHERE c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course ID 28?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 28"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with at least 5 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t, person p WHERE c.course_id = t.course_id AND t.p_id = p.p_id AND p.yearsInProgram >= 5"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 89?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 89"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors with more than 5 years of program experience?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND person.yearsInProgram > 5 AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors taught course 77?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE professor=1 AND student=0 AND EXISTS (SELECT 1 FROM taughtBy WHERE course_id=77 AND taughtBy.p_id=person.p_id)"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a professor who has taught in the program for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by faculty members with more than 5 years of experience in the program?",
    "evidence": "",
    "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.yearsInProgram > 5"
  },
  {
    "db_id": "computer_student",
    "question": "Which level of course does Professor 52 teach?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 52"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with ID 1?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has taught 'Level_400'?",
    "evidence": "",
    "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.professor = 1 AND course.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors with more than 3 years of program experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 0 AND p.yearsInProgram != 'Year_1' GROUP BY c.course_id, c.courseLevel HAVING COUNT(DISTINCT p.p_id) > 3"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has professor 1 taught?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel, t.p_id FROM course c INNER JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by person with professor=0?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy tb WHERE c.course_id = tb.course_id AND tb.p_id NOT IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches the course with ID 134?",
    "evidence": "",
    "SQL": "SELECT p.student, c.courseLevel FROM person p, course c, taughtBy tb WHERE p.p_id = tb.p_id AND c.course_id = tb.course_id AND c.course_id = 134"
  },
  {
    "db_id": "computer_student",
    "question": "What course does Professor [insert name] teach?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition='1'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the course with id 71?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 71"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have advised students?",
    "evidence": "",
    "SQL": "SELECT DISTINCT course.course_id FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND person.hasPosition = '1' AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by the professor who has taught the course with ID 114?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 0 AND p.professor != 0 AND c.course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "What course is being taught by the professor with ID 52?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 52"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 159?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 159"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by Professor 1?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses have been taught by professor 165?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 165"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for the course with course_id 45?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 45"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a professor who has no position?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = '0'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is person with id 394 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE p_id = 394)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of a course with course_id equal to 136?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 136"
  },
  {
    "db_id": "computer_student",
    "question": "What level of courses did a student, who has been in a program for 5 years, take under the supervision of a professor?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE yearsInProgram = 'Year_5' AND student = 1) ORDER BY course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by professors with at least 0 years of experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram >= '0'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor who has a yearsInProgram of Year_1?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND person.yearsInProgram='Year_1'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the course 'Level_500'?",
    "evidence": "",
    "SQL": "SELECT p.student, p.p_id AS professor_id FROM person p, taughtBy t WHERE p.p_id = t.p_id AND t.course_id = (SELECT course_id FROM course WHERE courseLevel = 'Level_500') GROUP BY p.student, p.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course has professor 1?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses taught by a person with a position 'Position_1'?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel, c.course_id FROM course c, taughtBy t, person p WHERE c.course_id = t.course_id AND t.p_id = p.p_id AND p.hasPosition = 'Position_1'"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches a course at Level_400?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy, course WHERE course.course_id = taughtBy.course_id AND course.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 155?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 155"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by professor 180?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id = 180)"
  },
  {
    "db_id": "computer_student",
    "question": "Who has taught the course with course ID 20?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 20"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course with id 15?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 15"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with id 211?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 211"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 48?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 48"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches a Level_500 course?",
    "evidence": "",
    "SQL": "SELECT person.student, person.p_id, course.courseLevel, course.course_id FROM course, person, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course does professor 150 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 150"
  },
  {
    "db_id": "computer_student",
    "question": "What course was taught by the professor with id 201?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 201"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors with at least 5 years of experience in their field?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram >= '5'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 167?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 167"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with p_id 213?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c, taughtBy t WHERE c.course_id = t.course_id AND t.p_id = 213"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor 82 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 82"
  },
  {
    "db_id": "computer_student",
    "question": "Who is the student of the person with ID 200?",
    "evidence": "",
    "SQL": "SELECT student FROM person WHERE p_id = 200"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has been taught by professor who has taught a Level_400 course?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE c.courseLevel = 'Level_400' AND p.student = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is Professor [???] teaching?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, course.course_id FROM course, taughtBy WHERE taughtBy.p_id IN (SELECT person.p_id FROM person WHERE person.professor = 1) AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest course level that any course offered by our department is at?",
    "evidence": "",
    "SQL": "SELECT MAX(courseLevel) FROM course"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has professor 201 taught?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 201"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor 364 teaching?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy tb WHERE tb.p_id = 364 AND tb.course_id = c.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 29?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 29"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the instructor with ID 331?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 331"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest course level taught by a faculty with at least 0 years of experience?",
    "evidence": "",
    "SQL": "SELECT DISTINCT course.courseLevel FROM course, person, taughtBy WHERE person.p_id = taughtBy.p_id AND person.yearsInProgram >= 0 AND course.course_id = taughtBy.course_id ORDER BY course.courseLevel DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course id 57?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 57"
  },
  {
    "db_id": "computer_student",
    "question": "What course level does a student with the course ID 61 take?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 61"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course taught by p_id 319?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 319"
  },
  {
    "db_id": "computer_student",
    "question": "Who is the student in the course Level_500?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND inPhase = 0 AND yearsInProgram = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has a certain level in a course?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t, person p WHERE t.p_id = p.p_id AND p.student = 0 AND c.course_id = t.course_id AND c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses taught by the professors in Year_1 of the Pre_Quals phase?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.inPhase = 'Pre_Quals' AND p.yearsInProgram = 'Year_1'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor who has been in the program for more than one year?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t INNER JOIN person p ON t.p_id = p.p_id INNER JOIN course c ON t.course_id = c.course_id WHERE p.yearsInProgram != 'Year_1' AND p.student = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses have been taught by the faculty?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb INNER JOIN course c ON tb.course_id = c.course_id WHERE tb.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has at least 2 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, person, taughtBy WHERE person.p_id = taughtBy.p_id AND person.yearsInProgram >= '1' AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is the professor who has been in the program for 0 years teaching?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram = '0' AND p.hasPosition = 'Faculty_aff'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been in the program for at least 2 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c INNER JOIN taughtBy tb ON c.course_id = tb.course_id INNER JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram = 'Year_2' AND p.student = 0"
  },
  {
    "db_id": "computer_student",
    "question": "Which professor taught the course with the course level Level_500?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by the professor who advised person with ID 62?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 62"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with ID 394?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course number 48?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 48"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 20?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 20"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses taught by the person with ID 52?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy, course WHERE taughtBy.p_id = course.course_id AND taughtBy.p_id = 52"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor who has taught for more than 5 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 0 AND p.yearsInProgram = 'Year_5' LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been a student in Phase Pre-Quals and has been in the program for more than one year?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = '1' AND person.inPhase = 'Pre_Quals' AND person.yearsInProgram = 'Year_2'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the courseLevel of the course with id 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with ID 72?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = 72"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course with id 7?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 7"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the course with ID 34?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 34"
  },
  {
    "db_id": "computer_student",
    "question": "Which level are most of the courses in?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(SUBSTR(courseLevel, 7) AS INTEGER)) FROM course"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest level of the course with course ID 14?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 14"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 131?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 131"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor with p_id 72?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 72"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor with id 235 teaching?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 235"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 44?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 44"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 168?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 168"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with ID 101?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 101"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by professors with more than one year in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = 'Year_1' GROUP BY c.course_id, c.courseLevel HAVING COUNT(p.p_id) > 1"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught a Level_500 course?",
    "evidence": "",
    "SQL": "SELECT p_id, courseLevel FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND course.courseLevel='Level_500' ORDER BY p_id"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches Level 500 course?",
    "evidence": "",
    "SQL": "SELECT person.professor FROM person, course, taughtBy WHERE course.course_id = taughtBy.course_id AND course.courseLevel = 'Level_500' AND taughtBy.p_id = person.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of a course taught by a professor?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course 144?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 144"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course with id 66?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 66"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor who has taught Level_500?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.hasPosition = '0' AND c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the faculty member who has taught a Level_500 course?",
    "evidence": "",
    "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.hasPosition = 'Faculty' AND course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What course does professor with ID 213 teach?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 213"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with at least 0 years in program?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND person.yearsInProgram >= 0 AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has Professor with ID 1 taught?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id = 1 AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by Professor [Professor's Name]?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.student = 0 AND person.hasPosition = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 156?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 156"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been teaching for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor 1?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors who have at least one student?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy AS tb INNER JOIN course AS c ON tb.course_id = c.course_id INNER JOIN person AS p ON tb.p_id = p.p_id WHERE p.student = 1 GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by the professor with ID 141?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 141"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the professor who taught Course 147?",
    "evidence": "",
    "SQL": "SELECT p.student, p.hasPosition FROM person p, taughtBy t WHERE t.course_id = 147 AND p.p_id = t.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor 165?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 165"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor with a position?",
    "evidence": "",
    "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.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have more than 0 years in program?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy, course, person WHERE taughtBy.p_id = person.p_id AND person.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with id 240?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 240"
  },
  {
    "db_id": "computer_student",
    "question": "Who is the professor of the course with course_id 107?",
    "evidence": "",
    "SQL": "SELECT professor FROM person WHERE p_id IN (SELECT p_id FROM taughtBy WHERE course_id = 107)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by the professor with the highest years in program?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = (SELECT MAX(y.yearsInProgram) FROM person y) AND p.student = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with course ID 131?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 131"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by Professor 255?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 255"
  },
  {
    "db_id": "computer_student",
    "question": "What is the average course level of all courses?",
    "evidence": "",
    "SQL": "SELECT AVG(courseLevel) FROM course"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the Level_400 course?",
    "evidence": "",
    "SQL": "SELECT P.professor FROM course C, person P, taughtBy T WHERE C.course_id = T.course_id AND P.p_id = T.p_id AND C.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with id 117?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 117"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has more than 0 years in a program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What level is the course '98'?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 98"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by Professor 234?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 234"
  },
  {
    "db_id": "computer_student",
    "question": "What level is course with id 14?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 14"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with the most years in the program?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy, person WHERE taughtBy.p_id = person.p_id AND yearsInProgram = (SELECT MAX(yearsInProgram) FROM person)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 32?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 32"
  },
  {
    "db_id": "computer_student",
    "question": "Which level of course has been taught by the most professors?",
    "evidence": "",
    "SQL": "SELECT courseLevel, COUNT(*) AS count FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id GROUP BY courseLevel ORDER BY count DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which person has not yet completed their program?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE yearsInProgram='Year_4' AND inPhase='Post_Quals'"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches the Level_400 course?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = (SELECT course_id FROM course WHERE courseLevel = 'Level_400')"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 124?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 124"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course taught by a person with student_id 1?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses taught by a professor who has been in a certain program for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with ID 235?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 235"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with id 56?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 56"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses were taught by professors who have been teaching for more than 2 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 2"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have more than 4 years in program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 'Year_4'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is person with id 108 not teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course LEFT JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IS NULL AND course.course_id IN (SELECT course_id FROM course WHERE NOT EXISTS (SELECT 1 FROM taughtBy WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = 108))"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor who has been in the program for more than 2 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM taughtBy t JOIN person p ON t.p_id = p.p_id JOIN course c ON t.course_id = c.course_id WHERE p.yearsInProgram > 'Year_2'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course 139?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 139"
  },
  {
    "db_id": "computer_student",
    "question": "What are the names of all students who have taken a Level_400 course?",
    "evidence": "",
    "SQL": "SELECT student FROM person WHERE student = 1 AND inPhase = '0' AND yearsInProgram = '0' AND exists (SELECT * FROM taughtBy tb WHERE tb.course_id IN (SELECT course_id FROM course WHERE courseLevel = 'Level_400') AND tb.p_id = person.p_id)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been in the program for more than one year?",
    "evidence": "",
    "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.yearsInProgram = 'Year_2' OR person.yearsInProgram = 'Year_3'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with the course ID 77?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 77"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been in the program for at least 3 years?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, person, taughtBy WHERE person.p_id = taughtBy.p_id AND person.yearsInProgram = 'Year_3' AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been in the program for more than 1 year?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram LIKE '%Year_2%' OR p.yearsInProgram LIKE '%Year_3%' OR p.yearsInProgram LIKE '%Year_4%'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors with a position of 'Faculty'?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id, c.courseLevel FROM course c, taughtBy t, person p WHERE p.hasPosition = 'Faculty' AND c.course_id = t.course_id AND p.p_id = t.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a professor with ID 331?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course, taughtBy WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = 331"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest level course taught by a professor?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the professor who has taught the most courses?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id GROUP BY c.course_id, c.courseLevel ORDER BY COUNT(t.p_id) DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses taught by the professor with p_id 79?",
    "evidence": "",
    "SQL": "SELECT * FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 79"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with id 76?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 76"
  },
  {
    "db_id": "computer_student",
    "question": "What is the courseLevel of course with course_id 139?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 139"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course_id 34?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 34"
  },
  {
    "db_id": "computer_student",
    "question": "What are the professors that teach a course at Level 400?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE professor = 0 AND EXISTS (SELECT 1 FROM taughtBy WHERE p_id = person.p_id AND course_id = (SELECT course_id FROM course WHERE courseLevel = 'Level_400'))"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the course with ID 8?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 8"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a person who has been a professor for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 0 AND LENGTH(p.yearsInProgram) > 0"
  },
  {
    "db_id": "computer_student",
    "question": "Who is teaching which course?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, person.professor, person.student FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors who advise at least one student?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.p_id IN (SELECT p_id FROM person WHERE hasPosition = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What professor teaches course 86?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course with ID 169?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 169"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 128?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 128"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest level of course that a student is enrolled in?",
    "evidence": "",
    "SQL": "SELECT MAX(courseLevel) FROM course"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by Professor 407?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 407"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the professor with courseLevel Level_400?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE course.courseLevel = 'Level_400' AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course number 173?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 173"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses were taught by professors who are in their 4th year of the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = 'Year_4'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the professor who taught course 103?",
    "evidence": "",
    "SQL": "SELECT person.professor FROM taughtBy, person WHERE taughtBy.course_id = 103 AND taughtBy.p_id = person.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 13?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 13"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest level course taught by professor '101'?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 101 ORDER BY course.course_id DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What professor taught course with id 170?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id JOIN person p ON tb.p_id = p.p_id WHERE c.course_id = 170"
  },
  {
    "db_id": "computer_student",
    "question": "Which faculty members have taught courses in Level_500?",
    "evidence": "",
    "SQL": "SELECT professor FROM person p JOIN taughtBy t ON p.p_id = t.p_id JOIN course c ON t.course_id = c.course_id WHERE c.courseLevel = 'Level_500' AND p.hasPosition = 'Faculty'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the faculty that has been in the program for at least 5 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram >= '5' GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "Who is the professor who taught course 101?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 0 AND hasPosition = '0' AND inPhase = 'Post_Quals' AND yearsInProgram = 'Year_3' AND p_id IN (SELECT p_id FROM taughtBy WHERE course_id = 101)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor who has taught Course 48?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t WHERE c.course_id = t.course_id AND t.p_id = (SELECT p_id FROM person WHERE professor = 1) ORDER BY c.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor having ID 351?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 351"
  },
  {
    "db_id": "computer_student",
    "question": "What are the names of courses taught by the professor?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor who has been in the program for more than two years?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram LIKE '%Year_2%' OR p.yearsInProgram LIKE '%Year_3%'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors with at least 0 years of experience?",
    "evidence": "",
    "SQL": "SELECT * FROM course NATURAL JOIN taughtBy NATURAL JOIN person WHERE person.yearsInProgram >= 0"
  },
  {
    "db_id": "computer_student",
    "question": "Who is teaching course with id 18?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 18"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the professor who advised the student with the ID 150?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 150 AND person.hasPosition = '0'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is person '27' teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 27"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with course_id 135?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 135"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught course with id 18?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM taughtBy AS tb JOIN course AS c ON tb.course_id = c.course_id JOIN person AS p ON tb.p_id = p.p_id WHERE c.course_id = 18"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has professor 378 taught?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 378"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors are teaching courses at Level_500?",
    "evidence": "",
    "SQL": "SELECT p.professor as professor FROM person p JOIN taughtBy t ON p.p_id = t.p_id WHERE t.course_id IN (SELECT course_id FROM course WHERE courseLevel='Level_500') and p.student=0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with the id 61?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 61"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor who advises a student who has been in the program for five years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = 'Year_5' AND EXISTS (SELECT * FROM advisedBy a WHERE a.p_id = p.p_id AND a.p_id_dummy IN (SELECT p_id FROM person WHERE student = 1))"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 141?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 141"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with ID 211?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 211"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 129?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 129"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with id 290?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 290"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with id 290?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 290"
  },
  {
    "db_id": "computer_student",
    "question": "Which students are in Level 500 courses taught by a professor having more than 2 years of experience?",
    "evidence": "",
    "SQL": "SELECT p.student AS student FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE c.courseLevel = 'Level_500' AND p.yearsInProgram > 2"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the professor with id 181?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1) AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by professor with id 394?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses taught by the professors?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 27?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 27"
  },
  {
    "db_id": "computer_student",
    "question": "What courses have been taught by Professor with ID 64?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 64"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 20?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 20"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course ID 121?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 121"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with course_id 12?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 12"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught course with ID 11?",
    "evidence": "",
    "SQL": "SELECT person.p_id, person.professor, person.student FROM person, taughtBy WHERE taughtBy.course_id = 11 AND taughtBy.p_id = person.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 20?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 20"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy tb, person p WHERE p.p_id = tb.p_id AND tb.course_id = c.course_id AND p.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who are also students?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1 AND person.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is Professor with ID 79 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 79"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with ID 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course ID 56?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 56"
  },
  {
    "db_id": "computer_student",
    "question": "What courses have been taught by a professor?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE person.p_id = taughtBy.p_id AND taughtBy.course_id = course.course_id AND person.hasPosition = 'professor'"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses that are taught by professor with the most years in program?",
    "evidence": "",
    "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.yearsInProgram = (SELECT MAX(yearsInProgram) FROM person) ORDER BY course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with ID 324?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE taughtBy.p_id = 324 AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with more than 2 years in the program?",
    "evidence": "",
    "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.yearsInProgram >= 'Year_3'"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors have taught a course at Level_500?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND (SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id = person.p_id)) = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor with at least 5 years of experience?",
    "evidence": "",
    "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.yearsInProgram >= 5"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor who has taught the most Level_500 courses?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel, COUNT(1) FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND course.courseLevel = 'Level_500' GROUP BY taughtBy.course_id, course.course_id HAVING COUNT(1) = (SELECT COUNT(1) FROM taughtBy WHERE course_id IN (SELECT course_id FROM course WHERE courseLevel = 'Level_500') GROUP BY course_id ORDER BY COUNT(1) DESC LIMIT 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 146?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 146"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with id 57?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 57"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by a professor with more than 3 years of experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram > 3"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with course ID 61?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 61"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has a level of 'Level_500'?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is person with p_id = 104 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id = 104 AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the person who has been a student for Year_5?",
    "evidence": "",
    "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 = 1 AND person.yearsInProgram = 'Year_5'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for the course with course ID 128?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 128"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has the highest level and is taught by a specific professor?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t WHERE c.course_id = t.course_id AND t.p_id IN (SELECT p_id FROM person WHERE professor = 1) ORDER BY c.courseLevel DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors teach Level_400 courses?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND inPhase = 'Post_Quals' AND yearsInProgram = 'Year_4' AND hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a person who is not a professor?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.professor = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor 290 teaching?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, course.course_id FROM taughtBy INNER JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 290"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors with more than 2 years in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel, t.p_id FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 2"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is person with id 418 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = (SELECT p_id FROM person WHERE p_id = 418)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the courseLevel of the course with course_id 160?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 160"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor who has been in the program for 0 years?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy, person WHERE person.student = 1 AND person.hasPosition = 0 AND person.yearsInProgram = 0 AND person.p_id = taughtBy.p_id AND course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course has the course level Level_500?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has taught a course at Level 500?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 0 AND c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What course has been taught by a professor who has also advised a student?",
    "evidence": "",
    "SQL": "SELECT * FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM advisedBy))"
  },
  {
    "db_id": "computer_student",
    "question": "What courses have been taught by a professor who has advised a student?",
    "evidence": "",
    "SQL": "SELECT distinct c.course_id, c.courseLevel FROM taughtBy tb JOIN person p ON tb.p_id = p.p_id JOIN advisedBy ab ON p.p_id = ab.p_id_dummy JOIN course c ON tb.course_id = c.course_id WHERE ab.p_id_dummy IS NOT NULL"
  },
  {
    "db_id": "computer_student",
    "question": "Who has taught 'Level_500' courses?",
    "evidence": "",
    "SQL": "SELECT person.p_id FROM person JOIN taughtBy ON person.p_id = taughtBy.p_id WHERE course_id = 158"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the course with id 64?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 64"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel, course.course_id AS id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course ID 61?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 61"
  },
  {
    "db_id": "computer_student",
    "question": "Who has taught the course with ID 120?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 120"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor having ID 240?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 240"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 91?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 91"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have taught courses at a level of Level_500?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t, person p WHERE c.course_id = t.course_id AND t.p_id = p.p_id AND p.professor = 1 AND c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the course with ID 27?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = '27'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a professor with student `1`?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, person, taughtBy WHERE person.p_id = taughtBy.p_id AND taughtBy.course_id = course.course_id AND person.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by a professor with the id 335?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy INNER JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 335"
  },
  {
    "db_id": "computer_student",
    "question": "Who are the professors in Year_2 of the Post_Quals phase?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE yearsInProgram='Year_2' AND inPhase='Post_Quals' AND student=0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with id 15?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 15"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course ID 56?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 56"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have positions?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 21?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 21"
  },
  {
    "db_id": "computer_student",
    "question": "Which level course is taught by a student?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE student = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has 'Level_400' as its level?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What course has 'Level_400'?",
    "evidence": "",
    "SQL": "SELECT * FROM course WHERE courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What level of courses has professor 394 taught?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with course level Level_500?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.p_id IN (SELECT p_id FROM person WHERE hasPosition = '1') AND c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by Professor 204?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c, taughtBy t WHERE c.course_id = t.course_id AND t.p_id = 204"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with 0 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = 'Year_0' AND p.student = 0"
  },
  {
    "db_id": "computer_student",
    "question": "Which level of courses is taught by Professor with ID 5?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 5"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by the professor who has a 'Level_500' course?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.professor = 1 AND c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with course id 164?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 164"
  },
  {
    "db_id": "computer_student",
    "question": "What course has a level of Level_500 and who taught it?",
    "evidence": "",
    "SQL": "SELECT c.course_id, p.student, c.courseLevel, p.p_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor John?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE student = 0)"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the course with course_id 117?",
    "evidence": "",
    "SQL": "SELECT person.p_id, person.student FROM person, taughtBy WHERE person.p_id = taughtBy.p_id AND course_id = 117 AND person.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by the professors having more than 2 years of experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel, p.p_id, p.yearsInProgram FROM course c, person p, taughtBy t WHERE p.p_id = t.p_id AND p.yearsInProgram >= 'Year_3' GROUP BY c.course_id, c.courseLevel, p.p_id, p.yearsInProgram"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by Professor with ID 1?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a professor who has no student?",
    "evidence": "",
    "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"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor who is also a student?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.professor = 1 AND p.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been in the program for at least 3 years?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND person.yearsInProgram >= '3'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses have been taught by a professor with at least 5 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t, person p WHERE c.course_id = t.course_id AND t.p_id = p.p_id AND p.yearsInProgram >= 5"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches the course with courseLevel 'Level_500'?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id IN (SELECT course_id FROM course WHERE courseLevel = 'Level_500') AND p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 79?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 79"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is the professor with p_id = 81 teaching?",
    "evidence": "",
    "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.p_id = 81"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor '278'?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 278"
  },
  {
    "db_id": "computer_student",
    "question": "What level of course is taught by faculty with at least 0 years of experience?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND person.yearsInProgram = '0' AND person.hasPosition = 'Faculty'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor who advised by another professor?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person AS p1 ON taughtBy.p_id = p1.p_id JOIN advisedBy AS ab ON ab.p_id = p1.p_id AND ab.p_id_dummy IS NOT NULL JOIN person AS p2 ON ab.p_id_dummy = p2.p_id WHERE p1.professor = 0"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has been taught by a professor with the position 'Faculty' in Phase 0 and has more than 0 years in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = 'Faculty' AND p.inPhase = '0' AND p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What course does professor 213 teach?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 213"
  },
  {
    "db_id": "computer_student",
    "question": "What level of course is the course with ID 97?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches 'Level_400' courses?",
    "evidence": "",
    "SQL": "SELECT p.student, p.p_id, c.course_id FROM person p JOIN taughtBy t ON p.p_id = t.p_id JOIN course c ON t.course_id = c.course_id WHERE c.courseLevel = 'Level_400' AND p.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a person with ID 394?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND taughtBy.course_id = course.course_id AND person.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "What is the professor of the course with course ID 143?",
    "evidence": "",
    "SQL": "SELECT person.professor FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND course.course_id = 143"
  },
  {
    "db_id": "computer_student",
    "question": "Who has taught the course with ID 146?",
    "evidence": "",
    "SQL": "SELECT person.p_id FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE taughtBy.course_id = 146"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by the professor with ID 1?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1))"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses has Professor 1 taught?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy AS tb JOIN course AS c ON tb.course_id = c.course_id WHERE tb.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Who are the professors who teach a course that is at a 500 level?",
    "evidence": "",
    "SQL": "SELECT person.p_id, person.student FROM person JOIN taughtBy ON person.p_id = taughtBy.p_id JOIN course ON taughtBy.course_id = course.course_id WHERE course.courseLevel = 'Level_500' AND person.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor with ID 181?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 181"
  },
  {
    "db_id": "computer_student",
    "question": "Who has not taught any courses?",
    "evidence": "",
    "SQL": "SELECT p_id, professor, student, hasPosition, inPhase, yearsInProgram FROM person WHERE p_id NOT IN (SELECT p_id FROM taughtBy)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has a professor who has been in the program for more than 5 years taught?",
    "evidence": "",
    "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.yearsInProgram > 'Year_5' GROUP BY course.course_id, course.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with id 51?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 51"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a student who has completed 5 years of the program?",
    "evidence": "",
    "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 = 1 AND person.yearsInProgram = 'Year_5'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of a course with course_id 53?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 53"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 150?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 150"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with at least 1 year of program experience?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram >= 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor with more than 10 years in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c INNER JOIN taughtBy tb ON c.course_id = tb.course_id INNER JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram > 'Year_10' GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by person with ID 319?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 319"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught a course with level Level_400?",
    "evidence": "",
    "SQL": "SELECT person.professor FROM person JOIN taughtBy ON person.p_id = taughtBy.p_id JOIN course ON taughtBy.course_id = course.course_id WHERE course.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 61?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 61"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with p_id=98?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 98"
  },
  {
    "db_id": "computer_student",
    "question": "What is the average yearsInProgram for students who have a professor?",
    "evidence": "",
    "SQL": "SELECT AVG(yearsInProgram) FROM person WHERE professor = 1 AND student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches a course of Level_300?",
    "evidence": "",
    "SQL": "SELECT person.professor AS name FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND course.courseLevel = 'Level_300'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has a professor who has taught at least one course?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id GROUP BY course.course_id HAVING COUNT(taughtBy.p_id) > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course id 129?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 129"
  },
  {
    "db_id": "computer_student",
    "question": "Who has taught which course?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel, p.student, t.course_id FROM taughtBy t JOIN person p ON t.p_id = p.p_id JOIN course c ON t.course_id = c.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses that Professor 1 teaches?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy INNER JOIN course ON taughtBy.course_id = course.course_id WHERE p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with 'Level_500' courses?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = '0' AND course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has a level of Level_500?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course with ID 34?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 34"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been in the program for more than one year?",
    "evidence": "",
    "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.yearsInProgram > 0 GROUP BY course.course_id, course.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course with course id 101?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 101"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course ID 110?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 110"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel, t.p_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course with ID 3?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 3"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have at least 1 year of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 75?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 75"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the professor with id 1?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND person.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has the highest course level?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course ORDER BY course.courseLevel DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with ID 234?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 234"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with course id 39?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 39"
  },
  {
    "db_id": "computer_student",
    "question": "What level of courses does professor 293 teach?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 293"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a professor who has never held a position?",
    "evidence": "",
    "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.hasPosition = '0'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a professor who has been in the program for more than 2 years?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram = 'Year_3' OR person.yearsInProgram = 'Year_4'"
  },
  {
    "db_id": "computer_student",
    "question": "What professor taught a course of level 500?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course taught by professor 64?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 64"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by professor 324?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id = 324) LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with the ID 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is currently being taught by the professor with ID 1?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with ID 204?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c, taughtBy t WHERE c.course_id = t.course_id AND t.p_id = 204"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course ID 64?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 64"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor 79 teaching?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 79"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has a position?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does person with id 52 teach?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 52"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 67?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 67"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been teaching for more than 1 year?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy AS tb JOIN course AS c ON tb.course_id = c.course_id JOIN person AS p ON tb.p_id = p.p_id WHERE p.inPhase = '0' AND p.yearsInProgram > 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course ID 19?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 19"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have at least 5 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 5 AND p.student = 0 GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is not taught by a professor?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course LEFT JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IS NULL"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 107?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 107"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with id 146?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 146"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with id 45?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 45"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor who has taught 'Level_500' course?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1) AND course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has a level of Level_500?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel='Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor who teaches the course with course ID 11?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.professor = 1 AND c.course_id = 11"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor having the ID 124?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 124"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches courses of Level_500?",
    "evidence": "",
    "SQL": "SELECT DISTINCT p_id FROM taughtBy, course WHERE course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does Professor 240 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 240"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by a professor with at least 7 years in the program?",
    "evidence": "",
    "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.yearsInProgram = 'Year_7'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with ID 324?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 324"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by person with p_id 72?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 72"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course with id 32?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 32"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course with id 134?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 134"
  },
  {
    "db_id": "computer_student",
    "question": "What course was taught by the professor who has not held a position yet?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND person.hasPosition = '0' LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 141?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 141"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with id 155?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 155"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has professor with id 235 taught?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 235"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor with ID 9?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c INNER JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 9"
  },
  {
    "db_id": "computer_student",
    "question": "What courses have Professor 211 taught?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE taughtBy.p_id = course.course_id AND taughtBy.p_id = 211"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses taught by a professor who has taught 'course ID: 4'?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.professor = 1 AND c.course_id = 4"
  },
  {
    "db_id": "computer_student",
    "question": "Who is teaching the course 'Level_500'?",
    "evidence": "",
    "SQL": "SELECT p.student FROM person p JOIN taughtBy tb ON p.p_id = tb.p_id WHERE tb.course_id = 144 AND p.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest level course taught by a professor in the database?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1) ORDER BY courseLevel DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses have been taught by professors with at least 2 years of program experience?",
    "evidence": "",
    "SQL": "SELECT DISTINCT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram >= 2"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with id 30?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 30"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors who have a Level_400 course?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id, c.courseLevel, t.p_id, t.course_id AS taughtCourse FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = '1' AND c.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses have professor 331 taught?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 331"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who are advisors?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel, t.p_id, p.hasPosition FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = 'Faculty'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with p_id = 165?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id = 165 AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with id 107?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 107"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 134?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 134"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by a professor?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = 'professor'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is a student in year 7 advised by Professor 'someone'?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, person, advisedBy, taughtBy WHERE course.courseLevel = 'Level_500' AND person.p_id = advisedBy.p_id AND advisedBy.p_id_dummy = taughtBy.p_id AND taughtBy.course_id = course.course_id AND person.inPhase = 'Post_Generals' AND person.yearsInProgram = 'Year_7'"
  },
  {
    "db_id": "computer_student",
    "question": "What course has been taught by the professor with ID 165?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 165"
  },
  {
    "db_id": "computer_student",
    "question": "Who advises students in the Level_500 course?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND inPhase = 'Post_Generals' AND yearsInProgram = 'Year_5' AND hasPosition = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What course is Professor 107 teaching?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor who has taught at least 5 courses?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.professor = 1 AND (SELECT COUNT(*) FROM taughtBy t WHERE t.p_id = p.p_id) >= 5"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the course with course id 49?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 49"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with professor_id 278?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel FROM course c, taughtBy tb WHERE c.course_id = tb.course_id AND tb.p_id = 278"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest level course taught by a professor who advised someone?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = '1' ORDER BY c.courseLevel DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does person with id 37 teach?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.p_id = 37"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have been in a phase for 1 year?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.inPhase = '1' AND p.yearsInProgram = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What course has Professor 1 as its instructor?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id = 1 AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have more than 3 years of experience in their program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN person p ON tb.p_id = p.p_id JOIN course c ON tb.course_id = c.course_id WHERE p.yearsInProgram > 'Year_3'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been a faculty member for more than 0 years?",
    "evidence": "",
    "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.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is the professor with p_id 248 teaching?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb INNER JOIN course c ON tb.course_id = c.course_id WHERE tb.p_id = 248"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course with id 40?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 40"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who is not in the 0th phase?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy, person WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = person.p_id AND person.inPhase != '0'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with more than 2 years of experience in a program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 'Year_2'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by students?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is person with ID 298 teaching?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t WHERE t.p_id = 298 AND c.course_id = t.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been in the program for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t, person p WHERE c.course_id = t.course_id AND t.p_id = p.p_id AND p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor 1?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course number 35?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 35"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by Professor '213'?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 213"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the course taught by person with ID 180?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 180"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been in the program for more than 4 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram > 'Year_4' ORDER BY c.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course 101?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 101"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors having at least 0 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram >= 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses have been taught by professor 107?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 107"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has taught at least one Level_400 course?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.hasPosition = 1 AND c.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor with id 180?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 180"
  },
  {
    "db_id": "computer_student",
    "question": "What level are courses taught by professor 211?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1) AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with the ID 394?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors have taught courses at the level of Level_500?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE (p_id IN (SELECT p_id FROM taughtBy WHERE course_id IN (SELECT course_id FROM course WHERE courseLevel = 'Level_500'))) AND professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course has been taught by a professor with the faculty position 'Faculty_eme'?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = 'Faculty_eme'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 150?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 150"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 103?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 103"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses does a person with the ID 335 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 335"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a professor who has taught Level_500 courses?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1 AND course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which professor has taught 'Level_500' course?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE p_id IN (SELECT p_id FROM taughtBy WHERE course_id = (SELECT course_id FROM course WHERE courseLevel = 'Level_500')) AND professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Who are the professors in Pre_Quals phase in Year_1 program?",
    "evidence": "",
    "SQL": "SELECT professor FROM person WHERE inPhase = 'Pre_Quals' AND yearsInProgram = 'Year_1'"
  },
  {
    "db_id": "computer_student",
    "question": "Which professor has taught a course that has a level of Level_500?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE p_id IN (SELECT p_id FROM taughtBy WHERE course_id IN (SELECT course_id FROM course WHERE courseLevel='Level_500')) AND professor=1"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses that a student is not taking?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel FROM course c LEFT JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id IS NULL"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches courses at Level 500?",
    "evidence": "",
    "SQL": "SELECT person.p_id, person.professor AS name FROM person JOIN taughtBy ON person.p_id = taughtBy.p_id JOIN course ON taughtBy.course_id = course.course_id WHERE course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses have a level of Level_400?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What course does professor with ID 240 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 240"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches a Level 400 course?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM taughtBy tb INNER JOIN course c ON tb.course_id = c.course_id INNER JOIN person p ON tb.p_id = p.p_id WHERE c.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by Professor '1'?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c INNER JOIN taughtBy tb ON c.course_id = tb.course_id WHERE tb.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 97?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97"
  },
  {
    "db_id": "computer_student",
    "question": "Who has taught a Level_400 course?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy, course WHERE course.courseLevel='Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course with course id 44?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 44"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course ID 19?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 19"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does person 203 teach?",
    "evidence": "",
    "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.p_id = 203"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course ID 103?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 103"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor with ID 165?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id WHERE t.p_id = 165"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 40?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 40"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by person with id 107?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 107"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors with more than 5 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram >= 5"
  },
  {
    "db_id": "computer_student",
    "question": "What course has the course level Level_500?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Who are the students who have been advised by professors in Level_500 courses?",
    "evidence": "",
    "SQL": "SELECT p.student FROM person p JOIN advisedBy ab ON p.p_id = ab.p_id JOIN taughtBy tb ON ab.p_id_dummy = tb.p_id JOIN course c ON tb.course_id = c.course_id WHERE c.courseLevel = 'Level_500' AND p.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with at least 5 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, person, taughtBy WHERE person.p_id = taughtBy.p_id AND person.yearsInProgram >= 5 AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has professor with p_id 235 taught?",
    "evidence": "",
    "SQL": "SELECT * FROM taughtBy WHERE p_id = 235"
  },
  {
    "db_id": "computer_student",
    "question": "What course is being taught by the professor with ID 52?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the person with professor_id 324?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE taughtBy.p_id = 324 AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What level of course is course ID 97?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor who teaches Level 500 courses?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy AS tb JOIN course ON tb.course_id = course.course_id WHERE course.courseLevel = 'Level_500' AND tb.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course number 103?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 103"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses were taught by the professor with ID 297?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy, course WHERE taughtBy.p_id = course.course_id AND taughtBy.p_id = 297"
  },
  {
    "db_id": "computer_student",
    "question": "What course has a level of Level_400?",
    "evidence": "",
    "SQL": "SELECT * FROM course WHERE courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 41?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 41"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 134?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 134"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with p_id 235?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 235"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught which courses?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel, c.course_id, p.professor, p.student, p.hasPosition, p.inPhase, p.yearsInProgram FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses taught by professors?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with p_id 201?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE taughtBy.p_id = 201 AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has taught by more than 20 courses?",
    "evidence": "",
    "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 (SELECT COUNT(*) FROM taughtBy WHERE taughtBy.p_id = person.p_id) > 20"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses that are taught by professors who have been in the program for more than 5 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = 'Year_5' AND p.student = 0 AND p.hasPosition = 0"
  },
  {
    "db_id": "computer_student",
    "question": "Which person has never taught a course?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE p_id NOT IN (SELECT p_id FROM taughtBy)"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor who has been in the program for more than one year?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram = 'Year_2' OR p.yearsInProgram = 'Year_3'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have had a position?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND person.hasPosition = '1' AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the professor who has advised by a student?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND person.student = 1 AND EXISTS (SELECT * FROM advisedBy WHERE advisedBy.p_id = person.p_id AND advisedBy.p_id_dummy IN (SELECT p_id FROM person WHERE student = 0))"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a student who has been in the program for 0 years?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy, course WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE yearsInProgram = '0') AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course level does course with id 44 belong to?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 44"
  },
  {
    "db_id": "computer_student",
    "question": "What course does professor 248 teach?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE p_id = 248"
  },
  {
    "db_id": "computer_student",
    "question": "What course does professor with id 1 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors who are in the Post_Generals phase of the program, with at least 7 years in the program?",
    "evidence": "",
    "SQL": "SELECT DISTINCT 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.inPhase = 'Post_Generals' AND person.yearsInProgram = 'Year_7'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with the id 170?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 170"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has Professor 165 taught?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 165"
  },
  {
    "db_id": "computer_student",
    "question": "What is the courseLevel for the course with course_id 154?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 154"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does professor with id 1 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor with professor_id 82?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 82"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the professor who has advised most students?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND person.p_id IN (SELECT p_id FROM person WHERE person.hasPosition = '1') ORDER BY (SELECT COUNT(*) FROM advisedBy WHERE advisedBy.p_id = person.p_id) DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors with less than 1 year in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c INNER JOIN taughtBy tb ON c.course_id = tb.course_id INNER JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram < '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with p_id = 179?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 179"
  },
  {
    "db_id": "computer_student",
    "question": "What level of course did the student who was in his first year of program take?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.student AND person.yearsInProgram = 'Year_1'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor who advised the person with ID 348?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy t, person p WHERE t.p_id = p.p_id AND p.p_id = 348 AND c.course_id = t.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor 364?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 364"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors who have advised at least one student?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.student = 1 GROUP BY c.course_id, c.courseLevel HAVING COUNT(p.student) > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 120?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 120"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by a professor who has been a faculty member for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.hasPosition = 'Faculty' AND p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by person with p_id 40?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = 40"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is the professor with ID 5 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 5"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor 351?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 351"
  },
  {
    "db_id": "computer_student",
    "question": "What course is being taught by the person with p_id 394?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy INNER JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors having more than 0 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "Who are the professors that teach Level_400 courses?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM person p INNER JOIN taughtBy t ON p.p_id = t.p_id WHERE t.course_id IN (SELECT course_id FROM course WHERE courseLevel='Level_400') AND p.student=0"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the course with ID 49?",
    "evidence": "",
    "SQL": "SELECT person.professor FROM person, taughtBy WHERE taughtBy.course_id = 49 AND taughtBy.p_id = person.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the professor who is also a student in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = '0' AND p.inPhase = '0'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor 231?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id WHERE p_id = 231"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor who has taught for more than 6 years?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN person ON taughtBy.p_id = person.p_id JOIN course ON taughtBy.course_id = course.course_id WHERE person.yearsInProgram > 'Year_6'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has been taught by professor with ID 1?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor?",
    "evidence": "",
    "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.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What level is course 11?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 11"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor with more than 10 years of experience?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, person, taughtBy WHERE taughtBy.p_id = person.p_id AND person.yearsInProgram > 10"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with id 144?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 144"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses that Professor 335 is teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 335"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor 1?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which professor advises a student with p_id 342?",
    "evidence": "",
    "SQL": "SELECT professor FROM person WHERE p_id = 342 AND hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 115?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 115"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a professor who has a position?",
    "evidence": "",
    "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.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the ID of a course with 'Level_500'?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is person '36' teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE p_id = '36') "
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been in the program for less than 5 years?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.student = 0 AND p.yearsInProgram = 'Year_1' OR p.yearsInProgram = 'Year_2' OR p.yearsInProgram = 'Year_3'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the person with professor_id 324?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 324"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors have taught courses with a level of 'Level_500'?",
    "evidence": "",
    "SQL": "SELECT p.p_id FROM person p INNER JOIN taughtBy t ON p.p_id = t.p_id WHERE t.course_id IN (SELECT course_id FROM course WHERE courseLevel = 'Level_500') AND p.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professor with ID 64?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 64"
  },
  {
    "db_id": "computer_student",
    "question": "Who is the professor of the Level_500 course?",
    "evidence": "",
    "SQL": "SELECT person.professor FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 150?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 150"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the course that is taught by a professor with the ID 235?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 235"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 80?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 80"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is Professor 240 teaching?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy tb WHERE tb.p_id = 240 AND c.course_id = tb.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses that Professor [Some Professor's Name] taught?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c INNER JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has a Level_500 course?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = 0 AND course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors teach courses on Level_400?",
    "evidence": "",
    "SQL": "SELECT p.professor AS professor FROM person p JOIN taughtBy t ON p.p_id = t.p_id JOIN course c ON t.course_id = c.course_id WHERE c.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who are in their third year of the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN person p ON tb.p_id = p.p_id JOIN course c ON tb.course_id = c.course_id WHERE p.inPhase='Post_Quals' AND p.yearsInProgram='Year_3' ORDER BY c.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by professor 75?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 75"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does professor with ID 1 teach?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id WHERE tb.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by professor 79?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE taughtBy.p_id = 79 AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor 1 teaching?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id WHERE p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a professor who has not been in the program for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy AS t JOIN person AS p ON t.p_id = p.p_id JOIN course AS c ON t.course_id = c.course_id WHERE p.yearsInProgram = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy, course WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1) AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course level is course 18?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = '18'"
  },
  {
    "db_id": "computer_student",
    "question": "Which students are in Phase 0?",
    "evidence": "",
    "SQL": "SELECT student FROM person WHERE inPhase = '0'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a specific professor?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course does professor with ID 180 teach?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 180"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses that are not taught by any professor?",
    "evidence": "",
    "SQL": "SELECT * FROM course WHERE course_id NOT IN (SELECT course_id FROM taughtBy)"
  },
  {
    "db_id": "computer_student",
    "question": "What course has Professor [Professor] who teaches the course [Course Level]?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.professor = '0' AND c.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors with at least 5 years of experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram >= 'Year_5' GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor 104 teaching?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy AS t JOIN course AS c ON t.course_id = c.course_id WHERE t.p_id = 104"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught course 150?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 150"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 146?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 146"
  },
  {
    "db_id": "computer_student",
    "question": "Who are all the students in the Year_4 phase of the program?",
    "evidence": "",
    "SQL": "SELECT p.student FROM person p WHERE p.yearsInProgram = 'Year_4' AND p.inPhase = 'Post_Generals' AND p.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by the professor with id 107?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE p_id = 107"
  },
  {
    "db_id": "computer_student",
    "question": "What course has Level_500?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course WHERE course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by a professor who has a position?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND person.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses have been taught by professors who have advised at least one student?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND person.professor = 1 AND person.p_id IN (SELECT p_id FROM advisedBy GROUP BY p_id HAVING COUNT(*) > 0)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors with more than 4 years in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 'Year_4'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy, course WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches the 'Level_500' course?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy INNER JOIN course ON taughtBy.course_id = course.course_id WHERE course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses has a professor advised a student?",
    "evidence": "",
    "SQL": "SELECT C.course_id, C.courseLevel FROM course C JOIN taughtBy T ON C.course_id = T.course_id JOIN advisedBy A ON T.p_id = A.p_id_dummy GROUP BY C.course_id, C.courseLevel HAVING COUNT(A.p_id) > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the professor who teaches the Level_500 course?",
    "evidence": "",
    "SQL": "SELECT person.professor FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND course.courseLevel = 'Level_500' LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors are not teaching any course?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND p_id NOT IN (SELECT p_id FROM taughtBy)"
  },
  {
    "db_id": "computer_student",
    "question": "Who is teaching course with course ID 20?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 20"
  },
  {
    "db_id": "computer_student",
    "question": "What level of course is taught by the professor with ID 240?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course, taughtBy WHERE taughtBy.p_id = (SELECT p_id FROM person WHERE p_id = 240) AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 5?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id = 5 AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course does professor 235 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 235"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by professor with ID 298?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 298"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by a professor with more than 0 years in the program?",
    "evidence": "",
    "SQL": "SELECT * FROM course, taughtBy WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE yearsInProgram > 0) AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What level courses are taught by a professor who has been in the program for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors with at least 3 years of experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram >= 3 GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors have taught Level_500 courses?",
    "evidence": "",
    "SQL": "SELECT p.p_id FROM person p JOIN taughtBy t ON p.p_id = t.p_id JOIN course c ON t.course_id = c.course_id WHERE c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course with course_id 128?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 128"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors with more than 5 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 'Year_5' AND p.hasPosition = 'Professor'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 74?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 74"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with id 98?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 98"
  },
  {
    "db_id": "computer_student",
    "question": "Who are the people who have taught 'Level_500' course?",
    "evidence": "",
    "SQL": "SELECT p.student, p.professor FROM person p JOIN taughtBy tb ON p.p_id = tb.p_id WHERE tb.course_id = 169"
  },
  {
    "db_id": "computer_student",
    "question": "Which level of course does the professor with id 351 teach?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 351"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a faculty member with more than 2 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram > 2"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by professor 166?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy WHERE p_id=(SELECT p_id FROM person WHERE p_id=166))"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors have taught 'Level_500' courses?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE p_id IN (SELECT p_id FROM taughtBy WHERE course_id IN (SELECT course_id FROM course WHERE courseLevel = 'Level_500'))"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have been in the program for more than 2 years?",
    "evidence": "",
    "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.yearsInProgram LIKE 'Year_%' AND person.yearsInProgram LIKE '%2' ORDER BY course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor 351 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id = 351 AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has a person with id 96 taught?",
    "evidence": "",
    "SQL": "SELECT * FROM taughtBy WHERE p_id = 96"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1) "
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the person with the ID 248?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE taughtBy.p_id = 248 and course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course has a level of Level_500?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel='Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by the professor who advised the student with p_id 155?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.p_id = 155"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is level 500?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course WHERE course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor '201'?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy, course WHERE taughtBy.p_id = 201 AND taughtBy.course_id = course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have a certain level of expertise?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.hasPosition = '1' AND c.courseLevel LIKE '%Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Which level of course was taught by a professor?",
    "evidence": "",
    "SQL": "SELECT DISTINCT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been in the program for more than 0 years?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "Which students have had a professor who has taught a course at Level 500?",
    "evidence": "",
    "SQL": "SELECT p.student AS 'Student' FROM person p JOIN taughtBy t ON p.p_id = t.p_id JOIN course c ON t.course_id = c.course_id WHERE c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught the Level_500 course?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy, course WHERE course.courseLevel = 'Level_500' AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 36?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 36"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor 331?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 331"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by the professor?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a person with a professor status?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c INNER JOIN taughtBy t ON c.course_id = t.course_id INNER JOIN person p ON t.p_id = p.p_id WHERE p.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has at least 3 years in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram >= 'Year_3' GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught course with ID 84?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 84"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by the professor with id 211?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy tb WHERE tb.p_id = 211 AND c.course_id = tb.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which students has a professor with the course ID of 7?",
    "evidence": "",
    "SQL": "SELECT p.student FROM person p JOIN advisedBy ab ON p.p_id = ab.p_id_dummy JOIN person p_teacher ON ab.p_id = p_teacher.p_id JOIN taughtBy tb ON p_teacher.p_id = tb.p_id AND tb.course_id = 7"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors with more than 10 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram > 'Year_10'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 103?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 103"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 79?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 79"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course 101?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = '101'"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses that were taught by the professor?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id WHERE tb.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who are students themselves?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has been taught by a professor who has been in the program for more than 5 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 'Year_5'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 97?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 97"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a person who is not a professor?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, course.course_id FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND NOT EXISTS (SELECT 1 FROM person WHERE person.p_id = taughtBy.p_id AND person.professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id WHERE t.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor 104?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 104"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by the professor with ID 213?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.p_id = 213"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches a course at the Level_400?",
    "evidence": "",
    "SQL": "SELECT c.course_id, p.p_id, p.professor FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE c.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has been taught by a professor?",
    "evidence": "",
    "SQL": "SELECT c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id IN (SELECT p.p_id FROM person p WHERE p.professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by faculty members who have less than 1 year in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram < '1' AND p.hasPosition = 'Faculty'"
  },
  {
    "db_id": "computer_student",
    "question": "Who is teaching the course with id 165?",
    "evidence": "",
    "SQL": "SELECT person.professor FROM taughtBy JOIN person ON taughtBy.p_id = person.p_id WHERE taughtBy.course_id = 165"
  },
  {
    "db_id": "computer_student",
    "question": "Which students are advised by Faculty members who teach a Level_400 course?",
    "evidence": "",
    "SQL": "SELECT p.student FROM person p JOIN advisedBy ab ON p.p_id = ab.p_id JOIN taughtBy tb ON ab.p_id_dummy = tb.p_id JOIN course c ON tb.course_id = c.course_id WHERE c.courseLevel = 'Level_400' AND p.student = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with the p_id 234?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id = 234"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches a course of level Level_400?",
    "evidence": "",
    "SQL": "SELECT p.student, p.p_id FROM taughtBy tb JOIN person p ON tb.p_id = p.p_id JOIN course c ON tb.course_id = c.course_id WHERE c.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses have been taught by a professor who has at least 7 years of experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.yearsInProgram >= 'Year_7' ORDER BY c.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches the course with the ID 143?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE c.course_id = 143"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses were taught by professors who have positions?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have been in the program for more than 4 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram LIKE '%Year_%' AND p.p_id IN (SELECT p_id FROM person WHERE yearsInProgram LIKE '%Year_4' OR yearsInProgram LIKE '%Year_5' OR yearsInProgram LIKE '%Year_6' OR yearsInProgram LIKE '%Year_7' OR yearsInProgram LIKE '%Year_8' OR yearsInProgram LIKE '%Year_9' OR yearsInProgram LIKE '%Year_10')"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor with ID 394 teaching?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, course.course_id FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have been teaching in the program for more than four years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy tb, person p WHERE p.yearsInProgram > 'Year_4' AND p.p_id = tb.p_id AND c.course_id = tb.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by Professor P?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by Professor 1?",
    "evidence": "",
    "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.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with ID 248?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.p_id = 248"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by Professor 165?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE taughtBy.p_id = 165 AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course taught by professor '1'?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which level of course has been taught by a professor?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors with a position?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition != 0"
  },
  {
    "db_id": "computer_student",
    "question": "What course has Professor with ID 279 as a instructor?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 279"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses have a professor who has taught in the Post Quals phase?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel, p.hasPosition, p.inPhase FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = 1 AND p.inPhase = 'Post_Quals'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the course that is taught by professor ID 104?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 104"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with course id 172?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 172"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with at least 4 years in the program?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id, c.courseLevel FROM taughtBy t JOIN person p ON t.p_id = p.p_id JOIN course c ON t.course_id = c.course_id WHERE p.yearsInProgram > 'Year_3'"
  },
  {
    "db_id": "computer_student",
    "question": "Which professor teaches course_id 27?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM taughtBy t JOIN person p ON t.p_id = p.p_id WHERE t.course_id = 27"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course with course ID 162?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 162"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with course_id equal to 5?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 5"
  },
  {
    "db_id": "computer_student",
    "question": "Which professors teach courses at the Level_500 level?",
    "evidence": "",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND exists (select * from taughtby tb where tb.p_id = person.p_id and tb.course_id in (select course_id from course where course.courseLevel = 'Level_500'))"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with course ID 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with ID 166?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 166"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has a courseLevel of 'Level_500'?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel='Level_500' AND EXISTS (SELECT 1 FROM taughtBy WHERE taughtBy.course_id=course.course_id AND taughtBy.p_id IN (SELECT p_id FROM person WHERE professor=1))"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor 331?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 331"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 101?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 101"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does a professor with ID 394 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy INNER JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "What course has courseLevel 'Level_300'?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel='Level_300'"
  },
  {
    "db_id": "computer_student",
    "question": "Who advises students in Level_500 courses?",
    "evidence": "",
    "SQL": "SELECT DISTINCT p.student FROM person p JOIN advisedBy ab ON p.p_id = ab.p_id_dummy JOIN course c ON ab.p_id = c.course_id WHERE c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does faculty member 1 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has a certain position and in a certain phase in their program?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE hasPosition = '0' AND inPhase = 'Post_Quals')"
  },
  {
    "db_id": "computer_student",
    "question": "Who has taught course 61?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 61"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the course that is taught by the person with ID 351?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 351"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a professor with id 319?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 319"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with ID 11?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 11"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor who teaches a course at Level_400?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = '0' AND course.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What level is the course 'course_id' with 'p_id' 364 teaching?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE p_id = 364"
  },
  {
    "db_id": "computer_student",
    "question": "What course does person 394 teach?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has the courseLevel Level_400?",
    "evidence": "",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is professor with ID 1 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses is Professor 9 teaching?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.course_id = course.course_id AND taughtBy.p_id = 9"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by the instructor with ID 79?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 79"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by a professor with at least 2 years in the program?",
    "evidence": "",
    "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.yearsInProgram >= 2"
  },
  {
    "db_id": "computer_student",
    "question": "What course has been taught by professor 351?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 351"
  },
  {
    "db_id": "computer_student",
    "question": "Which professor teaches a course that has the level of 'Level_400' and has also been advised by some other professor?",
    "evidence": "",
    "SQL": "SELECT p1.p_id AS professor_id FROM person AS p1 JOIN taughtBy AS tb ON p1.p_id = tb.p_id JOIN course AS c ON tb.course_id = c.course_id WHERE c.courseLevel = 'Level_400' AND p1.professor > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with course_id 40?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 40"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by Professor 370?",
    "evidence": "",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 370"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with ID 150?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN course c ON t.course_id = c.course_id WHERE t.p_id = 150"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professor with p_id 107?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND person.p_id = 107"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by the professor with ID 342?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 342"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course taught by person with id 394?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "Who teaches course 7?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy WHERE course_id = 7"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor who is at Year_5 of their program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = 'Year_5'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has Professor X taught?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with id 116?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 116"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a person who is a professor?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE person.p_id = taughtBy.p_id AND person.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course has Level_400?",
    "evidence": "",
    "SQL": "SELECT course_id, courseLevel FROM course WHERE courseLevel='Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors with more than 5 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 'Year_5'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course taught by professor with ID 351?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 351"
  },
  {
    "db_id": "computer_student",
    "question": "What courses have been taught by Professor X?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE person.p_id = taughtBy.p_id AND course.course_id = taughtBy.course_id AND person.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with course_id 71?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 71"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have not held any positions?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c, taughtBy t, person p WHERE t.p_id = p.p_id AND p.hasPosition = '0'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by Professor with ID 189?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id WHERE tb.p_id = 189"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been in the program for more than 7 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy AS tb INNER JOIN course AS c ON tb.course_id = c.course_id INNER JOIN person AS p ON tb.p_id = p.p_id WHERE p.yearsInProgram > 'Year_7' GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a professor?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course taught by a professor with the most courses taught?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN (SELECT p_id, COUNT(*) AS count FROM taughtBy GROUP BY p_id ORDER BY count DESC LIMIT 1) AS most_teaching_prof ON taughtBy.p_id = most_teaching_prof.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which course was taught by the professor who has been in the program for the most years?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = (SELECT MAX(yearsInProgram) FROM person) AND p.professor = 1"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 240?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 240"
  },
  {
    "db_id": "computer_student",
    "question": "Who are the instructors for Level_500 courses?",
    "evidence": "",
    "SQL": "SELECT person.p_id, person.professor, course.courseLevel FROM course, person, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = person.p_id AND course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "Who has taught Level_500 course?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the highest level course taught by professor 342?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 342 ORDER BY courseLevel DESC LIMIT 1"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with ID 156?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 156"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id WHERE t.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by a student in their fourth year?",
    "evidence": "",
    "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.yearsInProgram = 'Year_4'"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 335?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 335"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses taught by a professor who has a position?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c INNER JOIN taughtBy t ON c.course_id = t.course_id INNER JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has been in the program for more than 2 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 2 GROUP BY c.course_id, c.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does a student who has been in a program for 3 years, has no professor assigned and is not in post-quals phase advise?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.student = 1 AND p.yearsInProgram = 'Year_3' AND p.hasPosition = 0 AND p.inPhase != 'Post_Quals' GROUP BY c.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of course with course_id 135?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 135"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 125?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 125"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have advised at least one student?",
    "evidence": "",
    "SQL": "SELECT DISTINCT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.student = 1 AND p.p_id IN (SELECT a.p_id FROM advisedBy a GROUP BY a.p_id HAVING COUNT(a.p_id_dummy) > 0)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor who has a course level of Level_300?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.hasPosition = 'Faculty' AND c.courseLevel = 'Level_300'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses were taught by a professor with more than 5 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy t JOIN person p ON t.p_id = p.p_id JOIN course c ON t.course_id = c.course_id WHERE p.yearsInProgram > 5"
  },
  {
    "db_id": "computer_student",
    "question": "Which students in the course 'Level_500' are taught by a professor?",
    "evidence": "",
    "SQL": "SELECT person.p_id FROM person, taughtBy, course WHERE person.student = 1 AND person.hasPosition = 0 AND course.course_id = taughtBy.course_id AND course.courseLevel = 'Level_500' AND taughtBy.p_id = person.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by Professor 394?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy tb ON c.course_id = tb.course_id WHERE tb.p_id = 394"
  },
  {
    "db_id": "computer_student",
    "question": "Who is the professor of course 71?",
    "evidence": "",
    "SQL": "SELECT person.p_id, person.professor FROM person, taughtBy WHERE taughtBy.course_id = 71 AND taughtBy.p_id = person.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a person who has a position?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM taughtBy tb JOIN course c ON tb.course_id = c.course_id JOIN person p ON tb.p_id = p.p_id WHERE p.hasPosition = '1'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with the course ID 32?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 32"
  },
  {
    "db_id": "computer_student",
    "question": "What courses have been taught by a faculty member who has more than 0 years in program?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c INNER JOIN taughtBy t ON c.course_id = t.course_id INNER JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with more than 10 years in the program?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 'Year_10'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of the course with ID 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors with at least 5 years of experience?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c, taughtBy tb, person p WHERE p.inPhase = 'Post_Quals' AND p.yearsInProgram >= 'Year_5' AND c.course_id = tb.course_id AND p.p_id = tb.p_id"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses taught by professors who have been advising students for more than 3 years?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.inPhase > 3 AND p.hasPosition = 'Faculty'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professor with ID 342?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 342"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a person with a level of 'Level_500'?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM taughtBy t JOIN course c ON t.course_id = c.course_id JOIN person p ON t.p_id = p.p_id WHERE c.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the name of the course that a person with id 324 taught?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 324"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with id 375?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 375"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor with at least 5 years in program?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram >= 'Year_6'"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses that are taught by a professor who has a position as 'Faculty'?",
    "evidence": "",
    "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.hasPosition = 'Faculty'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of course 114?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 114"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level for course 19?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 19"
  },
  {
    "db_id": "computer_student",
    "question": "Who is teaching the course with id 61?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM taughtBy tb JOIN person p ON tb.p_id = p.p_id WHERE tb.course_id = 61"
  },
  {
    "db_id": "computer_student",
    "question": "Which course has been taught by a professor with 0 years in program?",
    "evidence": "",
    "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.yearsInProgram = '0'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by the professors with more than 5 years of experience in the program?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE person.yearsInProgram >= 5 AND person.p_id = taughtBy.p_id AND course.course_id = taughtBy.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "What are all the courses taught by the professor who has taught 'Level_500'?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM taughtBy JOIN person ON taughtBy.p_id = person.p_id JOIN course ON taughtBy.course_id = course.course_id WHERE person.hasPosition = '1' AND course.courseLevel = 'Level_500'"
  },
  {
    "db_id": "computer_student",
    "question": "What is the courseLevel of course with id 21?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 21"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 141?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 141"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor 213?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel, course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 213"
  },
  {
    "db_id": "computer_student",
    "question": "What level is a course taught by a person with p_id 211?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 211"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by a professor with 0 years in program?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id JOIN person ON taughtBy.p_id = person.p_id WHERE person.yearsInProgram = 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with id 158?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 158"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by the professor with the ID 171?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 171"
  },
  {
    "db_id": "computer_student",
    "question": "Which professor teaches a course with a Level_400?",
    "evidence": "",
    "SQL": "SELECT p.professor FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE c.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses have been taught by Professor 1?",
    "evidence": "",
    "SQL": "SELECT course.course_id FROM taughtBy JOIN course ON taughtBy.course_id = course.course_id WHERE taughtBy.p_id = 1"
  },
  {
    "db_id": "computer_student",
    "question": "Which level course is taught by a professor?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id IN (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses does Professor 1 teach?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = (SELECT p_id FROM person WHERE professor = 1)"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by a professor having yearsInProgram='Year_4'?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram = 'Year_4'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been advising students for more than 0 years?",
    "evidence": "",
    "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.hasPosition = 0 AND person.yearsInProgram > 0"
  },
  {
    "db_id": "computer_student",
    "question": "What is the course level of the course with the course id 148?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 148"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by a professor with ID 331?",
    "evidence": "",
    "SQL": "SELECT * FROM course, taughtBy WHERE course.course_id = taughtBy.course_id AND taughtBy.p_id = 331"
  },
  {
    "db_id": "computer_student",
    "question": "Who are the professors who taught a course of level Level_400?",
    "evidence": "",
    "SQL": "SELECT DISTINCT p.student, p.p_id, c.courseLevel, c.course_id, t.p_id AS prof_id FROM person p JOIN taughtBy t ON p.p_id = t.p_id JOIN course c ON t.course_id = c.course_id WHERE c.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have been a student themselves?",
    "evidence": "",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c INNER JOIN taughtBy tb ON c.course_id = tb.course_id INNER JOIN person p ON tb.p_id = p.p_id WHERE p.student = 1 AND p.hasPosition = '0'"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses are taught by professors who have less than 2 years of experience?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE person.yearsInProgram='Year_1' AND person.p_id=taughtBy.p_id AND taughtBy.course_id=course.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Who taught course level 400?",
    "evidence": "",
    "SQL": "SELECT p_id FROM taughtBy, course WHERE course.course_id = taughtBy.course_id AND course.courseLevel = 'Level_400'"
  },
  {
    "db_id": "computer_student",
    "question": "What are the courses taught by the person with id 72?",
    "evidence": "",
    "SQL": "SELECT course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 72"
  },
  {
    "db_id": "computer_student",
    "question": "Which courses have at least one student registered?",
    "evidence": "",
    "SQL": "SELECT c.course_id FROM course c LEFT JOIN taughtBy t ON c.course_id = t.course_id LEFT JOIN person p ON t.p_id = p.p_id WHERE p.student > 0 GROUP BY c.course_id"
  },
  {
    "db_id": "computer_student",
    "question": "Which course is taught by professor 298?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 298"
  },
  {
    "db_id": "computer_student",
    "question": "What courses are taught by professors who have a Level_500 course?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.hasPosition = 0 AND course.courseLevel = 'Level_500' GROUP BY course.course_id, course.courseLevel"
  },
  {
    "db_id": "computer_student",
    "question": "What is the level of a course with id 101?",
    "evidence": "",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 101"
  },
  {
    "db_id": "computer_student",
    "question": "What course is taught by professor with id 375?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course, taughtBy, person WHERE taughtBy.p_id = person.p_id AND taughtBy.course_id = course.course_id AND person.p_id = 375"
  },
  {
    "db_id": "computer_student",
    "question": "What courses has professor 107 taught?",
    "evidence": "",
    "SQL": "SELECT course.course_id, course.courseLevel FROM course INNER JOIN taughtBy ON course.course_id = taughtBy.course_id WHERE taughtBy.p_id = 107"
  }
]