Database: college_2
Question: 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