เมื่อ Tina Meyer สอบ MATSCIE 270 ใครสอนชั้นเรียนนั้น ?ไม่จำเป็นต้องใช้โต๊ะทั้งหมด
When Tina Meyer took MATSCIE 270 , who taught that class ?It is not neccessary to use all the tables.
 program_requirement:  program_id [ int]  category [ varchar]  min_credit [ int]  additional_req [ varchar] 
SELECT DISTINCT instructor.name FROM instructor INNER JOIN offering_instructor ON offering_instructor.instructor_id = instructor.instructor_id INNER JOIN student_record ON student_record.offering_id = offering_instructor.offering_id INNER JOIN student ON student.student_id = student_record.student_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 WHERE course.department = 'MATSCIE' AND course.number = 270 AND student.firstname LIKE 'Tina' AND student.lastname LIKE 'Meyer'