โ† Arcesium questions

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.