CREATE TABLE SECTION (building VARCHAR, room_number VARCHAR, semester VARCHAR, year VARCHAR, course_id VARCHAR)
CREATE TABLE course (course_id VARCHAR, dept_name VARCHAR, title VARCHAR)

Find the building, room number, semester and year of all courses offered by Psychology department sorted by course titles.
SELECT T2.building, T2.room_number, T2.semester, T2.year FROM course AS T1 JOIN SECTION AS T2 ON T1.course_id = T2.course_id WHERE T1.dept_name = 'Psychology' ORDER BY T1.title
SELECT "T2"."building", "T2"."room_number", "T2"."semester", "T2"."year" FROM "course" AS "T1" JOIN "SECTION" AS "T2" ON "T1"."course_id" = "T2"."course_id" WHERE "T1"."dept_name" = 'Psychology' ORDER BY "T1"."title" NULLS FIRST