อาจารย์คนไหนที่ไม่ใช้ห้องแล็บในหลักสูตร?ไม่จำเป็นต้องใช้ตารางทั้งหมด
Which professors do n't utilize labs in their courses ?It is not neccessary to use all the tables.
 program_course:  program_id [ int]  course_id [ int]  workload [ int]  category [ varchar] 
SELECT DISTINCT instructor.name FROM instructor, course, course_offering, offering_instructor WHERE course.course_id = course_offering.course_id AND course.department = 'EECS' AND course_offering.offering_id = offering_instructor.offering_id AND instructor.instructor_id = offering_instructor.instructor_id AND NOT instructor.instructor_id IN (SELECT DISTINCT offering_instructor.instructor_id FROM course AS COURSEalias0, course_offering AS COURSE_OFFERINGalias0, offering_instructor AS OFFERING_INSTRUCTOR WHERE COURSEalias0.course_id = COURSE_OFFERINGalias0.course_id AND COURSEalias0.has_lab = 'Y' AND COURSE_OFFERINGalias0.offering_id = offering_instructor.offering_id)