MDE คลาสใดในฤดูหนาวหน้า ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
What classes next Winter are MDE ?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 INNER JOIN course_offering ON course.course_id = course_offering.course_id INNER JOIN semester ON semester.semester_id = course_offering.semester INNER JOIN program_course ON program_course.course_id = course_offering.course_id WHERE program_course.category LIKE '%MDE%' AND semester.semester = 'Winter' AND semester.year = 2017