Multiple Aggregations with GROUP BY SELECT Category, COUNT(*) as Count, AVG(Amount) as AvgPrice FROM Sales Category Fruit (3) Vegetable (2) Count 3 2 AvgPrice $4.00 $1.75 Multiple aggregation functions can be used with a single GROUP BY clause