#395 Classes Without Students

Companies:

IdMt

Themes:

SQLJoinsPractice

Two tables, student and class, are given:

student:
id - auto-increment primary key,
class_id - id of the class in which the student is enrolled

class:
id - auto-increment primary key

Write a query that displays the ids of classes that have no students.

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.