คลาส PreMajor คือ ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
The PreMajor classes are ?It is not neccessary to use all the tables.
 ta:  campus_job_id [ int]  student_id [ int]  location [ varchar] 
SELECT DISTINCT course.department, course.name, course.number FROM course, program, program_course WHERE program_course.category LIKE '%PreMajor%' AND program_course.course_id = course.course_id AND program.name LIKE '%CS-LSA%' AND program.program_id = program_course.program_id