Solution:Step 1: Understand LEFT JOIN with NULL filterLEFT JOIN keeps all students; WHERE Enrollments.course IS NULL filters those without matching enrollments.Step 2: Interpret resultThe query returns students who have no courses enrolled.Final Answer:Students who are not enrolled in any course ->

[Solved] Consider tables:Students(id, name)Enrollments(student_id, course)What does this query return?SELECT Students.name FROM Students LEFT JOIN Enrollments ON Students.id = Enrollments.... | SQL

SQL - Table Relationships

Consider tables:
Students(id, name)
Enrollments(student_id, course)
What does this query return?

SELECT Students.name FROM Students LEFT JOIN Enrollments ON Students.id = Enrollments.student_id WHERE Enrollments.course IS NULL;

AStudents enrolled in at least one course

BError due to incorrect JOIN syntax

CAll students with their courses

DStudents who are not enrolled in any course

Step-by-Step Solution

Solution:

Step 1: Understand LEFT JOIN with NULL filter
LEFT JOIN keeps all students; WHERE Enrollments.course IS NULL filters those without matching enrollments.
Step 2: Interpret result
The query returns students who have no courses enrolled.
Final Answer:
Students who are not enrolled in any course -> Option D
Quick Check:
LEFT JOIN + NULL filter = unmatched rows [OK]

Quick Trick: LEFT JOIN with NULL filter finds unmatched rows [OK]

Common Mistakes:

MISTAKES

Confusing LEFT JOIN with INNER JOIN
Ignoring NULL filter effect

Master "Table Relationships" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Consider tables:

Step 1: Understand LEFT JOIN with NULL filter

Step 2: Interpret result

Final Answer:

Quick Check:

Want More Practice?