EasyOutput prediction
LEFT JOIN keeps all left rows
Given these tables:
employees:
| id | name | dept_id |
|---|---|---|
| 1 | Alice | 10 |
| 2 | Bob | NULL |
departments:
| id | name |
|---|---|
| 10 | Sales |
What does this query return?
SELECT e.name, d.name AS dept FROM employees e LEFT JOIN departments d ON e.dept_id = d.id;
← → arrow keys to navigate
Sign in to save your progress.