ในปี 2015 ฉันสามารถสอบ PHYSICS 452 ในช่วงฤดูใบไม้ผลิได้หรือไม่ ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
In 2015 , can I take PHYSICS 452 in the Spring ?It is not neccessary to use all the tables.
 requirement:  requirement_id [ int]  requirement [ varchar]  college [ varchar] 
SELECT COUNT(*) > 0 FROM (SELECT course_id FROM student_record WHERE earn_credit = 'Y' AND student_id = 1) AS DERIVED_TABLEalias0, course AS COURSEalias0, course_offering AS COURSE_OFFERINGalias0, semester AS SEMESTERalias0 WHERE COURSEalias0.course_id = COURSE_OFFERINGalias0.course_id AND NOT COURSEalias0.course_id IN (DERIVED_TABLEalias0.course_id) AND NOT COURSEalias0.course_id IN (SELECT DISTINCT COURSE_PREREQUISITEalias0.course_id FROM course_prerequisite AS COURSE_PREREQUISITEalias0 WHERE NOT COURSE_PREREQUISITEalias0.pre_course_id IN (DERIVED_TABLEalias0.course_id)) AND COURSEalias0.department = 'PHYSICS' AND COURSEalias0.number = 452 AND SEMESTERalias0.semester = 'Spring' AND SEMESTERalias0.semester_id = COURSE_OFFERINGalias0.semester AND SEMESTERalias0.year = 2015