Display departments where the total salary of all employees is greater than 20000 . Identity the correct query?

Question

Display departments where the  total salary  of all employees is  greater than 20000 . Identity the correct query?

Answer

SELECT department_id, SUM(salary) AS Total_Salary 
 FROM employees 
 HAVING SUM(salary) > 20000 
 GROUP BY department_id;

Answer

SELECT department_id, TOTAL(salary)  
 FROM employees 
 GROUP BY department_id 
 HAVING TOTAL(salary) > 20000;

Answer

SELECT department_id, SUM AS  Total_Salary 
 FROM employees 
 GROUP BY department_id 
 HAVING SUM(salary) > 20000;

Answer

SELECT department_id, SUM(salary) AS Total_Salary 
 FROM employees 
 GROUP BY department_id 
 HAVING SUM(salary) > 20000;

Crowdly