Aggregate with WHERE

Question

Accepted Answer

WHERE filters rows before the aggregate function runs. Only Alice's two orders (100 and 300) are included. SUM(100 + 300) = 400. Bob's order is excluded by the WHERE clause.

id	customer	amount
1	Alice	100
2	Bob	200
3	Alice	300