SELECT

Isnull(pi.april,0) as April

,Isnull(pi.may,0) as May

,Isnull(pi.june,0)as June

,Isnull(pi.July,0)as July

,Isnull(pi.april+pi.may+pi.june+pi.july,0)as total

FROM(

SELECT

STATUS,YEAR(DATEOFFICE) [Year],

...