ฤดูใบไม้ผลิ-ฤดูร้อนนี้จะมีชั้นเรียน LAW ใดบ้าง ?ไม่จำเป็นต้องใช้ทุกตาราง
What are the LAW classes that will be available this Spring-Summer ?It is not neccessary to use all the tables.
 semester:  semester_id [ int]  semester [ varchar]  year [ int] 
SELECT DISTINCT course.department, course.name, course.number FROM course, course_offering, program_course, semester WHERE course.course_id = course_offering.course_id AND course.department = 'LAW' AND program_course.category LIKE '%ULCS%' AND program_course.course_id = course.course_id AND semester.semester = 'Spring-Summer' AND semester.semester_id = course_offering.semester AND semester.year = 2016