题解 | 哪些产品在特定时间段内表现最为出色
哪些产品在特定时间段内表现最为出色
https://www.nowcoder.com/practice/866a4614615b43a29750537ede4bf0c8
SELECT `product_id`, `product_name`, `total_sales_amount`, `total_sales_quantity` FROM (SELECT p.`product_id`, `product_name`, sum(`sales_amount`) AS `total_sales_amount`, sum(`sales_quantity`) AS `total_sales_quantity`, RANK() OVER(ORDER BY sum(`sales_quantity`) DESC) AS `rank` FROM sales_records s JOIN products p ON p.`product_id`=s.`product_id` WHERE `sales_date` BETWEEN '2024-01-01' AND '2024-12-31' GROUP BY s.`product_id`,`product_name`) a WHERE a.`rank`<=1 ORDER BY a.`product_id`;
查看18道真题和解析
