select product_name,p from
(select user_client_log.product_id
,product_name
, count(*) *price p
from user_client_log
left join product_info
on user_client_log.product_id = product_info.product_id
where step = 'select'
group by 1,2
order by 3 desc)a