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