Select Police=sum(case when Type='P' then Number else 0 end),
Ambulance=sum(case when Type='A' then Number else 0 end),
EmergencyPolice=sum(case when (Type='E' or Type='P') then Number else 0 end),
EmergencyAmbulance=sum(case when (Type='E' or Type='A') then Number else 0 end) from tableName