题解 | 哪些产品在特定时间段内表现最为出色

select
   product_id,
    product_name,
    total_sales_amount,
    total_sales_quantity
from
    (
        select
            p.product_id,
            product_name,
            sum(sales_amount) total_sales_amount,
            sum(sales_quantity) total_sales_quantity,
            rank() over (
                order by
                    sum(sales_quantity) desc
            ) rk
        from
            products p
            join sales_records s on p.product_id = s.product_id
        where
            sales_date between '2024-01-01' and '2024-12-31'
        group by
           1,
            2
    ) a
where
    rk = 1
order by
    1;