list in alphabetic order all course names and their instructors' names in year 2008.
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
list in alphabetic order = ORDER BY column ASC (by default, ORDER BY is ascending); course names = T1.title; instructors' names = T3.name; in year 2008 = WHERE YEAR = 2008; JOIN used for combining rows from two or more tables based on a related column between them.