[Solved] Which SQL statement correctly groups rows by the category column in the products table? — Ans: SELECT category, COUNT(*) FROM products GROUP BY category; | SQL

SQL - GROUP BY and HAVING

Which SQL statement correctly groups rows by the category column in the products table?

ASELECT category, COUNT(*) FROM products ORDER BY category;

BSELECT category, COUNT(*) FROM products GROUP BY category;

CSELECT category, COUNT(*) FROM products WHERE category GROUP BY category;

DSELECT category, COUNT(*) FROM products HAVING category;

Step-by-Step Solution

Solution:

Step 1: Identify GROUP BY syntax
The correct syntax to group rows is to use GROUP BY column_name after the FROM clause.
Step 2: Analyze options
SELECT category, COUNT(*) FROM products GROUP BY category; uses GROUP BY category correctly. Options B, C, and D misuse ORDER BY, WHERE, or HAVING clauses.
Final Answer:
SELECT category, COUNT(*) FROM products GROUP BY category; -> Option B
Quick Check:
GROUP BY follows FROM and precedes HAVING/ORDER BY [OK]

Quick Trick: GROUP BY follows FROM, not WHERE or HAVING [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which SQL statement correctly groups rows by the category column in the products table?