题解 | 商品销售排名
select product_name, cast(sum(price) as signed) as pricefrom user_client_log a join product_info b on a.product_id=b.product_idwhere step='select'group by a.product_id, product_nameorder by sum(price) desclimit 2
select product_name, cast(sum(price) as signed) as pricefrom user_client_log a join product_info b on a.product_id=b.product_idwhere step='select'group by a.product_id, product_nameorder by sum(price) desclimit 2
相关推荐