หลักสูตร SURVMETH 745 สุดท้ายเปิดสอนเมื่อใด ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
When was the last SURVMETH 745 course offered ?It is not neccessary to use all the tables.
 comment_instructor:  instructor_id [ int]  student_id [ int]  score [ int]  comment_text [ varchar] 
SELECT DISTINCT semester.year FROM course, course_offering, semester WHERE course.course_id = course_offering.course_id AND course.department = 'SURVMETH' AND course.number = 745 AND semester.semester_id = course_offering.semester ORDER BY semester.year DESC LIMIT 1