题解 | 商品销售排名
select p.product_name, count(1) * p.price as money from user_client_log u, product_info p where u.product_id = p.product_id and u.step = 'select' group by u.product_id order by money desc
select p.product_name, count(1) * p.price as money from user_client_log u, product_info p where u.product_id = p.product_id and u.step = 'select' group by u.product_id order by money desc
相关推荐