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

select product_id,
product_name,
total_sales_amount,
total_sales_quantity
from (
    select product_id,
    product_name,
    sum(sales_amount) total_sales_amount,
    sum(sales_quantity) total_sales_quantity,
    dense_rank() over (order by sum(sales_quantity) desc) rk
    from products p
    join sales_records s using (product_id)
    group by p.product_id
) t
where rk=1
order by product_id