Exercise: Common Courses
Find courses taught by both departments.
Solution
sql
1SELECT course FROM dept_a
2INTERSECT
3SELECT course FROM dept_b;
Find courses taught by both departments.
1SELECT course FROM dept_a
2INTERSECT
3SELECT course FROM dept_b;