My Blog

Filtering Aggregated Data with HAVING:

—

by

Awais Farooq
in 
sqlSELECT department_id, AVG(salary) AS avg_salary
FROM employees
GROUP BY department_id
HAVING AVG(salary) > 50000;

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *