题解 | 商品销售排名
商品销售排名
https://www.nowcoder.com/practice/79c6c3d6d66946f79387bca73c0a29f4
select
b.product_name,
cast(sum(b.price) as signed) as total
from
user_client_log a
left join product_info b using (product_id)
where
a.step = 'select'
and a.pay_method is not null
group by
b.product_name
order by
total desc
limit
2
阿里云工作强度 360人发布
投递荣耀等公司10个岗位