~/ 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/098c0936-de00-4cb8-bca7-91d26a30aa91/flashcard utf-8 LF