HAVING without GROUP BY

Question

Accepted Answer

HAVING is valid without GROUP BY - the entire table is treated as a single group. AVG(salary) = (80000+90000+70000)/3 = 80000. Since 80000 > 75000, the HAVING condition passes and the single-row result is returned. If the average were below 75000, the query would return 0 rows.