หลักสูตรบังคับก่อนใดที่อยู่ก่อน MCDB 415 ไม่จำเป็นต้องใช้ตารางทั้งหมด
What prerequisite courses fall before MCDB 415 ?It is not neccessary to use all the tables.
 course:  course_id [ int]  name [ varchar]  department [ varchar]  number [ varchar]  credits [ varchar]  advisory_requirement [ varchar]  enforced_requirement [ varchar]  description [ varchar]  num_semesters [ int]  num_enrolled [ int]  has_discussion [ varchar]  has_lab [ varchar]  has_projects [ varchar]  has_exams [ varchar]  num_reviews [ int]  clarity_score [ int]  easiness_score [ int]  helpfulness_score [ int] 
SELECT DISTINCT COURSE_0.department, COURSE_0.name, COURSE_0.number FROM course AS COURSE_0, course AS COURSE_1, course_prerequisite WHERE COURSE_0.course_id = course_prerequisite.pre_course_id AND NOT COURSE_0.course_id IN (SELECT STUDENT_RECORDalias0.course_id FROM student_record AS STUDENT_RECORDalias0 WHERE STUDENT_RECORDalias0.student_id = 1) AND COURSE_1.course_id = course_prerequisite.course_id AND COURSE_1.department = 'MCDB' AND COURSE_1.number = 415