题解 | 商品销售排名
商品销售排名
https://www.nowcoder.com/practice/79c6c3d6d66946f79387bca73c0a29f4
SELECT
product_name,
COUNT(step) * price AS total_sales
FROM user_client_log u
JOIN product_info p
ON u.product_id = p.product_id
WHERE step = 'select'
GROUP BY product_name, price
ORDER BY total_sales DESC
LIMIT 2
查看7道真题和解析