Simple Aggregation

SELECT Sum(price * quantity)

FROM Purchase

SELECT Sum(price * quantity)

FROM Purchase

WHERE product = ‘bagel’

SQL supports several aggregation operations:

SUM, MIN, MAX, AVG, COUNT

Except COUNT, all aggregations apply to a single attribute

Previous slide

Next slide

Back to first slide

View graphic version