题解 | 商品销售总额分布
商品销售总额分布
https://www.nowcoder.com/practice/62909494cecd4eab8c2501167e825566
select CASE WHEN u.pay_method = '' THEN 'error' ELSE u.pay_method END AS pay_method, count(*) as cnt from user_client_log u join product_info p on u.product_id = p.product_id where p.product_name = 'anta' and step = 'select' group by u.pay_method order by cnt desc
...
游卡公司福利 173人发布
