Consider the following SQL query: SELECT dept, COUNT(*) FROM Employee GROUP BY dept HAVING COUNT(*) 5; What does the following SQL query return?

Question

Consider the following SQL query: 
 <SQL> 
 SELECT dept, COUNT(*)  
 FROM Employee  
 GROUP BY dept  
 HAVING COUNT(*) > 5; 
 What does the following SQL query return?

Answer

Departments with more than 5 employees

Answer

All departments

Answer

Departments with exactly 5 employees

Answer

Employees with count greater than 5

Crowdly

Consider the following SQL query: <SQL> SELECT dept, COUNT(*) FROM Employ...

Want instant access to all verified answers on moodle.nottingham.ac.uk?