Aggregated GHG emissions by combined sectors

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/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>


SELECT DISTINCT
?year
?country
?sector_label
round(sum(?unfccc_crf)/100)/10.0 as ?unfccc_crf
?order
WHERE {
  { 
    GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
    {
      _:unfccc_crf clrtap_nec_unfccc:year ?year .
      FILTER (xsd:integer(?year) >= 1990)
      _:unfccc_crf clrtap_nec_unfccc:country_code ?country_code . 
            #FILTER (?country_code in (geo:AT, geo:BE, geo:BG, geo:CY, geo:CZ, geo:DE, geo:DK, geo:EE, geo:ES, geo:FI, geo:FR, geo:GB, geo:GR, geo:HU, geo:IE, geo:IT, geo:LT, geo:LU, geo:LV,    geo:MT, geo:NL, geo:PL, geo:PT, geo:RO, geo:SE, geo:SI, geo:SK, geo:HR, geo:LI, geo:CH, geo:NO, geo:IS, geo:TR, geo:EUA))

      _:unfccc_crf clrtap_nec_unfccc:unit 'Gg CO2 equivalent' . 
      _:unfccc_crf clrtap_nec_unfccc:pollutant_name 'All greenhouse gases - (CO2 equivalent)' . 

      {
        { SELECT 'Energy supply' as ?sector_label '' as ?order {}}
        _: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 ?unfccc_crf .
      } UNION {
        { SELECT 'Industry' as ?sector_label '' as ?order {}}
        _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
        FILTER (?sector_code in (sector:1.A.2, sector:2))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      } UNION {
        { SELECT 'Residential and commercial' as ?sector_label '' as ?order {}}
        _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
        FILTER (?sector_code in (sector:1.A.4.a, sector:1.A.4.b))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      } UNION {
        { SELECT 'Agriculture' as ?sector_label '' as ?order {}}
        _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
        FILTER (?sector_code in (sector:1.A.4.c, sector:3))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      } UNION {
        { SELECT 'Other' as ?sector_label '' as ?order {}}
        _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
        FILTER (?sector_code in (sector:ind_CO2, sector:6, sector:1.A.5))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      } 
    }
    ?country_code rdfs:label ?country .
  }
}
GROUP BY ?year ?country ?sector_label ?order
ORDER BY desc(?order) ?country ?year