75
Simple Aggregation
Purchase(product, date, price, quantity)
Example 1:
find total sales for the entire database
SELECT
Sum(price * quantity)
FROM
Purchase
Example 1’:
find total sales of bagels
SELECT
Sum(price * quantity)
FROM
Purchase
WHERE
product = ‘bagel’