ใครเป็นครูประจำของ ARTDES 301 ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
Who is the usual teacher for ARTDES 301 ?It is not neccessary to use all the tables.
 requirement:  requirement_id [ int]  requirement [ varchar]  college [ varchar] 
SELECT COUNT(instructor.name), instructor.name FROM course, course_offering, instructor, offering_instructor WHERE course.course_id = course_offering.course_id AND course.department = 'ARTDES' AND course.number = 301 AND offering_instructor.instructor_id = instructor.instructor_id AND offering_instructor.offering_id = course_offering.offering_id GROUP BY instructor.name ORDER BY COUNT(instructor.name) DESC LIMIT 5