with a as ( select t2.product_name product_name ,t2.price price ,count(*) cnt from user_client_log t1 join product_info t2 on t1.product_id = t2.product_id where t1.step = 'select' and t1.pay_method != '' group by 1,2 ) select product_name ,price*cnt total from a order by 2 desc limit 2

京公网安备 11010502036488号