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

select
    t.product_id
    ,p.product_name
    ,total_sales_amount
    ,total_sales_quantity
from (
    select
        product_id
        ,sum(sales_amount) as total_sales_amount
        ,sum(sales_quantity) as total_sales_quantity
        ,dense_rank() over(order by sum(sales_quantity) desc)  as rk
    from sales_records
    where year(sales_date) = '2024'
    group by product_id
) t
left join products p
on t.product_id = p.product_id
where rk = 1
order by 1
;