หลักสูตรใดบ้างที่ต้องสำเร็จจึงจะสามารถสอบ EARTH 323 ได้ ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
Which courses must be completed to be able to take EARTH 323 ?It is not neccessary to use all the tables.
 program_course:  program_id [ int]  course_id [ int]  workload [ int]  category [ varchar] 
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 = 'EARTH' AND COURSE_1.number = 323