Task: Text to Code
Input (English): Step 1: For each row in course table, find the corresponding rows in section table.
Step 2: find the  building in the results of step 1 whose dept_name equals Psychology ordered ascending by title
Output (English): SELECT T2.building , T2.room_number , 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 Asc