题解 | 商品销售排名

SELECT 
    pi.product_name,
    CAST(SUM(pi.price) AS SIGNED) total_sales
FROM user_client_log ucl
JOIN product_info pi ON pi.product_id = ucl.product_id
WHERE LENGTH(ucl.pay_method) <> 0
GROUP BY pi.product_name
ORDER BY total_sales DESC