Getting everything ready for you…

Loading courses, problems and your progress. This takes just a moment.

0s

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