[Solved] Find the mistake in this query:SELECT product, SUM(quantity) FROM sales HAVING SUM(quantity) > 100; — Ans: Missing GROUP BY clause when using HAVING | SQL

SQL - GROUP BY and HAVING

Find the mistake in this query:

SELECT product, SUM(quantity) FROM sales HAVING SUM(quantity) > 100;

AHAVING cannot be used without WHERE

BNo mistake, query is valid

CSUM(quantity) cannot be used in HAVING

DMissing GROUP BY clause when using HAVING

Step-by-Step Solution

Solution:

Step 1: HAVING filters groups after GROUP BY
HAVING requires groups to filter, so GROUP BY must be present.
Step 2: Query lacks GROUP BY, so HAVING causes error
Without GROUP BY, HAVING cannot filter groups.
Final Answer:
Missing GROUP BY clause when using HAVING -> Option D
Quick Check:
HAVING needs GROUP BY to filter groups [OK]

Quick Trick: HAVING requires GROUP BY clause [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the mistake in this query: