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

with temp as (
    select
    p.product_id,
    p.product_name,
    sum(sr.sales_amount) as total_sales_amount,
    sum(sales_quantity) as total_sales_quantity,
    rank() over(order by sum(sr.sales_quantity) desc) as rnk
    from sales_records sr
    inner join products p 
    on p.product_id = sr.product_id
    where year(sr.sales_date) = 2024
    group by 
        p.product_id,
        p.product_name
)
select 
    product_id,
    product_name,
    total_sales_amount,
    total_sales_quantity
from temp
where rnk = 1
order by 
    product_id asc;