Share of transport GHG emissions for road transport

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
?obsValue
?total
round((?obsValue/?total)*1000.0)/10 as ?share
{{
  SELECT DISTINCT
  ?country_name
  ?sector
  ?sector_code
  sum(xsd:double(?obsValue)/11.0) as ?obsValue
  sum(xsd:double(?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)
        _: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 .

        _: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 } .
    }
  ?sector rdfs:label ?sector_code .
  }

}}