Question

Consider the given SQL Query:

SELECT department, COUNT(*) FROM employees HAVING COUNT(*) > 5 GROUP BY department;

Saanvi is executing the query but not getting the correct output. Write the correction.

Answer 1

SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 5;