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

Departments With More Than Two Employees | Algorithm

intermediateaggregationSQL

Departments With More Than Two Employees

Return the names of departments that have more than two employees.

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.