ชั้นเรียนที่ง่ายที่สุดที่ฉันสามารถทำได้เพื่อให้บรรลุข้อกำหนด PreMajor ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
Easiest class I can take to fulfill the PreMajor requirement ?It is not neccessary to use all the tables.
 course_offering:  offering_id [ int]  course_id [ int]  semester [ int]  section_number [ int]  start_time [ time]  end_time [ time]  monday [ varchar]  tuesday [ varchar]  wednesday [ varchar]  thursday [ varchar]  friday [ varchar]  saturday [ varchar]  sunday [ varchar]  has_final_project [ varchar]  has_final_exam [ varchar]  textbook [ varchar]  class_address [ varchar]  allow_audit [ varchar] 
SELECT DISTINCT course.department, course.name, course.number, program_course.workload, program_course.workload FROM course, program_course WHERE program_course.category LIKE '%PreMajor%' 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 '%PreMajor%')