SQL query to find students with no assigned teacher
Filed under Arcesium
The question
Given a Student table with enrolled subjects and a Teacher table with assigned subjects, write a SQL query to find the names of students who have no teacher assigned for their enrolled subjects.
No write-up yet. Related questions below have one.
Related Arcesium questions
Collected from public candidate posts and coding forums. Updated Nov 2026.