select t1.name Name, t1.m1 Money1, t2.m2 Money2, t1.m1-t2.m2 Poor, (t1.m1-t2.m2)/t1.m1 Poor2 from (select name, sum(money1) m1 from tablename where type = '1' group by name) t1, (select name, sum(money2) m2 from tablename where type = '2' group by name) t2 where t1.name = t2.name
from
(select name, sum(money1) m1
from tablename
where type = '1'
group by name) t1,
(select name, sum(money2) m2
from tablename
where type = '2'
group by name) t2
where t1.name = t2.name