In a SELECT with GROUP BY, the correct way to keep only groups whose a…

Question

In a SELECT with GROUP BY, the correct way to keep only groups whose average salary exceeds 50000 is

Accepted Answer

D. use HAVING AVG(salary) > 50000 after GROUP BY

HAVING is the clause that filters AFTER aggregation. WHERE filters individual rows BEFORE grouping (and aggregate functions are not allowed in WHERE for that reason). ORDER BY only sorts; DISTINCT only removes duplicate rows.

Answer

use WHERE AVG(salary) > 50000 before GROUP BY

Answer

use ORDER BY AVG(salary) > 50000

Answer

use DISTINCT to filter the groups