题解 | 商品销售总额分布
商品销售总额分布
https://www.nowcoder.com/practice/62909494cecd4eab8c2501167e825566
select
case
when pay_method = '' then 'error'
else pay_method
end as pm,
count(1) cnt
from
user_client_log u
left join product_info p on u.product_id = p.product_id
where
product_name = 'anta'
and step = 'select'
group by
pm
