หลักสูตร MDE ใดที่มีผู้เข้าศึกษามากที่สุดและยากน้อยที่สุด ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
Which MDE course has the most attending that 's least hard ?It is not neccessary to use all the tables.
 student_record:  student_id [ int]  course_id [ int]  semester [ int]  grade [ varchar]  how [ varchar]  transfer_source [ varchar]  earn_credit [ varchar]  repeat_term [ varchar]  test_id [ varchar] 
SELECT DISTINCT department, name, number FROM course WHERE course_id IN (SELECT PROGRAM_COURSE_ID FROM program_course AS PROGRAM_COURSE WHERE PROGRAM_WORKLOAD = (SELECT MIN(PROGRAM_COURSEalias1.workload) FROM program_course AS PROGRAM_COURSEalias1 WHERE PROGRAM_COURSEalias1.category LIKE '%MDE%')) AND num_enrolled = (SELECT MAX(COURSEalias1.num_enrolled) FROM course AS COURSEalias1 WHERE COURSEalias1.course_id IN (SELECT PROGRAM_COURSEalias2.course_id FROM program_course AS PROGRAM_COURSEalias2 WHERE PROGRAM_COURSEalias2.workload = (SELECT MIN(PROGRAM_COURSEalias3.workload) FROM program_course AS PROGRAM_COURSEalias3 WHERE PROGRAM_COURSEalias3.category = 'MDE')))