select (select name from t_area where id=areaid) 区域,

     sum(case when month = '' then money else 0 end) 一月,

     sum(case when month = '' then money else 0 end) 二月,

     sum(case when month = '' then money else 0 end) 三月,

     sum(case when month = '' then money else 0 end) 四月,

     sum(case when month = '' then money else 0 end) 五月,

     sum(case when month = '' then money else 0 end) 六月,

     sum(case when month = '' then money else 0 end) 七月,

     sum(case when month = '' then money else 0 end) 八月,

     sum(case when month = '' then money else 0 end) 九月,

     sum(case when month = '' then money else 0 end) 十月,

     sum(case when month = '' then money else 0 end) 十一月,

     sum(case when month = '' then money else 0 end) 十二月

from t_account where year='' group by areaid;