คลาสใดที่นำเสนอเทอมนี้จะเป็นข้อกำหนดเบื้องต้นสำหรับคลาสอื่นๆ ส่วนใหญ่ ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
Which classes offered this term will be a prerequisite for most other classes ?It is not neccessary to use all the tables.
 comment_instructor:  instructor_id [ int]  student_id [ int]  score [ int]  comment_text [ varchar] 
SELECT COUNT(DISTINCT course_prerequisite.course_id), course.department, course.name, course.number FROM course, course_offering, course_prerequisite, semester WHERE course.course_id = course_offering.course_id AND course.course_id = course_prerequisite.pre_course_id AND course.department = 'EECS' AND semester.semester = 'WN' AND semester.semester_id = course_offering.semester AND semester.year = 2016 GROUP BY course_prerequisite.pre_course_id ORDER BY COUNT(course_prerequisite.course_id) DESC