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