Enrolled Both Years

Easysql

Write a query returning every student_id enrolled in BOTH 2025 and 2026, ordered ascending.

sql
CREATE TABLE enrolled_2025 (student_id INTEGER NOT NULL);
CREATE TABLE enrolled_2026 (student_id INTEGER NOT NULL);

Sample data:

sql
INSERT INTO enrolled_2025 (student_id) VALUES (1), (2), (3), (4);
INSERT INTO enrolled_2026 (student_id) VALUES (2), (3), (5);

Example 1

Input

(none)

Output

student_id
2
3

INTERSECT returns only rows present in both queries. Reference: SELECT student_id FROM enrolled_2025 INTERSECT SELECT student_id FROM enrolled_2026 ORDER BY student_id;

Enrolled Both Years

Related Problems

Input (stdin)

Output