题解 | 商品销售总额分布
商品销售总额分布
https://www.nowcoder.com/practice/62909494cecd4eab8c2501167e825566
select
case when u.pay_method = '' then 'error' else u.pay_method end as pay_method,
count(*) as num
from user_client_log u
inner join product_info pi
on pi.product_id = u.product_id
where pi.product_name = 'anta' and step = 'select'
group by u.pay_method
order by num desc
查看18道真题和解析