ในภาคเรียนนี้เปิดสอนหลักสูตรใดบ้าง ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
In this semester which courses 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 course.department, course.name, course.number FROM course, course_offering, semester WHERE course.course_id = course_offering.course_id AND course.department = 'EECS' AND semester.semester = 'WN' AND semester.semester_id = course_offering.semester AND semester.year = 2016 ORDER BY course.department