Left After 2025

Mediumsql

Write a query returning every student_id who was enrolled in 2025 but did NOT return in 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
1
4

EXCEPT returns rows in the first query that don't appear in the second — order matters. Reference: SELECT student_id FROM enrolled_2025 EXCEPT SELECT student_id FROM enrolled_2026 ORDER BY student_id;

Left After 2025

Related Problems

Input (stdin)

Output