มีหลักสูตร IOE ระดับ 400/500 ที่มีปริมาณงานน้อยหรือไม่ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Are there any 400 / 500 -level IOE courses with a small workload ?It is not neccessary to use all the tables.
 offering_instructor:  offering_instructor_id [ int]  offering_id [ int]  instructor_id [ int] 
SELECT DISTINCT course.department, course.name, course.number, program_course.workload FROM course INNER JOIN program_course WHERE ((course.number < 400 + 100 AND course.number >= 400) OR (course.number < 500 + 100 AND course.number >= 500)) AND course.department = 'IOE' AND program_course.workload = (SELECT MIN(PROGRAM_COURSEalias1.workload) FROM course AS COURSEalias1 INNER JOIN program_course AS PROGRAM_COURSEalias1 WHERE ((COURSEalias1.number < 400 + 100 AND COURSEalias1.number >= 400) OR (COURSEalias1.number < 500 + 100 AND COURSEalias1.number >= 500)) AND COURSEalias1.department = 'IOE')