题解 | 商品销售排名

select
    p.product_name,
    count(1) * p.price as money
from
    user_client_log u,
    product_info p
where
    u.product_id = p.product_id
    and u.step = 'select'
group by
    u.product_id
order by
    money desc