Set Operations

!! Set Union

(:source lang=sql:)[@ SELECT student_id FROM sports UNION SELECT student_id FROM clubs; @]

!! Set Intersection

(:source lang=sql:)[@ SELECT student_id FROM sports INTERSECT SELECT student_id FROM clubs; @]

!! Set Difference

(:source lang=sql:)[@ SELECT student_id FROM student EXCEPT SELECT student_id FROM sports; @]

!! Set Comparison