Exercise: All Courses
Get all courses including duplicates.
Solution
sql
1SELECT course FROM students
2UNION ALL
3SELECT course FROM teachers;
Get all courses including duplicates.
1SELECT course FROM students
2UNION ALL
3SELECT course FROM teachers;