ภาคเรียนถัดไปที่จะสอน RCCORE 102 ?ไม่จำเป็นต้องใช้ทุกตาราง
Next semester who is teaching RCCORE 102 ?It is not neccessary to use all the tables.
 jobs:  job_id [ int]  job_title [ varchar]  description [ varchar]  requirement [ varchar]  city [ varchar]  state [ varchar]  country [ varchar]  zip [ int] 
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 course ON course.course_id = course_offering.course_id INNER JOIN semester ON semester.semester_id = course_offering.semester WHERE course.department = 'RCCORE' AND course.number = 102 AND semester.semester = 'FA' AND semester.year = 2016