with
t1 as(
select
product_name,
sum(price) as total
from
user_client_log left join product_info using(product_id)
where
step='select'
group by
product_id
order by
total desc
)
select
product_name,
convert(total,signed)
from
t1

京公网安备 11010502036488号