题解 | 商品销售总额分布
商品销售总额分布
https://www.nowcoder.com/practice/62909494cecd4eab8c2501167e825566
select case when u.pay_method='' then 'error' else u.pay_method end as pay_method,count(distinct u.trace_id) as rk from user_client_log u join product_info p on u.product_id=p.product_id where u.step='select' and p.product_name='anta' group by u.pay_method order by rk desc
查看17道真题和解析