What are the titles of Statistics courses?
select title from course where dept_name = 'Statistics'
Of these, which are also listed as Psychology courses?
select title from course where dept_name = 'Statistics' intersect select title from course where dept_name = 'Psychology'