What is the title of a course that is listed in both the Statistics and Psychology departments?
SELECT title FROM course WHERE dept_name  =  'Statistics' INTERSECT SELECT title FROM course WHERE dept_name  =  'Psychology'
course listed in both departments refers to using INTERSECT between selections from each department; title of the course refers to SELECT title;