Aggregation Functions

SUM
COUNT
AVG
MIN
MAX

SELECT
    city,
    COUNT(*) AS total_orders,
    SUM(amount) AS revenue,
    AVG(amount) AS avg_order_value,
    MAX(amount) AS max_order
FROM orders
GROUP BY city;