instruction: THEORY 249 , when was it last offered ?
response: SELECT DISTINCT semester.year FROM course, course_offering, semester WHERE course.course_id = course_offering.course_id AND course.department = 'THEORY' AND course.number = 249 AND semester.semester_id = course_offering.semester ORDER BY semester.year DESC LIMIT 1