JavaScript is required for SkillAI Hub to work properly. Please enable JavaScript and refresh the page.

List Employee Names and Departments | Algorithm

beginnerjoinsSQL

List Employee Names and Departments

Return a list of all employee names along with the name of their department. Include only employees who are assigned to a department (department_id is not NULL). Return the columns: employees.name and departments.name.

Hints & solution

unlocks after the hints, or after 2 tries

departments

idINTEGERpknameTEXT

employees

idINTEGERpknameTEXTdepartment_idINTEGER→departments.idnullmanager_idINTEGER→employees.idnullsalaryINTEGERhired_onTEXT

id	name	department_id	manager_id	salary	hired_on
1	Ana Reyes	1	NULL	150000	2018-03-01
2	Ben Cho	1	1	120000	2019-06-15
3	Cara Diaz	1	1	120000	2020-01-20
4	Dan Ellis	2	NULL	140000	2017-11-05
5	Eve Fox	2	4	95000	2021-02-10

SQLite⌘/Ctrl+Enter to run

Run your query to see results here.