SQL - GROUP BY and HAVING
Which of the following SQL queries correctly groups data by the column
category?Which of the following SQL queries correctly groups data by the column category?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Check correct GROUP BY syntax
The GROUP BY clause must follow the FROM clause and group by the specified column.Step 2: Validate each option
SELECT category, COUNT(*) FROM products GROUP BY category; uses GROUP BY correctly; others use ORDER BY, WHERE, HAVING incorrectly for grouping.Final Answer:
SELECT category, COUNT(*) FROM products GROUP BY category; -> Option BQuick Check:
Correct GROUP BY syntax = SELECT category, COUNT(*) FROM products GROUP BY category; [OK]
Quick Trick: GROUP BY follows FROM and groups by column [OK]
Common Mistakes:
MISTAKES- Using ORDER BY instead of GROUP BY
- Using WHERE to group data
- Using HAVING without GROUP BY
Master "GROUP BY and HAVING" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes