题解 | 商品销售排名
商品销售排名
https://www.nowcoder.com/practice/79c6c3d6d66946f79387bca73c0a29f4
select
p.product_name,
cast(sum(p.price) as unsigned) as total
from
user_client_log uc
left join product_info p on uc.product_id = p.product_id
where
uc.step = 'select'
and uc.pay_method is not null
group by
product_name
order by
total desc,
product_name desc
limit
2;
没看出过滤条件
投递字节跳动等公司7个岗位