select
topquantityid,topquantityname,topquantity,b.*
from
(select
min(od.sku_id) topquantityid,od.sku_name topquantityname,
count(*) topquantity,
rank() over(order by count(*) desc) sequence
from
dim_order_info o
join dim_order_detail od
on o.id = od.order_id
where year(o.operate_time) = '2020'
group by od.sku_name
order by topquantity desc
limit 10) a
join
(
select
min(od.sku_id) toppriceid,od.sku_name toppricename,
sum(final_total_amount) topprice,
rank() over(order by sum(final_total_amount) desc) sequence
from
dim_order_info o
join dim_order_detail od
on o.id = od.order_id
where year(o.operate_time) = '2020'
group by od.sku_name
order by topprice desc
limit 10) b
on a.sequence = b.sequence
自己瞎整搞出来了,哈哈哈 |