What is all the information about the courses in the Psychology department, ordered by title?
select * from course where dept_name = 'Psychology' order by title
What are the building, room number, semester and year corresponding to these courses?
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