Initializing SQL database...
Back to Questions
Group by Category with Average #83
mediumCalculate average for each category. You may need to use GROUP BY to calculate aggregates for different groups of data. Remember that when using GROUP BY, all non-aggregate columns in SELECT must be in the GROUP BY clause.
Practice with:
Database Schema
products
Product information
idnamecategoryvalue
Expected Output
Click "Show" to see what the correct output should look like.Tip: Try solving it yourself first for better learning!
SQL Editor
Loading...
Press Ctrl+Enter to run query • Start typing for autocomplete