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

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 
    left join sales_records s on p.product_id=s.product_id
    where sales_date between '2024-01-01' and '2024-12-31'
    group by p.product_id, product_name
    order by p.product_id
) sub
where rk = 1