SQL求和排序

select
    *
from
    T2
order by (select sum(Col2) from T1 where Col1=t2.Col1) desc