题解 | 商品销售总额分布
商品销售总额分布
https://www.nowcoder.com/practice/62909494cecd4eab8c2501167e825566
select if(pay_method != "",pay_method,"error"),count(*) num
from user_client_log ucl
where product_id = (select product_id from product_info
where product_name = "anta")
and step = "select"
group by pay_method
order by num desc
注意不是null而是空字符串
