[
  {
    "question": "What courses are taught by professor John Doe?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'professor' AND T3.yearsInProgram = '5'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the database?",
    "SQL": "SELECT COUNT(course_id) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors have advised students?",
    "SQL": "SELECT T2.p_id, T1.professor FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level has the most courses?",
    "SQL": "SELECT courseLevel FROM course GROUP BY courseLevel ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position in the phase?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.inPhase = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors taught by person with p_id 123?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.student = 0 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the different levels of courses available in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram = 'More than 5 years'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the advanced level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'advanced'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with position 'Prof'?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.hasPosition = 'Prof'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the unique course levels offered in the course table?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has a professor as a teacher?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are offered at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the students advised by the professor with id 1?",
    "SQL": "SELECT T2.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has a position and is in phase 3?",
    "SQL": "SELECT * FROM person WHERE hasPosition = 'Yes' AND inPhase = '3'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of courses taught by a person with professor position?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'Professor' AND T3.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who are in phase 'PhD'?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.inPhase = 'PhD'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the database?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has been taught by the person with ID 1?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the ' undergraduate' level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in each level?",
    "SQL": "SELECT COUNT(course_id), courseLevel FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the 'Graduate' level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than 2 professors teaching them?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id IN (SELECT T3.p_id FROM person AS T3 INNER JOIN taughtBy AS T4 ON T3.p_id = T4.p_id GROUP BY T3.p_id HAVING COUNT(T4.course_id) > 2)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the courses that are taught by a professor with a specific ID?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.yearsInProgram > '5' AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which of the following courses does person with id 4 teach?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 4",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there?",
    "SQL": "SELECT COUNT(course_id) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest courseLevel?",
    "SQL": "SELECT course_id, courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most courses?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.p_id ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has been taught by a professor?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by each professor?",
    "SQL": "SELECT COUNT(course_id), p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than 2 students?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id HAVING COUNT(T2.p_id) > 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors in the database?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.student = 0 AND T3.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with ID 123?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is both a professor and a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with p_id 5?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position of 'Researcher'?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1 AND T1.hasPosition = 'Researcher'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor X?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 'X'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has advised a student?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels taught by a specific professor with p_id 123?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years of experience in the program?",
    "SQL": "SELECT T2.course_id, T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.hasPosition = 'professor' AND T1.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with positions in the current phase?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.inPhase = 'current'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the 'Graduate' level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years of experience in the program?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.student = 0 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the total number of students?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student=1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the people in the program who are not professors?",
    "SQL": "SELECT p_id FROM person WHERE NOT professor",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with ID 5?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses does person with p_id 1 teach?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "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",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T1.yearsInProgram > '10'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the advanced level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'advanced'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has a position in the program?",
    "SQL": "SELECT * FROM person WHERE hasPosition = 'true'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level does 'CS101' belong to?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1 AND T2.course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are teaching the most courses?",
    "SQL": "SELECT p_id, COUNT(course_id) AS num_courses FROM taughtBy GROUP BY p_id ORDER BY num_courses DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of people who have been advised by someone in the database?",
    "SQL": "SELECT COUNT(p_id) FROM advisedBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who are students themselves?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.student = 1 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) does professor 1 teach?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professors?",
    "SQL": "SELECT T1.p_id, T1.yearsInProgram FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id_dummy WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors with a position?",
    "SQL": "SELECT COUNT(T1.course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.hasPosition IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT DISTINCT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in each course level?",
    "SQL": "SELECT COUNT(course_id), courseLevel FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "SQL query to return all courses taught by professors in the person table.",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level of instruction?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT 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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id = 100?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 100",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the students advised by a specific professor?",
    "SQL": "SELECT T2.student FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are in the person table?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a tenure position?",
    "SQL": "SELECT T2.course_id, T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T2.course_id = T2.course_id INNER JOIN taughtBy AS T3 ON T1.p_id = T3.p_id WHERE T1.hasPosition = 'tenure'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by person with ID 1?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at each level?",
    "SQL": "SELECT T1.courseLevel, COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a specific professor?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT T1.hasPosition, COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.hasPosition",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID and the student's ID of the person in the person table?",
    "SQL": "SELECT p_id, student FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors in the program?",
    "SQL": "SELECT COUNT(DISTINCT T1.course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are enrolled in each course?",
    "SQL": "SELECT T1.course_id, COUNT(T2.student) FROM course AS T1 INNER JOIN person AS T2 ON T2.student = 1 GROUP BY T1.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level has the most students?",
    "SQL": "SELECT T2.courseLevel FROM advisedBy AS T1 INNER JOIN course AS T2 ON T2.course_id = T1.p_id WHERE T1.p_id IN ( SELECT p_id FROM person WHERE student = 1 ) GROUP BY T2.courseLevel ORDER BY COUNT(T2.courseLevel) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors in the course level 3?",
    "SQL": "SELECT COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T1.courseLevel = 3",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1 AND inPhase = 'yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors in the database?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by a professor with the position 'tenured'?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'tenured'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than one professor teaching them?",
    "SQL": "SELECT course_id FROM taughtBy GROUP BY course_id HAVING COUNT(p_id) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID who is also a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are taught by people with positions?",
    "SQL": "SELECT DISTINCT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T2.course_id = T2.course_id WHERE T1.hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are offered by the university?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 1?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with yearsInProgram greater than 10?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in phase?",
    "SQL": "SELECT course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.inPhase = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Select the number of courses in each level from the course table.",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has a professor position?",
    "SQL": "SELECT p_id FROM person WHERE hasPosition = 'professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses have more than two students?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id IN (SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T2.p_id HAVING COUNT(*) > 2)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of courses taught by each person?",
    "SQL": "SELECT AVG(course_id), p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at each course level?",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the courseLevel of the course with course_id 1 ?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is taught by person with id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are offered at each level?",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of students in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course AS c JOIN taughtBy AS tb ON c.course_id = tb.course_id JOIN person AS p ON tb.p_id = p.p_id WHERE p.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has a courseLevel of 'Graduate'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position?",
    "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 p.hasPosition IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > '5' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the levels of courses taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.student = 0 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the undergraduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND inPhase = 'current'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 1?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 10 years?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.student = 0 AND T3.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are there in the person table?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the different levels of courses in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT DISTINCT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level has the most students enrolled?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.student = 1 WHERE T1.hasPosition LIKE '%student%' GROUP BY T2.courseLevel ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the number of students who are professors",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at each course level?",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are currently working in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND hasPosition = 'yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'Yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with at least 5 years of experience in the program?",
    "SQL": "SELECT DISTINCT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 0 AND T1.yearsInProgram >= 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by Professor A?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.p_id = ( SELECT p_id FROM person WHERE professor = 1 LIMIT 1 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor has advised the most number of students?",
    "SQL": "SELECT T2.p_id, COUNT(T1.p_id) AS student_count FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.professor = 1 GROUP BY T2.p_id ORDER BY student_count DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the students that are advised by someone with more than 5 years of yearsInProgram?",
    "SQL": "SELECT T2.student FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T1.p_id_dummy = T3.p_id WHERE T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with the hasPosition 'Professor'?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who teaches the most courses?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id GROUP BY T2.professor ORDER BY COUNT(T1.course_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the number of courses taught by each professor?",
    "SQL": "SELECT COUNT(T2.p_id) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with a specific hasPosition value?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.hasPosition = 'your_position_value'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of each course taught by Professor John?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with a specific yearsInProgram?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram = 'specific_yearsInProgram'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the SQL query to find the number of students and professors in the person table?",
    "SQL": "SELECT COUNT(student) AS student_count, COUNT(professor) AS professor_count FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1 AND inPhase = 'active'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest course level in the database?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are offered at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the undergraduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course ID 123?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which of the following is not a position that a person can have in the program?",
    "SQL": "SELECT DISTINCT hasPosition FROM person WHERE hasPosition NOT IN ('Professor', 'Student') LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all the courses and their corresponding professors",
    "SQL": "SELECT T1.course_id, T1.courseLevel, T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the advanced level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Advanced'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.student = 0 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level does the course with course_id 1 have?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are being taught by a person who has both a professor and a student position?",
    "SQL": "SELECT DISTINCT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all courses that have at least one student enrolled.",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = ( SELECT p_id FROM person WHERE student = 1 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the relationship between the person and the person advised by",
    "SQL": "SELECT T1.p_id, T1.p_id_dummy FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a specific professor?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id = (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id, T1.yearsInProgram FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the possible course levels?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 5?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are all the students advised by Professor X?",
    "SQL": "SELECT T2.p_id_dummy FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the courses taught by a professor with a specific position?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = 'specificPosition'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with positions?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the course table?",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each person?",
    "SQL": "SELECT COUNT(*) FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than one professor assigned to them?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id AND T1.p_id <> T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM person AS P1 INNER JOIN taughtBy AS T1 ON P1.p_id = T1.p_id INNER JOIN course AS C1 ON T1.course_id = C1.course_id WHERE P1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses does professor with ID 51 teach?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 51",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what are the distinct course levels in the course table?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with ID 5?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 5?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with p_id 123?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by a specific professor?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors in the current phase of the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.student = 0 AND T3.inPhase = 'current'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor with ID 5?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T1.p_id = T3.p_id WHERE T3.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is associated with the course_id 2?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a courseLevel of 'Graduate'?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are enrolled in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with the ID 123?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors in the 'taughtBy' table?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the 'Undergraduate' level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently advised by a professor?",
    "SQL": "SELECT COUNT(T2.p_id) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T2.p_id = T1.p_id WHERE T2.student = 1 AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > '10'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "SQLite query that returns the number of courses in the 'course' table",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with a position as a senior faculty?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'senior faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what are all the courses taught by professor X?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the students who have advisors?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the undergraduate level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has advised at least one student?",
    "SQL": "SELECT DISTINCT p_id FROM advisedBy WHERE p_id IN (SELECT p_id FROM person WHERE student = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years of experience in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 5?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND hasPosition = 'Student'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 123?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level has the highest number of courses?",
    "SQL": "SELECT courseLevel FROM course GROUP BY courseLevel ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches which courses?",
    "SQL": "SELECT T2.p_id, T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the highest level course?",
    "SQL": "SELECT T1.p_id, T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T3.courseLevel = ( SELECT MAX(courseLevel) FROM course )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are enrolled in each course level?",
    "SQL": "SELECT T1.courseLevel, COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.student = 1 GROUP BY T1.courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years of experience in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years of experience?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors in the person table?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have more than 2 students enrolled?",
    "SQL": "SELECT COUNT(*) FROM course WHERE course_id IN (SELECT course_id FROM taughtBy GROUP BY course_id HAVING COUNT(*) > 2)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors who have been in the program for over 5 years?",
    "SQL": "SELECT COUNT(DISTINCT T1.course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram > 5 AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the number of courses taught by professors who are not students.",
    "SQL": "SELECT COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with the position 'Professor'?",
    "SQL": "SELECT DISTINCT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = 'Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that is taught by person with id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the 'course' table?",
    "SQL": "SELECT COUNT(course_id) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by a person with a specific professor?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses does person with p_id 1 teach?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors in the course level of 'Senior'?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.courseLevel = 'Senior' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a professor as the teacher?",
    "SQL": "SELECT COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course and the professor teaching it?",
    "SQL": "SELECT T2.course_id, T1.professor FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "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 > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with id 1?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students have been advised by professors?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id_dummy WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with the highest courseLevel?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the SQL query to find the number of professors in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by at least one professor?",
    "SQL": "SELECT COUNT(course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of a course taught by Professor John Doe?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id INNER JOIN taughtBy AS T3 ON T3.p_id = T1.p_id WHERE T1.professor = 1 AND T1.hasPosition LIKE '%John Doe%'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > '5'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'current'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is a professor and has been in the program for 5 years?",
    "SQL": "SELECT T1.p_id FROM person AS T1 WHERE T1.professor = 1 AND T1.yearsInProgram = '5 years'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of years a person has been in the program?",
    "SQL": "SELECT AVG(yearsInProgram) FROM person",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT DISTINCT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) is/are taught by the professor with id 2?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.p_id = 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than 10 students enrolled?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T2.course_id HAVING COUNT(*) > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position in the program?",
    "SQL": "SELECT T2.course_id, T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.hasPosition = 'Yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of course 2?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'professor' AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of courses at the 'beginner' level?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'beginner'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the name of the courses that have been taught by professor with id 10?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 123?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are enrolled in the university?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) are taught by professors with a position of 'FullProfessor'?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'FullProfessor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by which professors?",
    "SQL": "SELECT T1.p_id, T2.p_id_dummy FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T2.p_id_dummy = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(DISTINCT T2.course_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor ID 2?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by a specific person?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Select the course level of the course with course_id = 1",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the program?",
    "SQL": "SELECT T1.course_id, T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a specific professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(T2.course_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by Professor Smith?",
    "SQL": "SELECT T1.course_id, T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'Professor Smith'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with positions?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.hasPosition IS NOT NULL AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by Professor Smith?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the 'inPhase' field?",
    "SQL": "SELECT T1.course_id, T2.hasPosition FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.inPhase = 'inPhase' AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professors in the program?",
    "SQL": "SELECT COUNT(T2.course_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level has the highest number of courses?",
    "SQL": "SELECT courseLevel FROM course GROUP BY courseLevel ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the person table?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'In Program'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(DISTINCT T2.course_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level and how many students are teaching it?",
    "SQL": "SELECT T1.courseLevel, COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.courseLevel ORDER BY T1.courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Write a SQLite query that will count the number of people who are in the 'inPhase' column as 'Phase 3 students'",
    "SQL": "SELECT COUNT(*) FROM person WHERE inPhase = 'Phase 3 students'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors who have taught in at least one course?",
    "SQL": "SELECT DISTINCT T1.p_id, T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = 'professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor with the position 'Associate Professor'?",
    "SQL": "SELECT COUNT(T1.course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.hasPosition = 'Associate Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor with a position in the current phase?",
    "SQL": "SELECT COUNT(*) FROM person AS P1 INNER JOIN taughtBy AS T ON P1.p_id = T.p_id INNER JOIN course AS C ON T.course_id = C.course_id WHERE P1.professor = 1 AND P1.inPhase = 'current'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by Professor Jane?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.student IS NULL AND T2.hasPosition = 'Professor' AND T2.yearsInProgram = '10'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are assigned to teach courses?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor X?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = (SELECT p_id FROM person WHERE professor = 1 AND yearsInProgram = 'X')",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students have been advised by a professor with more than 5 years in the program?",
    "SQL": "SELECT T2.p_id, T2.yearsInProgram FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most courses?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id GROUP BY T2.professor ORDER BY COUNT(T1.course_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels of all courses?",
    "SQL": "SELECT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the courseLevel of the course taught by person p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by each professor?",
    "SQL": "SELECT T1.course_id, T2.hasPosition FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with a position in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'inProgram' AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are taught by at least two professors?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 GROUP BY T1.courseLevel HAVING COUNT(T1.course_id) >= 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches which courses?",
    "SQL": "SELECT T1.course_id, T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the database?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors who have been in the program for at least 5 years?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 0 AND T2.yearsInProgram >= 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'Yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors who have a position?",
    "SQL": "SELECT COUNT(DISTINCT course_id) FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE hasPosition IS NOT NULL)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with course_id 3?",
    "SQL": "SELECT course_id FROM course WHERE course_id = 3",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at each level?",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years of experience in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.student = 0 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'professor' AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels of courses that are taught by professors?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T2.course_id = T3.course_id INNER JOIN taughtBy AS T3 ON T1.p_id = T3.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the number of courses taught by professors in the taughtBy and person tables?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE yearsInProgram > 5 AND professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) does Professor X teach?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Write a query to find the number of courses at the graduate level",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most number of courses?",
    "SQL": "SELECT T2.p_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id GROUP BY T1.p_id ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have a position?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who are both students and faculty members?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.student = 1 AND T2.hasPosition = 'faculty member'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has a course level of 'Graduate'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by professors?",
    "SQL": "SELECT COUNT(*) FROM person p1 JOIN advisedBy a ON p1.p_id = a.p_id WHERE p1.student = 1 AND p1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 10 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor X?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.inPhase = 'Phase1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c INNER JOIN taughtBy t ON c.course_id = t.course_id INNER JOIN person p ON t.p_id = p.p_id WHERE p.yearsInProgram > 5 AND p.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "who teaches which courses",
    "SQL": "SELECT T1.p_id, T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the levels of courses taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND hasPosition LIKE '%professor%'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in each level?",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by a person who has been in the program for more than 5 years?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course that has the highest courseLevel?",
    "SQL": "SELECT course_id, courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in each course level?",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors teach the most courses?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.p_id ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors in the system?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches which course and at what level?",
    "SQL": "SELECT T2.p_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person in the person table has a position as a professor?",
    "SQL": "SELECT * FROM person WHERE hasPosition = 'professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years of experience?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 10 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with the ID 123?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'current'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels in the course table?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by Professor Smith?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "who is a professor and has been in the program for more than 2 years?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND inPhase = 'yes' AND yearsInProgram > 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor has taught a course at a level above intermediate?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T1.course_id WHERE T3.courseLevel = 'upper'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor with p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram = 'More than 5'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the number of courses that have a specific course level",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Specific Level'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "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.professor = 1 AND p.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the courseLevel of the course taught by person with p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor who is currently in the program?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'professor' AND T3.inPhase = 'current'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by the person with the professor position?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are there in the person table?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor taught which course?",
    "SQL": "SELECT T1.p_id, T2.course_id FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course does person with id 1 teach?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the different levels of courses offered in the program?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have more than 5 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the undergraduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors have advised students?",
    "SQL": "SELECT T1.professor FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id_dummy IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's ID who teaches the course with the highest level?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T3.courseLevel = ( SELECT MAX(courseLevel) FROM course ) LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the undergraduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have a course level of 'senior'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'senior'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have at least one professor teaching them?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are level 'Advanced'?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Advanced'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors advised by person with p_id=1?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE hasPosition = 'professor' AND yearsInProgram > 5)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(DISTINCT T1.course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by the person with p_id 1?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students have been advised by a professor with more than 5 years in the program?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T1.p_id_dummy = T3.p_id WHERE T3.hasPosition = 'professor' AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > '5' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with ID 5?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors in the system?",
    "SQL": "SELECT COUNT(T2.course_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor has taught the most courses?",
    "SQL": "SELECT T2.p_id, COUNT(*) AS num_courses FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 GROUP BY T2.p_id ORDER BY num_courses DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all courses taught by professors?",
    "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.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the program?",
    "SQL": "SELECT course_id FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are enrolled in the system?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with a position of 'professor'?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.hasPosition = 'professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is teaching the course with course_id 1?",
    "SQL": "SELECT T2.professor FROM course AS T1 INNER JOIN person AS T2 ON T1.course_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor with id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professor with ID 123?",
    "SQL": "SELECT COUNT(*) FROM taughtBy WHERE p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "list all courses that a professor is teaching",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with id 123?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by a specific person?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by professor with id 123?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are enrolled in the course with course_id 1?",
    "SQL": "SELECT COUNT(*) FROM person WHERE p_id IN (SELECT p_id FROM advisedBy WHERE p_id_dummy IN (SELECT p_id FROM taughtBy WHERE course_id = 1))",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels that have been offered?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are taught by professors in phase 1 of the program?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.inPhase = 'phase 1'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with the ID 1?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching the most courses?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T2.p_id ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are all the distinct course levels in the course table?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by Professor Smith?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a course level of 'Introductory'?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Introductory'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which person who is a professor is also a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with positions in the program?",
    "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 p.hasPosition = 'Yes' AND p.yearsInProgram IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the courses that are taught by person with ID 5?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches a course at the 'Graduate' level?",
    "SQL": "SELECT T1.professor FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T3.courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have the position of 'AsstProf'?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.hasPosition = 'AsstProf' AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with a position in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.hasPosition = 'yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have students who are advised by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id INNER JOIN advisedBy AS T4 ON T3.p_id = T4.p_id INNER JOIN person AS T5 ON T4.p_id_dummy = T5.p_id WHERE T3.student = 1 AND T5.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with positions?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which SQL query would retrieve the list of courses taught by a specific professor identified by a unique person ID?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the number of courses taught by each professor",
    "SQL": "SELECT COUNT(T1.p_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level does a person teach?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all courses that have a course level of 'Advanced'.",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Advanced'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses does a specific professor teach?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a specific years in program?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.yearsInProgram = 'specific_years'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level?",
    "SQL": "SELECT course_id FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all the courses and their respective levels?",
    "SQL": "SELECT T1.course_id , T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels taught by each professor?",
    "SQL": "SELECT T1.courseLevel, T3.professor FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 GROUP BY T1.courseLevel, T3.professor",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are currently taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses have a course level of 'graduate'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by each professor?",
    "SQL": "SELECT COUNT(*) AS total_courses, p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor has taught the most courses?",
    "SQL": "SELECT p_id, COUNT(course_id) AS course_count FROM taughtBy GROUP BY p_id ORDER BY course_count DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the course level 'Graduate'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 102?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 102",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the courses taught by a professor with the ID 100?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.p_id = 100 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of a course taught by a person with the position of 'Professor'?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all courses that are taught by a professor.",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by Professor John Doe?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'Professor John Doe'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all courses taught by professors who have been in the program for more than 5 years and have a position as a faculty member.",
    "SQL": "SELECT DISTINCT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5 AND T3.professor = 1 AND T3.hasPosition = 'faculty member'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is advising whom in the person table?",
    "SQL": "SELECT T1.p_id, T1.p_id_dummy FROM advisedBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors teach which level courses?",
    "SQL": "SELECT T1.professor, T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with years in the program greater than 5?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by Professor Alice?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1 AND T1.student = 0 AND T1.hasPosition = 'Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id, T1.professor FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor X?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level has the most courses taught by professors?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 GROUP BY T1.courseLevel ORDER BY COUNT(T1.course_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are offered at each course level?",
    "SQL": "SELECT T1.courseLevel, COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each person?",
    "SQL": "SELECT T1.p_id, COUNT(T2.course_id) AS num_courses FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "who are the students and their advisers in the person table?",
    "SQL": "SELECT T1.p_id, T1.student, T2.p_id_dummy FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with a position in the program?",
    "SQL": "SELECT DISTINCT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'yes' AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the courses that a professor is teaching?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are teaching the course at the advanced level?",
    "SQL": "SELECT DISTINCT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.courseLevel = 'advanced' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is a professor in the database?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position as a teaching assistant?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.student = 0 AND T1.hasPosition = 'Teaching Assistant'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by Professor X?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = 'Professor' AND T2.student = 0",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the different levels of courses offered in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with a position in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.hasPosition = 'yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which course is taught by professor A?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which person have been advised by another person",
    "SQL": "SELECT T1.p_id, T2.p_id FROM advisedBy AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id_dummy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all courses taught by professors in the 'Teaching' phase of the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.inPhase = 'Teaching'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years of experience in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs and their corresponding course levels?",
    "SQL": "SELECT course_id, courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with the position 'professor'?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE hasPosition = 'professor')",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professor with professor ID 123?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professor with p_id 101?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 101",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of years a student has been in the program?",
    "SQL": "SELECT AVG(yearsInProgram) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor with a specific position?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.hasPosition = 'specific_position'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are teaching in which courses?",
    "SQL": "SELECT T1.hasPosition, T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course id 123?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor with the position 'Full Professor'?",
    "SQL": "SELECT COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = 'Full Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by Professor X?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most courses?",
    "SQL": "SELECT T2.p_id, COUNT(T1.course_id) as course_count FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 GROUP BY T2.p_id ORDER BY course_count DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with positions?",
    "SQL": "SELECT T2.course_id, T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.hasPosition IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with years in program greater than 5?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which are the courses taught by professors?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with ID 5?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT T1.professor, COUNT(T2.course_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.professor",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'current'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) have a course level of 'Master'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Master'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with at least 5 years in the program?",
    "SQL": "SELECT course_id FROM taughtBy JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1 AND person.yearsInProgram = '5 or more'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by professors with the position 'assistant'?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T1.p_id_dummy = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'assistant' AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the course with the highest level? Select the professor's name.",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T3.courseLevel = ( SELECT MAX(courseLevel) FROM course )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each person?",
    "SQL": "SELECT COUNT(course_id), p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(T1.course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "The total number of courses taught by professors in the program",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the master level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'master'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors in the database?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than one professor teaching them?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id HAVING COUNT(T2.p_id) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who taught which course?",
    "SQL": "SELECT T2.p_id, T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the database?",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course c JOIN taughtBy t ON c.course_id = t.course_id JOIN person p ON t.p_id = p.p_id WHERE p.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors with a position?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.hasPosition IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have been taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram = 'More than 5 years' AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than 5 students?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T2.course_id HAVING COUNT(T2.p_id) > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT DISTINCT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than one professor teaching them?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id HAVING COUNT(T2.p_id) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are advised by whom?",
    "SQL": "SELECT T1.p_id, T2.p_id_dummy FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 123?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the courseLevel for each course taught by a professor?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have more than 10 years of experience in the program?",
    "SQL": "SELECT c.course_id, c.courseLevel FROM course AS c JOIN taughtBy AS tb ON c.course_id = tb.course_id JOIN person AS p ON tb.p_id = p.p_id WHERE p.professor = 1 AND p.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what are the courses level 4 and above",
    "SQL": "SELECT courseLevel FROM course WHERE courseLevel LIKE '4%' OR courseLevel LIKE '5%' OR courseLevel LIKE '6%' OR courseLevel LIKE '7%' OR courseLevel LIKE '8%' OR courseLevel LIKE '9%'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors with positions in the program?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.hasPosition = 'yes' AND T2.inPhase = 'yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have a course level of 'graduate'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses does Professor Smith teach?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.p_id = (SELECT p_id FROM person WHERE professor = 1 AND T1.p_id = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors who have a position in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'yes' AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors in the courseLevel 'Basic'?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T1.courseLevel = 'Basic'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors in the system?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are available in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are taught by professors?",
    "SQL": "SELECT DISTINCT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has been a professor for more than 5 years?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND hasPosition = 'student' AND inPhase = 'in program'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is a professor and has been in the program for more than 5 years?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND inPhase = 'yes' AND yearsInProgram > '5'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have a professor teaching them?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors have advised more than one student in the program?",
    "SQL": "SELECT T1.hasPosition, COUNT(T2.p_id_dummy) AS num_students FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.hasPosition HAVING COUNT(T2.p_id_dummy) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses does Professor A teach?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.p_id = (SELECT p_id FROM person WHERE professor = 1 LIMIT 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have been taught by professors in the past 3 years?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.yearsInProgram >= 3",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the levels of courses taught by person with p_id 5?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has advised at least one student?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are enrolled in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses does person with p_id 1 teach?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of students in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by Professor Smith?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by a professor?",
    "SQL": "SELECT course_id FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with id 1?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with id 123?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor who teaches the most number of courses?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.p_id ORDER BY COUNT(T1.p_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT DISTINCT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with p_id 100?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 100",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = 'professor' AND T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors?",
    "SQL": "SELECT COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are teaching the 'PhD' level course?",
    "SQL": "SELECT T1.professor FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.courseLevel = 'PhD'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors in the system?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest course level in the 'course' table?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with the course id 123?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "who is the professor who teaches the course at the 7th level?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.courseLevel = '7th' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T1.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors who have taught courses at a specific level, and what are those levels?",
    "SQL": "SELECT T1.professor, T3.courseLevel FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in each course level?",
    "SQL": "SELECT COUNT(*) , courseLevel FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with a specific hasPosition value?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'specific_value'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has been taught by professor?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the 'beginner' level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'beginner'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the database?",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has advised another person?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses does a professor teach?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position as an associate professor?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.hasPosition = 'Associate Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a specific professor?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the courseLevel for the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by a person with a specific position in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'specificPosition'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have more than 5 years in the program?",
    "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 p.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the levels of courses taught by person with ID 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the SQL query to find the names of all courses that are taught by at least two professors?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id IN (SELECT p_id FROM person WHERE hasPosition = 'professor') GROUP BY T2.course_id HAVING COUNT(T2.course_id) >= 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a course level of 'graduate'?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by person with p_id 1?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the 'course' table?",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with more than 5 years of experience?",
    "SQL": "SELECT course_id FROM taughtBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = 'professor' AND T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most courses?",
    "SQL": "SELECT T1.p_id, COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.p_id ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the undergraduate level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "List all students and their advisors.",
    "SQL": "SELECT T1.student, T2.p_id_dummy FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person IDs have advised each other?",
    "SQL": "SELECT p_id, p_id_dummy FROM advisedBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT DISTINCT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > '10 years' AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with over 10 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT DISTINCT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.yearsInProgram > 5 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the professor who has advised the most students?",
    "SQL": "SELECT T2.p_id, COUNT(*) AS num_advised FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1 AND T2.professor = 0 GROUP BY T2.p_id ORDER BY num_advised DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND inPhase = 'current'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a specific professor?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person who has a position?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the different levels of courses in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors who have a position?",
    "SQL": "SELECT COUNT(T1.course_id) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the most common course level?",
    "SQL": "SELECT courseLevel FROM course GROUP BY courseLevel ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than 2 students enrolled?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T2.course_id HAVING COUNT(T2.p_id) > 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who has the highest yearsInProgram?",
    "SQL": "SELECT p_id FROM person ORDER BY yearsInProgram DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = 'professor' AND T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who has advised at least 3 students?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id_dummy IN ( SELECT T2.p_id_dummy FROM advisedBy AS T2 INNER JOIN person AS T1 ON T1.p_id = T2.p_id_dummy GROUP BY T2.p_id_dummy HAVING COUNT(T2.p_id_dummy) >= 3 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors in the system?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years of experience?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most courses?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id GROUP BY T2.professor ORDER BY COUNT(T1.course_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with the highest courseLevel?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest number of students?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'student'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor?",
    "SQL": "SELECT COUNT(T2.course_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the count of courses taught by each professor?",
    "SQL": "SELECT COUNT(*) , p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the levels of courses taught by professors?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of a course taught by a professor with a position in the program?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1 AND T1.hasPosition = 'in phase'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor with the most courses taught?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id GROUP BY T2.p_id ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with years in the program greater than 10?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor name associated with a specific student name?",
    "SQL": "SELECT T2.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1 AND T1.yearsInProgram = 'specific student name'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with positions? ",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.hasPosition IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors have advised students?",
    "SQL": "SELECT DISTINCT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the different levels of courses available?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the courseLevel of the course taught by person with p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels for courses taught by a person with a specific p_id?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has been advised by more than one person?",
    "SQL": "SELECT p_id FROM advisedBy GROUP BY p_id HAVING COUNT(p_id_dummy) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) is/are taught by professor with id 5?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have the position 'SeniorProfessor'?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'SeniorProfessor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many professors are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND inPhase = 'Yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor taught the most courses?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id GROUP BY T2.professor ORDER BY COUNT(T1.course_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id, T1.professor, T1.yearsInProgram FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.yearsInProgram > '5'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) is taught by professor with p_id 10?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most courses?",
    "SQL": "SELECT T2.p_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id GROUP BY T2.p_id ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with ID 1?",
    "SQL": "SELECT T1.course_id, T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT course_id FROM taughtBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.yearsInProgram > '5'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently enrolled in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'Enrolled'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the courseLevel of the course taught by person with p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the courseLevel of the course with course_id = 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How can I find the names of all professors in the database?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the 'Senior' level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Senior'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are advised by other professors in the program?",
    "SQL": "SELECT p_id FROM advisedBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "how many courses are there?",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors teach which courses?",
    "SQL": "SELECT T1.p_id, T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors?",
    "SQL": "SELECT COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with a position in phase?",
    "SQL": "SELECT course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.inPhase = 'yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels taught by person with p_id 123?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who taught each course?",
    "SQL": "SELECT T2.p_id, T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with years in the program of more than 5?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.hasPosition = 'professor' AND T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in each course level?",
    "SQL": "SELECT COUNT(course_id), courseLevel FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT DISTINCT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the students advised by Professor John?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T1.p_id_dummy = T3.p_id WHERE T2.professor = 1 AND T3.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels for which there are at least one course taught?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id IN (SELECT course_id FROM taughtBy)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is advising student X?",
    "SQL": "SELECT T2.professor FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = (SELECT p_id FROM person WHERE student = 1 AND inPhase = 'X')",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors have advised at least one student?",
    "SQL": "SELECT T2.professor FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most number of courses?",
    "SQL": "SELECT p_id FROM taughtBy GROUP BY p_id ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are teaching which courses?",
    "SQL": "SELECT T1.courseLevel, T3.professor FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have positions?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.hasPosition = 'Yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which courses are taught by professor with id 123 ?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by a professor with a specific hasPosition value?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = 'specific_value'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the undergraduate level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the current phase of the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T1.inPhase = 'current' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor has advised the most students?",
    "SQL": "SELECT T1.p_id, COUNT(T1.p_id) AS advised_students FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 GROUP BY T1.p_id ORDER BY advised_students DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the undergraduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor 123?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND hasPosition IS NOT NULL AND inPhase IS NOT NULL AND yearsInProgram IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T1.p_id = T3.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most courses?",
    "SQL": "SELECT T2.p_id, COUNT(T1.course_id) AS course_count FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T2.p_id ORDER BY course_count DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has not yet been assigned to a position?",
    "SQL": "SELECT p_id FROM person WHERE hasPosition IS NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all courses that have a courseLevel of 'Advanced'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Advanced'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the undergraduate level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the student count who has been advised by at least one person?",
    "SQL": "SELECT COUNT(*) FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have been taught by more than one professor?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id HAVING COUNT(DISTINCT T2.p_id) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who are inPhase 'twoPhase'?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.inPhase = 'twoPhase'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.hasPosition = 'professor' AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are enrolled in the 'undergraduate' level courses?",
    "SQL": "SELECT COUNT(*) FROM course AS c JOIN taughtBy AS tb ON c.course_id = tb.course_id JOIN person AS p ON tb.p_id = p.p_id WHERE c.courseLevel = 'undergraduate' AND p.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT DISTINCT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by a professor with more than 5 years in the program?",
    "SQL": "SELECT T3.p_id AS student_id, T2.p_id AS advisor_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T2.p_id = T1.p_id INNER JOIN person AS T3 ON T3.p_id = T1.p_id_dummy WHERE T2.yearsInProgram > 5 AND T3.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a level of 'Advanced'?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Advanced'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level has the most courses?",
    "SQL": "SELECT courseLevel FROM course GROUP BY courseLevel ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are available in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are taught by person with ID 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels taught by person with ID 123?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by a professor in the 'PhD' course level?",
    "SQL": "SELECT T3.student FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T1.p_id_dummy = T3.p_id INNER JOIN taughtBy AS T4 ON T2.p_id = T4.p_id INNER JOIN course AS T5 ON T4.course_id = T5.course_id WHERE T5.courseLevel = 'PhD' AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with years in program greater than 5?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Retrieve the course level of the course with course ID 1.",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have a professor assigned to them?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are taught by professors?",
    "SQL": "SELECT DISTINCT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor John Doe?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.student = 0 AND T3.yearsInProgram = 'John Doe'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are associated with the course 'Introduction to Programming'?",
    "SQL": "SELECT T2.professor FROM course AS T1 INNER JOIN person AS T2 ON T1.course_id = T2.p_id INNER JOIN taughtBy AS T3 ON T2.p_id = T3.p_id WHERE T1.courseLevel = 'Introduction to Programming'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches which courses?",
    "SQL": "SELECT T2.p_id, T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have a professor assigned to them?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id IS NOT NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that is taught by a professor?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T1.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course IDs taught by professors with a position of 'full'?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.hasPosition = 'full'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors in the program?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for at least 5 years?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.yearsInProgram = '5' AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is teaching which courses?",
    "SQL": "SELECT T2.course_id, T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are teaching the most courses?",
    "SQL": "SELECT T2.p_id, T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id IN ( SELECT T2.p_id FROM taughtBy AS T2 GROUP BY T2.p_id ORDER BY COUNT(*) DESC LIMIT 1 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are teaching courses at the graduate level?",
    "SQL": "SELECT T1.professor FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches which courses?",
    "SQL": "SELECT T1.p_id, T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches the course with course_id 1?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T2.course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the program?",
    "SQL": "SELECT T2.course_id, T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = 'professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'current'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are offered in the course table?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors have advised students?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the 'graduate' level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are advised by each professor?",
    "SQL": "SELECT T2.p_id, COUNT(*) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T2.student = 1 AND T2.professor = 1 GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by a person with a specific professor ID?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by at least one professor?",
    "SQL": "SELECT COUNT(*) FROM ( SELECT p_id FROM taughtBy WHERE p_id IN ( SELECT p_id FROM person WHERE professor = 1 ) )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are currently in the program?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student IS NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have more than 5 years in the program?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are all the course levels in the course table?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id, T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id IN ( SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 5 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with positions in the program?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1 AND T1.hasPosition = 'inProgram'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course levels are available in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the undergraduate level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 5?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professor John?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.student = 0 AND T3.hasPosition = 'Professor John'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with the ID 5?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in each course level?",
    "SQL": "SELECT COUNT(course_id), courseLevel FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of a course that is taught by a professor with ID 123?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T1.p_id = T3.p_id WHERE T3.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the 'course' and 'person' tables?",
    "SQL": "SELECT T1.course_id, T2.professor FROM course AS T1 INNER JOIN person AS T2 ON T2.p_id = T1.courseLevel WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "who is advised by whom",
    "SQL": "SELECT T1.p_id, T1.p_id_dummy FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professor with p_id 1?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with ID 5?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have been taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors in the system?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years of experience?",
    "SQL": "SELECT course_id FROM taughtBy JOIN person ON taughtBy.p_id = person.p_id WHERE person.student = 0 AND person.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor with p_id 1?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course that has a student enrolled?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are teaching courses at a specific level?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T3.courseLevel = 'specificLevel' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the graduate level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find all courses taught by a professor with a yearsInProgram greater than 5.",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = ( SELECT MAX(courseLevel) FROM course )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the levels of courses taught by professors in the program?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T2.course_id = ( SELECT course_id FROM taughtBy WHERE p_id = ( SELECT p_id FROM person WHERE professor = 1 ) )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has a position in the program and has been in the program for more than 5 years?",
    "SQL": "SELECT * FROM person WHERE hasPosition = 'Yes' AND yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T2.course_id, T1.professor FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 0 AND T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are there in the database?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the courses taught by professor with ID 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors in the program?",
    "SQL": "SELECT COUNT(*) FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by each professor?",
    "SQL": "SELECT T2.courseLevel, T1.p_id FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which students are advised by at least one professor?",
    "SQL": "SELECT T2.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN person AS T3 ON T1.p_id_dummy = T3.p_id WHERE T2.student = 1 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "who taught the 'Fundamentals of Programming' course ?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel = 'Fundamentals of Programming'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT DISTINCT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram > 10 AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who are also students?",
    "SQL": "SELECT DISTINCT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students have advised by person with id 2?",
    "SQL": "SELECT COUNT(*) FROM advisedBy WHERE p_id_dummy = 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have a course level of 'Undergraduate'?",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the undergraduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than one professor teaching them?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id HAVING COUNT(T2.p_id) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is taught by person with ID 1?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with years in program greater than 5?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest course level offered?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what is the professor id for the person with id 3",
    "SQL": "SELECT T2.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 3",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the count of students currently in the program who are advisors?",
    "SQL": "SELECT COUNT(*) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(T2.course_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the different levels of courses available?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the student status of a person with a position in the program?",
    "SQL": "SELECT student FROM person WHERE hasPosition = 'yes'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course teaches most students?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id IN ( SELECT p_id FROM person WHERE student = 1 ) GROUP BY T1.course_id, T1.courseLevel ORDER BY COUNT(T2.p_id) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors who have advised at least one student?",
    "SQL": "SELECT DISTINCT T1.professor FROM person AS T1 JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in each level?",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor with ID 123?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T2.course_id = ( SELECT T1.course_id FROM taughtBy AS T1 WHERE T1.p_id = 123 )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "list all the course ids of courses that are taught by professor with id 1",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors in the database?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which SQL query can I use to find all the courses taught by a specific person? (The person's ID is 45)",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 45",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels offered in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the lowest level?",
    "SQL": "SELECT course_id FROM course ORDER BY courseLevel ASC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the program?",
    "SQL": "SELECT T1.course_id, T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor with a position of 'researcher'?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'researcher'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels that are offered in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's position in the program?",
    "SQL": "SELECT hasPosition FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person in the database has both a student and professor role?",
    "SQL": "SELECT p_id FROM person WHERE student = 1 AND professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels taught by professor John Doe?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id INNER JOIN taughtBy AS T3 ON T2.course_id = T3.course_id WHERE T1.professor = 1 AND T1.hasPosition = 'John Doe'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is teaching which course?",
    "SQL": "SELECT T1.p_id, T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Find the number of courses at each level.",
    "SQL": "SELECT COUNT(*) , courseLevel FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course ID 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the system?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the program?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "list the course levels of all courses taught by professors",
    "SQL": "SELECT DISTINCT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have the position 'faculty'?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.hasPosition = 'faculty'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by person with p_id 100?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 100",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the database?",
    "SQL": "SELECT COUNT(course_id) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "what courses are taught by professor with id 123?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.yearsInProgram > '5' AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by person with p_id 2?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at each level?",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with the position 'professor'?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are teaching the courses?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "how many courses are there?",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each person?",
    "SQL": "SELECT T2.p_id, COUNT(T1.course_id) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course IDs are taught by professors?",
    "SQL": "SELECT DISTINCT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the graduate level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years of experience in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > '10'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "list all the professor ids",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there at the advanced level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Advanced'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the different levels of courses in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a course level of 'undergraduate'?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position in the program?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'yes' AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of all people who are professors?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses have a courseLevel of 'graduate'?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor taught the most courses?",
    "SQL": "SELECT T1.hasPosition FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id GROUP BY T1.hasPosition ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by Professor Jane?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T2.course_id IN ( SELECT T3.course_id FROM taughtBy AS T3 INNER JOIN person AS T4 ON T4.p_id = T3.p_id WHERE T4.professor = 1 AND T4.hasPosition = 'Professor Jane' )",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the highest course level in the course table?",
    "SQL": "SELECT MAX(courseLevel) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor is teaching a course at a certain level?",
    "SQL": "SELECT T1.professor, T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T2.courseLevel = 'a certain level'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for a course that is taught by person with p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(course_id), p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by person with id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor in the person table is associated with course 123 in the taughtBy table?",
    "SQL": "SELECT T2.professor FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.course_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels of all courses taught by professor with id 123?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a professor?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in each level?",
    "SQL": "SELECT courseLevel, COUNT(*) FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT course_id FROM taughtBy INNER JOIN person ON taughtBy.p_id = person.p_id WHERE person.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id, T2.professor, T2.yearsInProgram FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram > 5 AND T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a position as 'Assistant Professor'?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.hasPosition = 'Assistant Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professor X?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the average number of years students have been in the program?",
    "SQL": "SELECT AVG(yearsInProgram) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is both a professor and a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "how many courses have a level of Phd",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'Phd'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT course_id FROM taughtBy AS T1 JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 AND T2.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels offered by the university?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is taught by professor with p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor ID for the person who teaches a course at the advanced level?",
    "SQL": "SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel = 'advanced'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the course table?",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by Professor John Doe?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1 AND T1.p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the course with the highest courseLevel?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with a specific position in the program?",
    "SQL": "SELECT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = 'specific position'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(student) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with p_id 123?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the undergraduate level?",
    "SQL": "SELECT COUNT(course_id) FROM course WHERE courseLevel = 'undergraduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "who are all the people who are advised by person with id 5",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T1.p_id_dummy = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professor teaches the most courses?",
    "SQL": "SELECT T2.professor, COUNT(*) AS CourseCount FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1 GROUP BY T2.professor ORDER BY CourseCount DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT DISTINCT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are at the advanced level?",
    "SQL": "SELECT COUNT(*) FROM course WHERE courseLevel = 'advanced'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course(s) does the person with ID 123 teach?",
    "SQL": "SELECT T2.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is teaching which course?",
    "SQL": "SELECT T2.course_id, T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels taught by a specific professor?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the names of courses taught by professors in the 'Professor' role?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the professor's course level?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the courses that Professor A teaches?",
    "SQL": "SELECT T2.courseLevel FROM person AS T1 INNER JOIN course AS T2 ON T1.p_id = T2.course_id INNER JOIN taughtBy AS T3 ON T3.p_id = T1.p_id WHERE T1.professor = 1 AND T1.p_id = 'A'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors in the program?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT COUNT(T2.course_id) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.student = 0 AND T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with years in the program greater than 5?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T1.p_id = T3.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > '5'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which professors are teaching courses at the graduate level?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T3.course_id = T2.course_id WHERE T3.courseLevel = 'graduate'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 123?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course taught by professor with p_id 1?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.p_id = 1 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are currently in the program?",
    "SQL": "SELECT COUNT(p_id) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have been in the program for more than 5 years?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > '5 years'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which SQL query can be used to find all courses that are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years of experience in the program?",
    "SQL": "SELECT DISTINCT T1.course_id FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.hasPosition = 'Professor' AND T2.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest level according to the courseLevel field?",
    "SQL": "SELECT course_id FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course has the highest course level?",
    "SQL": "SELECT courseLevel FROM course ORDER BY courseLevel DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the 'Bar' phase of the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1 AND inPhase = 'Bar'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years of experience in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors in the 'Teaching' phase of the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1 AND T3.inPhase = 'Teaching'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which of the following SQL queries will give the list of courses and their respective course levels?",
    "SQL": "Select course_id , courseLevel from course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have more than one professor teaching them?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id HAVING COUNT(T2.p_id) > 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors who have more than 5 years of experience in the program?",
    "SQL": "SELECT DISTINCT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in the database?",
    "SQL": "SELECT COUNT(*) FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who is the professor that teaches course level 400?",
    "SQL": "SELECT T2.professor FROM course AS T1 INNER JOIN person AS T2 ON T2.p_id = T2.p_id WHERE T1.courseLevel = '400'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "how many people have advised by someone?",
    "SQL": "SELECT COUNT(*) FROM advisedBy",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who has advised by person with id '123'?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.p_id = '123'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years of experience in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T1.yearsInProgram > 5 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1 AND T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of courses taught by professors ?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 10 AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years of experience?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id IN (SELECT p_id FROM person WHERE professor = 1 AND yearsInProgram > 10)",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors with a position as a full-time faculty member?",
    "SQL": "SELECT COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = 'Full-Time Faculty' AND T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "which person has been advised by another person in the program ?",
    "SQL": "SELECT T1.p_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are there in each course level?",
    "SQL": "SELECT COUNT(*) , courseLevel FROM course GROUP BY courseLevel",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course level is associated with the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor with p_id 123?",
    "SQL": "SELECT T2.courseLevel FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T1.p_id = T3.p_id WHERE T3.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who are the professors in the person table?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which course is taught by person with p_id 1?",
    "SQL": "SELECT course_id FROM taughtBy WHERE p_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 5 years in the program?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram = 'more than 5'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of a course that is taught by person with id 123?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 123",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with a hasPosition of 'Professor'?",
    "SQL": "SELECT T2.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.hasPosition = 'Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by each professor?",
    "SQL": "SELECT COUNT(course_id), p_id FROM taughtBy GROUP BY p_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a specific professor? Provide SQL query to find the courses taught by professor with p_id 5.",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Who teaches which course?",
    "SQL": "SELECT T2.p_id, T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person has the position of professor?",
    "SQL": "SELECT p_id FROM person WHERE hasPosition = 'professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor with p_id 101?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.p_id = 101 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have a student as a professor?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.student = 1 AND T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have a professor teaching them?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses have a professor teaching them?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which person is advised by two others?",
    "SQL": "SELECT T1.p_id FROM person AS T1 INNER JOIN advisedBy AS T2 ON T1.p_id = T2.p_id GROUP BY T2.p_id_dummy HAVING COUNT(T2.p_id) = 2",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by a specific professor?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level for the course with id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in the program?",
    "SQL": "SELECT COUNT(*) FROM person WHERE student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses have been taught by professors?",
    "SQL": "SELECT DISTINCT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course_id 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are being taught by professors in the database?",
    "SQL": "SELECT COUNT(T1.course_id) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many students are in each phase of the program?",
    "SQL": "SELECT inPhase, COUNT(*) FROM person WHERE student = 1 GROUP BY inPhase",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors in the database?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors with more than 10 years in the program?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.yearsInProgram > 10",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by professors?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the course levels offered in the database?",
    "SQL": "SELECT DISTINCT courseLevel FROM course",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors with the title 'Professor'?",
    "SQL": "SELECT COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.hasPosition = 'Professor'",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the course level of the course with course ID 1?",
    "SQL": "SELECT courseLevel FROM course WHERE course_id = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professors with yearsInProgram greater than 5?",
    "SQL": "SELECT T1.course_id, T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.yearsInProgram > 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What are the levels of courses that are taught by professors?",
    "SQL": "SELECT DISTINCT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T2.p_id = T3.p_id WHERE T3.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What courses are taught by professor X?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.professor = 'X' AND T3.student IS NULL",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the total number of people who are both a professor and a student?",
    "SQL": "SELECT COUNT(*) FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "How many courses are taught by professors?",
    "SQL": "SELECT COUNT(*) FROM taughtBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.professor = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the name of the person who is both a professor and a student?",
    "SQL": "SELECT p_id FROM person WHERE professor = 1 AND student = 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by a person with the ID 5?",
    "SQL": "SELECT T1.course_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T2.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "Which courses are taught by the person with the highest yearsInProgram?",
    "SQL": "SELECT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id ORDER BY T1.yearsInProgram DESC LIMIT 1",
    "db_id": "computer_student",
    "evidence": ""
  },
  {
    "question": "What is the level of the course taught by professor with p_id 5?",
    "SQL": "SELECT T1.courseLevel FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id INNER JOIN person AS T3 ON T3.p_id = T2.p_id WHERE T3.p_id = 5",
    "db_id": "computer_student",
    "evidence": ""
  }
]