SQL - GROUP BY and HAVING
Which of the following is the correct syntax to group rows by the column
department?Which of the following is the correct syntax to group rows by the column department?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Identify correct GROUP BY usage
The GROUP BY clause must follow the FROM clause and specify the column to group by, here 'department'.Step 2: Check each option's syntax
SELECT department, COUNT(*) FROM employees GROUP BY department; uses GROUP BY correctly. SELECT department, COUNT(*) FROM employees ORDER BY department; uses ORDER BY which sorts, not groups. SELECT department, COUNT(*) FROM employees WHERE department; uses WHERE incorrectly. SELECT department, COUNT(*) FROM employees HAVING department; uses HAVING without GROUP BY, which is invalid.Final Answer:
SELECT department, COUNT(*) FROM employees GROUP BY department; -> Option CQuick Check:
GROUP BY syntax: SELECT ... FROM ... GROUP BY column [OK]
Quick Trick: GROUP BY follows FROM and lists columns to group by [OK]
Common Mistakes:
MISTAKES- Using ORDER BY instead of GROUP BY
- Using WHERE to group rows
- 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