Aggregated GHG emissions by original 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 sectors: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/Sectors/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>

SELECT 
?year
?country



bif:either(?sector_code in (sector:1.D.3, sector:1.D.1.a, sector:1.D.1.b ), concat('(Memo items) ',?sector_label), ?sector_label) as ?sector_label

?unfccc_crf
?order
{{
SELECT DISTINCT
?year
?country
?sector_code
bif:substring( ?sector_label, (coalesce( xsd:integer(bif:strchr( ?sector_label, '-')), -2) +3) , 50) as ?sector_label

round(sum(?unfccc_crf)/100)/10.0 as ?unfccc_crf
bif:either(?sector_code in (sector:1.D.3, sector:1.D.1.a, sector:1.D.1.b ), '(Memo items)', '') as ?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))
      #FILTER (?country_code in (geo:DE))

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

      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:1.A.3, sector:1.D.1.a, sector:1.D.1.b, sector:1.D.1.a,
                               sector:4, sector:1.D.3, sector:5, sectors:Totals_excl_excl))
      _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .

    }
    ?sector_code rdf-schema:label ?sector_label .
    ?country_code rdfs:label ?country .
  }
}
GROUP BY ?year ?country ?sector_label ?sector_code
ORDER BY ?country ?year

}}