JavaScript is required for SkillDojo AI to work properly. Please enable JavaScript and refresh the page.

Headcount per Department | Algorithm

EasyjoinsSQL

Headcount per Department

Return each department name and the number of employees in it. Departments with no employees should appear with a count of 0.

Expected output

First 3 of 4 rows your query should return. Your column aliases don't need to match.

SQLite · Ctrl+Enter to run

Run your query to see results here.