题解 | 商品销售总额分布
商品销售总额分布
https://www.nowcoder.com/practice/62909494cecd4eab8c2501167e825566
SELECT
IF(`pay_method`='','error',`pay_method`) AS `sale_method`,
count(`pay_method`) AS `times`
FROM user_client_log u
JOIN product_info p ON u.`product_id`=p.`product_id`
WHERE `step`='select' AND `product_name`='anta'
GROUP BY `pay_method`
ORDER BY `times` DESC;
