题解 | 商品销售总额分布
商品销售总额分布
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而是空字符串