SELECT title FROM course WHERE dept_name  =  'Statistics' INTERSECT SELECT title FROM course WHERE dept_name  =  'Psychology'
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 '
select title from course where dept_name = value intersect select title from course where dept_name = value
What is the title of a course that is listed in both the Statistics and Psychology departments ?