[Solved] Consider the table Expenses with columns Category and Amount:Category | AmountFood | 20Travel | 50Food | 30What does this query return?SELECT Category, SUM(Amount) FROM Expenses GROUP BY Category; | SQL

SQL - Aggregate Functions

Consider the table Expenses with columns Category and Amount:

Category | Amount
Food     | 20
Travel   | 50
Food     | 30

What does this query return?
SELECT Category, SUM(Amount) FROM Expenses GROUP BY Category;

AFood 50, Travel 50

BFood 20, Travel 50

CFood 30, Travel 50

DFood 50, Travel 80

Step-by-Step Solution

Solution:

Quick Trick: GROUP BY sums per category [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Consider the table Expenses with columns Category and Amount: