ฤดูหนาวหน้า ใครจะเป็นอาจารย์ผู้สอนชีวกลศาสตร์สำหรับนักศึกษาวิศวกรรมศาสตร์ ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
Next Winter , who will be the Biomechanics for Engineering Students instructor ?It is not neccessary to use all the tables.
 course_offering:  offering_id [ int]  course_id [ int]  semester [ int]  section_number [ int]  start_time [ time]  end_time [ time]  monday [ varchar]  tuesday [ varchar]  wednesday [ varchar]  thursday [ varchar]  friday [ varchar]  saturday [ varchar]  sunday [ varchar]  has_final_project [ varchar]  has_final_exam [ varchar]  textbook [ varchar]  class_address [ varchar]  allow_audit [ varchar] 
SELECT DISTINCT instructor.name FROM instructor INNER JOIN offering_instructor ON offering_instructor.instructor_id = instructor.instructor_id INNER JOIN course_offering ON offering_instructor.offering_id = course_offering.offering_id INNER JOIN semester ON semester.semester_id = course_offering.semester INNER JOIN course ON course.course_id = course_offering.course_id WHERE course.name LIKE '%Biomechanics for Engineering Students%' AND semester.semester = 'Winter' AND semester.year = 2017