题解 | 商品销售总额分布
select
if (pay_method = '', 'error', pay_method),
count(*) 数量
from
test.user_client_log ucl
join test.product_info pi on ucl.product_id = pi.product_id
where
product_name = 'anta'
and step = 'select'
group by
pay_method
order by
数量 desc
