🔮 Output PredictionSQ SQL Hard+35 XP
GROUP BY with HAVING
What does this query do?
SQL
SELECT department, AVG(salary) AS avg_sal FROM employees GROUP BY department HAVING AVG(salary) > 50000 ORDER BY avg_sal DESC;
What does this query do?
SELECT department, AVG(salary) AS avg_sal FROM employees GROUP BY department HAVING AVG(salary) > 50000 ORDER BY avg_sal DESC;