[
  {
  "db_id": "computer_student",
  "question": "What is the average number of students for each advisor?",
  "evidence": "students refers to advisedBy.p_id; advisor refers to p_id_dummy; average number = avg(count(advisedBy.p_id))",
  "SQL": "SELECT CAST(COUNT(p_id) AS REAL) / COUNT(DISTINCT p_id_dummy) AS avgnum FROM advisedBy GROUP BY p_id_dummy"
},
{
  "db_id": "computer_student",
  "question": "How many professors are teaching course ID 18?",
  "evidence": "professors refers to taughtBy.p_id; course ID 18 refers to taughtBy.course_id",
  "SQL": "SELECT COUNT(DISTINCT p_id) FROM taughtBy WHERE course_id = 18"
},
{
    "db_id": "computer_student",
    "question": "List all the course IDs for professional or master/graduate courses.",
    "evidence": "professional or master/graduate courses refers to courseLevel = 'Level_500'",
    "SQL": "SELECT course_id FROM course WHERE courseLevel = 'Level_500'"
  }
]