All Students Including Those Not Enrolled
Easy
joins
LinkedIn
Google
Airbnb
Return every student's name and the course_id they are enrolled in. Students with no enrollment should appear with NULL for course_id.
Expected Output
| student_name | course_id |
|---|---|
| Alice | 101 |
| Alice | 102 |
| Bob | 101 |
| Carol | NULL |
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...