select
paypalCount=sum(case when Transype_tinyint=0 then 1 else 0 end) ----then 1表示符合条件加1
donationCount=sum(case when Transype_tinyint=1 then 1 else 0 end)----then 1表示符合条件加1
communityCount=sum(case when Transype_tinyint=1 then 1 else 0 end)----then 1表示符合条件加1
from 表名
order by 字段名