Question

Which SQL query would return the top three departments

Q: Answer-Which SQL query would return the top three departments with the highest total salaries from an emplo...

Explanation The correct query uses SQLs GROUP BY to aggregate data by department , calculates the sum of salary for each department using SUMsalary , and orders the results in descending order with ORDER BY . Finally, the LIMIT 3 clause retrieves only the top three departments. This approach is efficient and aligns with database query standards, ensuring the highest salaries are calculated accurately and in rank order. Option B MAXsalary cannot be used without a GROUP BY clause for the entire table, and the syntax is incorrect. Option C COUNTsalary measures frequency, not total salary. Option D DISTINCT eliminates duplicates but does not aggregate data for rankings. Option E MAXsalary sorts by individual highest salaries, not aggregated totals, leading to incorrect results.

with the highest total salaries from an employees table with columns department , salary , and employee_id ?

A SELECT department, SUM(salary) FROM employees GROUPBY department ORDERBYSUM(salary) DESC LIMIT 3;

B .SELECT department, salary FROM employees WHERE salary =MAX(salary) GROUPBY department LIMIT 3;

C SELECT department, COUNT(salary) FROM employees GROUPBY department HAVINGCOUNT(salary) >3;

D SELECTDISTINCT department, salary FROM employees ORDERBY salary DESC LIMIT 3;

E SELECTdepartment FROM employees GROUPBY department ORDERBYMAX(salary) DESC LIMIT 3;

Practice Next

Which SQL query would return the top three departments

Solution