660:
SQL: SELECT a.year AS `Financial Year`, p.province AS Province, sum(a.maize_90kg) AS Maize_90KG, sum(beans_90kg) AS Beans_90KG, sum(beans_50kg) AS Beans_50KG, sum(veg_oil) AS `VegetableOil (6x3 litres) Carton`, sum(unimix_25kg) AS `Unimix 25Kg`, sum(milkpowdr) AS `Milk Powder`, sum(rice_50kg) AS `Rice 50kg`, sum(pigeon_peas) AS `Pigeon Peas`, sum(estimated_value) AS `Estimated Value (Ksh)`, sum(aie) AS `AIE Amount (Ksh)`, sum(foodaie) AS `Food + AIE Value (Ksh)` FROM allocations a LEFT OUTER JOIN districts d ON (a.adistrictid = d.districtid) LEFT OUTER JOIN provinces p ON (d.dprovinceid = p.provinceid) GROUP BY a.year, p.province ORDER BY p.province ASC,a.year ASC