CAAS 426 ได้รับการเสนอเมื่อเร็ว ๆ นี้?ไม่จำเป็นต้องใช้ตารางทั้งหมด
How recently has CAAS 426 been offered ?It is not neccessary to use all the tables.
 program:  program_id [ int]  name [ varchar]  college [ varchar]  introduction [ varchar] 
SELECT DISTINCT semester.year FROM course, course_offering, semester WHERE course.course_id = course_offering.course_id AND course.department = 'CAAS' AND course.number = 426 AND semester.semester_id = course_offering.semester ORDER BY semester.year DESC LIMIT 1