หนาวหน้า ใครสอนคลาสอื่นๆ บ้างคะ ไม่จำเป็นต้องใช้ทุกโต๊ะ
Next Winter , who is teaching the Other classes ?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 instructor.name 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 INNER JOIN offering_instructor ON offering_instructor.offering_id = course_offering.offering_id INNER JOIN instructor ON offering_instructor.instructor_id = instructor.instructor_id WHERE program_course.category LIKE '%Other%' AND semester.semester = 'Winter' AND semester.year = 2017