CREATE TABLE course (title VARCHAR2, course_id VARCHAR2)
CREATE TABLE instructor (name VARCHAR2, id VARCHAR2)
CREATE TABLE teaches (course_id VARCHAR2, id VARCHAR2)

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
SELECT "T1"."title", "T3"."name" FROM "course" "T1" JOIN "teaches" "T2" ON "T1"."course_id" = "T2"."course_id" JOIN "instructor" "T3" ON "T2"."id" = "T3"."id" WHERE "YEAR" = 2008 ORDER BY "T1"."title"