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

with t1 as(
select
a.product_id,
b.product_name,
sum(a.sales_amount) as total_sales_amount,
sum(a.sales_quantity) as total_sales_quantity
from sales_records a join products b on a.product_id=b.product_id
where a.sales_date between '2024-01-01' and '2024-12-31'
group by a.product_id,b.product_name),
t2 as(
select *,dense_rank() over(order by total_sales_quantity desc) as rn
from t1
)
select
product_id,
product_name,
total_sales_amount,
total_sales_quantity
from t2
where rn=1
order by total_sales_amount desc,product_id