Код IT
← Каталог

SQL для аналитики — Ранжирование продаж по регионам

Фрагмент из «SQL для аналитики»: Ранжирование продаж по регионам.

sql projectencyclopedia7-04-analitika-1122 embed URL статья в энциклопедии
SQL main.sql 
SELECT
    sale_date,
    region,
    amount,
    ROW_NUMBER() OVER (
        PARTITION BY sale_date, region
        ORDER BY amount DESC
    ) AS row_num,
    RANK() OVER (
        PARTITION BY sale_date, region
        ORDER BY amount DESC
    ) AS rank_pos
FROM sales
WHERE sale_date = CURRENT_DATE - 5
ORDER BY region, amount DESC;
SELECT
    sale_date,
    region,
    amount,
    ROW_NUMBER() OVER (
        PARTITION BY sale_date, region
        ORDER BY amount DESC
    ) AS row_num,
    RANK() OVER (
        PARTITION BY sale_date, region
        ORDER BY amount DESC
    ) AS rank_pos
FROM sales
WHERE sale_date = CURRENT_DATE - 5
ORDER BY region, amount DESC;