What were all the course titles in 2008?
select t1.title from course as t1 join teaches as t2 on t1.course_id = t2.course_id where year = 2008
Also, what were the instructors' names?
select t1.title, t3.name from course as t1 join teaches as t2 on t1.course_id = t2.course_id join instructor as t3 on t2.id = t3.id where year = 2008
Order this by title.
select t1.title, t3.name from course as t1 join teaches as t2 on t1.course_id = t2.course_id join instructor as t3 on t2.id = t3.id where year = 2008 order by t1.title