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

select product_id
,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
    /*这里千万不能限制窗口范围，否则每个product_id对于自己的product_id排名都是1！！！又犯低级错误！！！*/
    ,rank() over(order by sum(sales_quantity) desc) as rk
    from sales_records
    where year(sales_date) = 2024
    group by product_id
) t
join products using(product_id)
where rk = 1
order by product_id