Prepare for your SQL interview with the question: "Filtering Groups with HAVING" (Data Analyst level).

Solve the "Filtering Groups with HAVING" SQL interview question on SQLSimplified. Access the live database playground in your browser to write and run queries, see hints, and inspect correct query solutions.

Data AnalystQuestion 26 of 57

Filtering Groups with HAVING

Problem

Find the department_id and the total number of employees in that department, but only for departments that have more than 5 employees.

Filtering Groups with HAVING

Problem

Try It

Hint

Solution

Problem

Try It

Hint

Show hint

Solution

Show solution