select product_name, cast(sum(price) as signed) as price from user_client_log l inner join product_info p on l.product_id= p.product_id where step= 'select' and pay_method is not null group by product_name order by 2 desc limit 2
神一般的题目。。。靠猜是伐
select product_name, cast(sum(price) as signed) as price from user_client_log l inner join product_info p on l.product_id= p.product_id where step= 'select' and pay_method is not null group by product_name order by 2 desc limit 2
神一般的题目。。。靠猜是伐