Share of transport GHG emissions

PREFIX clrtap_nec_unfccc: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/schema/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/>
PREFIX country: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>

SELECT
?country_name as ?ugeo
bif:substring( ?sector_code, coalesce((bif:strchr( ?sector_code, '-')+2),1) , 100) as ?sector

?total

round((sum(?obsValue)/?total)*1000.0)/10.0 as ?share
sum(?obsValue) as ?obsValue
{{
  SELECT DISTINCT
  ?country_name
  bif:either(bound(?sector_code_dummy), ?sector_code_dummy, ?sector_code) as ?sector_code
  sum(?obsValue/11.0) as ?obsValue
  sum(?total) as ?total
  WHERE {
    { 
      GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
      {
        _: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:year '2017' . 
        _:unfccc_crf clrtap_nec_unfccc:country_code ?geo .
        FILTER (?geo = country:EUA)
        {
          { SELECT 'Aviation' as ?sector_code_dummy {} } .
          _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector .
          FILTER (?sector in (sector:1.A.3.a, sector:1.D.1.a))
          _:unfccc_crf clrtap_nec_unfccc:emissions ?obsValue .
        } UNION {
          { SELECT 'Maritime' as ?sector_code_dummy {} } .
          _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector .
          FILTER (?sector in (sector:1.A.3.d, sector:1.D.1.b))
          _:unfccc_crf clrtap_nec_unfccc:emissions ?obsValue .
        } UNION {
          { SELECT 'Road transport' as ?sector_code_dummy {} } .
          _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector .
          FILTER (?sector in (sector:1.A.3.b.i, 
                   sector:1.A.3.b.ii, sector:1.A.3.b.iii,
                   sector:1.A.3.b.iv, sector:1.A.3.b.v))
          _:unfccc_crf clrtap_nec_unfccc:emissions ?obsValue .
        } UNION {
          _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector .
          FILTER (?sector in (sector:1.A.3.c, sector:1.A.3.e))
          _:unfccc_crf clrtap_nec_unfccc:emissions ?obsValue .
        }

        _:unfccc_crf_total clrtap_nec_unfccc:unit 'Gg CO2 equivalent' . 
        _:unfccc_crf_total clrtap_nec_unfccc:pollutant_name 'All greenhouse gases - (CO2 equivalent)' . 
        _:unfccc_crf_total clrtap_nec_unfccc:year '2016' . 
        _:unfccc_crf_total clrtap_nec_unfccc:country_code ?geo_total .
        FILTER (?geo_total = country:EUA)
        _:unfccc_crf_total clrtap_nec_unfccc:sector_code ?sector_total .
        FILTER (?sector_total in (sector:1.A.3.a, sector:1.D.1.a, sector:1.A.3.c,
                            sector:1.A.3.d, sector:1.D.1.b, sector:1.A.3.e,
                            sector:1.A.3.b.i, sector:1.A.3.b.ii, sector:1.A.3.b.iii,                 
                            sector:1.A.3.b.iv, sector:1.A.3.b.v))
        _:unfccc_crf_total clrtap_nec_unfccc:emissions ?total .

      }
      ?geo rdfs:label ?country_name .
      OPTIONAL { ?sector rdfs:label ?sector_code } .
    }
  }
  GROUP BY ?country_name ?sector_code ?sector_code_dummy
}}
ORDER BY ?country_name