题解 | 商品销售总额分布
商品销售总额分布
https://www.nowcoder.com/practice/62909494cecd4eab8c2501167e825566
select pay_method,
count(*) as cnt
from(
select if(pay_method ='','error',pay_method)pay_method
from user_client_log
join product_info using(product_id)
where step = 'select'
and pay_method is not null
and product_name = 'anta'
)a
group by pay_method
order by cnt desc
从0开始的SQL之旅 文章被收录于专栏
从0开始的SQL之旅
查看6道真题和解析