Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Nested aggregates such as MAX(AVG(salary)) are not allowed in PostgreSQL. What should you do instead?
MAX(AVG(salary))
Use a subquery.
Use HAVING instead of WHERE.
HAVING
WHERE
Add DISTINCT inside the inner aggregate.
DISTINCT
Place both aggregates in the GROUP BY clause.
GROUP BY
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!