[Solved] Find the issue in this query:SELECT department, SUM(CASE WHEN salary > 40000 THEN salary ELSE 0 END) AS total_salary FROM employees GROUP BY department HAVING total_salary > 100000; | SQL

SQL - CASE Expressions

Find the issue in this query:

SELECT department, SUM(CASE WHEN salary > 40000 THEN salary ELSE 0 END) AS total_salary FROM employees GROUP BY department HAVING total_salary > 100000;

AELSE 0 should be ELSE NULL

BSUM cannot be used with CASE

CAlias total_salary cannot be used in HAVING clause directly

DGROUP BY is missing department column

Step-by-Step Solution

Solution:

Step 1: Understand HAVING clause usage
HAVING filters groups but cannot use column aliases directly in many SQL dialects.
Step 2: Identify correct HAVING usage
Must repeat the aggregate expression or use a subquery to filter by total_salary.
Final Answer:
Alias total_salary cannot be used in HAVING clause directly -> Option C
Quick Check:
HAVING needs full expression or subquery [OK]

Quick Trick: Use full aggregate in HAVING, not alias [OK]

Common Mistakes:

Using alias in HAVING directly
Thinking SUM disallows CASE
Confusing ELSE 0 with ELSE NULL

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Find the issue in this query:

Step 1: Understand HAVING clause usage

Step 2: Identify correct HAVING usage

Final Answer:

Quick Check:

Want More Practice?