CREATE TABLE SECTION (building VARCHAR(255), room_number VARCHAR(255), semester VARCHAR(255), year VARCHAR(255), course_id VARCHAR(255)); CREATE TABLE course (course_id VARCHAR(255), dept_name VARCHAR(255), title VARCHAR(255))
Find the building, room number, semester and year of all courses offered by Psychology department sorted by course titles.
    
SQL: 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