ฉันต้องการคลาส ACC แบบง่าย ไม่จำเป็นต้องใช้ตารางทั้งหมด
An easy ACC class is what I need .It is not neccessary to use all the tables.
 student:  student_id [ int]  lastname [ varchar]  firstname [ varchar]  program_id [ int]  declare_major [ varchar]  total_credit [ int]  total_gpa [ float]  entered_as [ varchar]  admit_term [ int]  predicted_graduation_semester [ int]  degree [ varchar]  minor [ varchar]  internship [ varchar] 
SELECT DISTINCT course.name, course.number, program_course.workload FROM course, program_course WHERE course.department LIKE '%ACC%' AND program_course.course_id = course.course_id AND program_course.workload < 3