1. What does this query return?
SELECT Department, COUNT(*)
FROM Employees
GROUP BY Department
HAVING COUNT(*) 5;

Question

1. What does this query return? 
 SELECT Department, COUNT(*)   
 FROM Employees   
 GROUP BY Department   
 HAVING COUNT(*) > 5;

Answer

Departments with more than 5 employees

Answer

All departments

Answer

Departments with exactly 5 employees

Answer

Employees with more than 5 years in a department

Crowdly