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



京公网安备 11010502036488号