~/ learn/ comp-378/ cards/ Set Operations: UNION, INTERSECT & EXCEPT (MINUS)
1 of 5

Type the INTERSECT skeleton (two union-compatible SELECTs):

Type the INTERSECT skeleton (two union-compatible SELECTs):

Answer

SELECT student_id FROM registrations WHERE section_id = 2711 INTERSECT SELECT student_id FROM registrations WHERE section_id = 2712;

Each SELECT returns one student_id column (union-compatible); INTERSECT keeps ids present in both result sets — students in both sections.

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/b10d170c-e17a-4ada-9bba-dc2e8ff91f1f/flashcard utf-8 LF