คุณรู้หรือไม่ว่าเมื่อใดที่ 501 มีให้บริการ ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
Do you know when 501 is offered ?It is not neccessary to use all the tables.
 student_record:  student_id [ int]  course_id [ int]  semester [ int]  grade [ varchar]  how [ varchar]  transfer_source [ varchar]  earn_credit [ varchar]  repeat_term [ varchar]  test_id [ varchar] 
SELECT DISTINCT semester.semester, semester.year FROM course, course_offering, semester WHERE course.course_id = course_offering.course_id AND course.department = 'EECS' AND course.number = 501 AND course_offering.semester = semester.semester_id AND semester.semester_id > (SELECT SEMESTERalias1.semester_id FROM semester AS SEMESTERalias1 WHERE SEMESTERalias1.semester = 'WN' AND SEMESTERalias1.year = 2016) ORDER BY semester.semester_id LIMIT 1