题解 | 商品销售排名
select
p.product_name,
count(1) * p.price as money
from
user_client_log u,
product_info p
where
u.product_id = p.product_id
and u.step = 'select'
group by
u.product_id
order by
money desc
select
p.product_name,
count(1) * p.price as money
from
user_client_log u,
product_info p
where
u.product_id = p.product_id
and u.step = 'select'
group by
u.product_id
order by
money desc
相关推荐