Level 2 - Question 10: Departments With More Than 2 Employees

Scenario

Management wants a list of departments that have more than 2 employees assigned.

Task

Write a SQL query using GROUP BY and HAVING that returns department_id and the COUNT of employees in each department (if count > 2).

Sample Schema

employees
emp_id employee_name department_id

Write Your SQL Answer:

Submit Answer