题解 | 商品销售排名
商品销售排名
https://www.nowcoder.com/practice/79c6c3d6d66946f79387bca73c0a29f4
select p.product_name, p.price*count(p.product_name) as total_sales from user_client_log u left join product_info p on u.product_id=p.product_id where pay_method <>'' group by p.product_name,p.price order by total_sales desc limit 2