题解 | 哪些产品在特定时间段内表现最为出色
哪些产品在特定时间段内表现最为出色
https://www.nowcoder.com/practice/866a4614615b43a29750537ede4bf0c8
with t1 as (
select product_id,sum(sales_amount) total_sales_amount,sum(sales_quantity) total_sales_quantity
,rank()over(order by sum(sales_quantity) desc) rk
from sales_records s
where sales_date between '2021-01-01' and '2024-12-31'
group by product_id
order by product_id
)
select t1.product_id,product_name,total_sales_amount,total_sales_quantity
from t1 join products p on t1.product_id = p.product_id
where t1.rk = 1
