Greenhouse gas sectoral trends

PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX clrtap_nec_unfccc: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/schema/>
PREFIX geo: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/>

SELECT distinct
?date
round(sum(?energy_supply)/100)/10.0 as ?energy_supply
round(sum(?energy_use)/100)/10.0 as ?energy_use
round(sum(?transport)/100)/10.0 as ?transport
round(sum(?industrial_processes)/100)/10.0 as ?industrial_processes
round(sum(?waste)/100)/10.0 as ?waste
round(sum(?agriculture)/100)/10.0 as ?agriculture
round(sum(?solvents)/100)/10.0 as ?solvents

WHERE {
{ 
 GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
  {
    _:unfccc_crf clrtap_nec_unfccc:year ?date .
    _:unfccc_crf clrtap_nec_unfccc:country_code geo:EU28 .
    _:unfccc_crf clrtap_nec_unfccc:pollutant_name ?pollutant_name . 
    FILTER (?pollutant_name= 'All greenhouse gases - (CO2 equivalent)')
    #_:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
    {
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code .
      FILTER (?sector_code in (sector:1.A.1, sector:1.B))
      _:unfccc_crf clrtap_nec_unfccc:emissions ?energy_supply .
    } UNION {
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:1.A.2, sector:1.A.4, sector:1.A.5))
      _:unfccc_crf clrtap_nec_unfccc:emissions ?energy_use .
    } UNION {
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:1.A.3))
      _:unfccc_crf clrtap_nec_unfccc:emissions ?transport .
    } UNION {
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:4))
      _:unfccc_crf clrtap_nec_unfccc:emissions ?agriculture .
    } UNION {
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:2))
      _:unfccc_crf clrtap_nec_unfccc:emissions ?industrial_processes .
    } UNION {
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:3))
      _:unfccc_crf clrtap_nec_unfccc:emissions ?solvents.
    } UNION {
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:6))
      _:unfccc_crf clrtap_nec_unfccc:emissions ?waste .
    }
  } 
 }
}
GROUP BY ?date
ORDER BY ?date