GROUP BY Category Process
SELECT Category, SUM(Amount) as Total
FROM Sales
GROUP BY Category;
Fruit Group
Apple - $5.00
Banana - $3.00
Orange - $4.00
Total: $12.00
Vegetable Group
Carrot - $2.00
Celery - $1.50
Total: $3.50
Result
Category
Total
Fruit
12.00
Vegetable
3.50