SQL practice › Joins & grouping
Employee and Department
Medium · Joins & grouping
Return each employee's name together with their department name. Leave out employees who are not in any department.
Hint
An INNER JOIN drops rows without a match.
Write your query on this page — it runs against the sample company database in your browser and is checked instantly.
Next problem: Customers Who Never Ordered