Reported in a candidate post, Sep 2019
Find the Number of Employees in Each Department
Filed under OYO
The question
Given an employee table and a department table, write an SQL query using joins to find the count of employees in each department.
No write-up yet. Related questions below have one.
Related OYO questions
Collected from public candidate posts and coding forums. Updated Nov 2026.