select p.product_name,
count(u.product_id)*p.price as money
from user_client_log u
join product_info p
on u.product_id = p.product_id
where u.pay_method is not null
and u.step='select'
group by u.product_id
order by money desc

题目没表示要选step为select