คลาสใดที่ง่ายที่สุดที่ฉันสามารถทำได้เพื่อตอบสนองข้อกำหนดอื่น ๆ ไม่จำเป็นต้องใช้ตารางทั้งหมด
What would be the easiest class I could take to satisfy the Other requirement ?It is not neccessary to use all the tables.
 course:  course_id [ int]  name [ varchar]  department [ varchar]  number [ varchar]  credits [ varchar]  advisory_requirement [ varchar]  enforced_requirement [ varchar]  description [ varchar]  num_semesters [ int]  num_enrolled [ int]  has_discussion [ varchar]  has_lab [ varchar]  has_projects [ varchar]  has_exams [ varchar]  num_reviews [ int]  clarity_score [ int]  easiness_score [ int]  helpfulness_score [ int] 
SELECT DISTINCT course.department, course.name, course.number, program_course.workload, program_course.workload FROM course, program_course WHERE program_course.category LIKE '%Other%' AND program_course.course_id = course.course_id AND program_course.workload = (SELECT MIN(PROGRAM_COURSEalias1.workload) FROM program_course AS PROGRAM_COURSEalias1 WHERE PROGRAM_COURSEalias1.category LIKE '%Other%')