题解 | 商品销售总额分布 IF()
商品销售总额分布
https://www.nowcoder.com/practice/62909494cecd4eab8c2501167e825566
SELECT IF(A.pay_method = '', 'error', A.pay_method), COUNT(*) AS cnt FROM user_client_log AS A INNER JOIN product_info AS B ON A.product_id = B.product_id WHERE A.step = 'select' AND B.product_name = 'anta' GROUP BY A.pay_method ORDER BY cnt DESC;
查看6道真题和解析
