-- Query 3: Total amount sold and total quantity for each shop name in 2001.

SELECT
    outlet_lookup.shop_name,
    SUM(shop_facts.amount_sold) AS total_amount_sold,
    SUM(shop_facts.quantity_sold) AS total_quantity_sold
FROM outlet_lookup
INNER JOIN shop_facts ON shop_facts.shop_code = outlet_lookup.shop_code
INNER JOIN calendar_year_lookup ON shop_facts.week_key = calendar_year_lookup.week_key
WHERE calendar_year_lookup.year = 2001
GROUP BY outlet_lookup.shop_code, calendar_year_lookup.year
ORDER BY total_amount_sold DESC;