instruction: Find the number of courses offered by Psychology department in each semester with a pie chart.
response: SELECT semester, COUNT(semester) FROM course AS T1 JOIN section AS T2 ON T1.course_id = T2.course_id WHERE T1.dept_name = 'Psychology' GROUP BY semester