รายวิชาใดที่จะจัดในอีก 6 ภาคการศึกษาข้างหน้า ?ไม่จำเป็นต้องใช้ทุกตาราง
Which courses will be held in the next 6 semesters ?It is not neccessary to use all the tables.
 student:  student_id [ int]  lastname [ varchar]  firstname [ varchar]  program_id [ int]  declare_major [ varchar]  total_credit [ int]  total_gpa [ float]  entered_as [ varchar]  admit_term [ int]  predicted_graduation_semester [ int]  degree [ varchar]  minor [ varchar]  internship [ varchar] 
SELECT DISTINCT course.name, course.number, semester.semester, semester.year FROM course, course_offering, semester WHERE ((semester.semester = 'FA' AND semester.year = 2016) OR (semester.semester = 'FA' AND semester.year = 2017) OR (semester.semester = 'FA' AND semester.year = 2018) OR (semester.semester = 'WN' AND semester.year = 2017) OR (semester.semester = 'WN' AND semester.year = 2018) OR (semester.semester = 'WN' AND semester.year = 2019)) AND course.course_id = course_offering.course_id AND course.department = 'EECS' AND semester.semester_id = course_offering.semester ORDER BY semester.year, semester.semester