题解 | 商品销售排名
商品销售排名
https://www.nowcoder.com/practice/79c6c3d6d66946f79387bca73c0a29f4
select t2.product_name ,count(*) * t2.price total from user_client_log t1 left join product_info t2 on t1.product_id = t2.product_id where t1.pay_method != "" group by t1.product_id ,t2.product_name order by total desc
查看13道真题和解析