C4
Coding 4 Bread
News
Careers
Certifications
Playground
More
Sign in
Get started
SQL Mastery
SQL Fundamentals — Quiz 1
Question 1 of 60
medium
AI explanations
You have a table 'Products' with columns 'category' and 'price'. How do you find the average price for each category?
A
SELECT AVG(price) FROM Products GROUP BY category
B
SELECT category, AVG(price) FROM Products WHERE category IS NOT NULL GROUP BY category
C
SELECT category, AVG(price) FROM Products GROUP BY category HAVING AVG(price) > 100
D
SELECT category, price FROM Products ORDER BY category
Previous
Check answer