EasyOutput prediction
INNER JOIN basics
Given these tables:
employees:
| id | name | dept_id |
|---|---|---|
| 1 | Alice | 10 |
| 2 | Bob | 20 |
| 3 | Carol | NULL |
departments:
| id | name |
|---|---|
| 10 | Sales |
| 20 | Eng |
| 30 | HR |
What does this query return?
SELECT e.name, d.name AS dept FROM employees e INNER JOIN departments d ON e.dept_id = d.id;
← → arrow keys to navigate
Sign in to save your progress.