สำหรับ HISTART 481 ฉันต้องปฏิบัติตามข้อกำหนดเบื้องต้นใดบ้าง ไม่จำเป็นต้องใช้ตารางทั้งหมด
For HISTART 481 , what prerequisites have I fulfilled ?It is not neccessary to use all the tables.
 ta:  campus_job_id [ int]  student_id [ int]  location [ varchar] 
SELECT DISTINCT COURSE_0.department, COURSE_0.name, COURSE_0.number FROM course AS COURSE_0, course AS COURSE_1, course_prerequisite, student_record WHERE COURSE_0.course_id = course_prerequisite.pre_course_id AND COURSE_1.course_id = course_prerequisite.course_id AND COURSE_1.department = 'HISTART' AND COURSE_1.number = 481 AND student_record.course_id = COURSE_0.course_id AND student_record.student_id = 1