มีใครสอน Professional Communication Strategies นอกเหนือจาก Prof. Figuero บ้างไหม ?ไม่จำเป็นต้องใช้ทุกตาราง
Does anyone teach Professional Communication Strategies besides Prof. Figuero ?It is not neccessary to use all the tables.
 comment_instructor:  instructor_id [ int]  student_id [ int]  score [ int]  comment_text [ varchar] 
SELECT DISTINCT course.department, course.name, course.number, instructor.name FROM course, course_offering, instructor, offering_instructor WHERE course.course_id = course_offering.course_id AND course.name LIKE '%Professional Communication Strategies%' AND NOT instructor.name LIKE '%Figuero%' AND offering_instructor.instructor_id = instructor.instructor_id AND offering_instructor.offering_id = course_offering.offering_id