题解 | 商品销售排名
商品销售排名
https://www.nowcoder.com/practice/79c6c3d6d66946f79387bca73c0a29f4
select product_name, cast(sum(price) as signed) sales from user_client_log join product_info using(product_id) where step = 'select' and pay_method is not null group by product_id order by sales desc limit 2
查看13道真题和解析
