Which of the following is the correct PostgreSQL query syntax to select department and total salary for departments where total salary exceeds 20000?

easy📝 Syntax Q3 of 15

PostgreSQL - Aggregate Functions and GROUP BY

Which of the following is the correct PostgreSQL query syntax to select department and total salary for departments where total salary exceeds 20000?

ASELECT department, SUM(salary) FROM employees WHERE SUM(salary) > 20000 GROUP BY department;

BSELECT department, SUM(salary) FROM employees HAVING SUM(salary) > 20000 GROUP BY department;

CSELECT department, SUM(salary) FROM employees GROUP BY department HAVING SUM(salary) > 20000;

DSELECT department, SUM(salary) FROM employees GROUP BY department WHERE SUM(salary) > 20000;

Step-by-Step Solution

Solution:

Step 1: GROUP BY clause
Groups rows by department.
Step 2: HAVING clause
Filters groups where SUM(salary) > 20000.
Step 3: Syntax order
HAVING must come after GROUP BY.
Final Answer:
SELECT department, SUM(salary) FROM employees GROUP BY department HAVING SUM(salary) > 20000; -> Option C
Quick Check:
HAVING follows GROUP BY [OK]

Quick Trick: HAVING always follows GROUP BY [OK]

Common Mistakes:

Placing HAVING before GROUP BY
Using WHERE with aggregate functions
Misordering clauses

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

Which of the following is the correct PostgreSQL query syntax to select department and total salary for departments where total salary exceeds 20000?

Step 1: GROUP BY clause

Step 2: HAVING clause

Step 3: Syntax order

Final Answer:

Quick Check:

Want More Practice?