Sector split of emissions of selected heavy metals and persistent organic pollutants

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

SELECT DISTINCT
?sector_name_eea
?pollutant_name
?unit
round((sum(xsd:double(?emissions))/?emissions_total)*1000)/10.0 as ?share
sum(xsd:double(?emissions)) as ?emissions
?emissions_total

WHERE {
  { 
    GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/clrtap_nfr09_gf.rdf.gz> 
    {
      ?clrtap clrtap_nec_unfccc:country_code ?country_code .
      ?clrtap clrtap_nec_unfccc:pollutant_name ?pollutant_name .
      ?clrtap clrtap_nec_unfccc:sector_code ?sector_code .
      ?clrtap clrtap_nec_unfccc:unit ?unit .
      ?clrtap clrtap_nec_unfccc:year ?year .
      ?clrtap clrtap_nec_unfccc:emissions ?emissions .

      {
        SELECT DISTINCT
          
          ?pollutant_name
          
          sum(xsd:double(?emissions_total)) as ?emissions_total
        {
          ?clrtap_total clrtap_nec_unfccc:country_code ?country_code .
          ?clrtap_total clrtap_nec_unfccc:pollutant_name ?pollutant_name .
          ?clrtap_total clrtap_nec_unfccc:sector_code ?sector_code .
          ?clrtap_total clrtap_nec_unfccc:year ?year .
          ?clrtap_total clrtap_nec_unfccc:emissions ?emissions_total .

          FILTER (?year = '2017')
          FILTER (?pollutant_name in ('Cd', 'Pb', 'Hg', 'HCB', 'PCB', 'dioxin', 'total PAH'))
          FILTER (?country_code in (country:EU28, country:TR, country:NO, 
                                    country:LI, country:IS, country:CH))
          FILTER (?sector_code = sector:NATIONAL_TOTAL)

        }
      }

      FILTER (?year = '2017')
          FILTER (?pollutant_name in ('Cd', 'Pb', 'Hg', 'HCB', 'PCB', 'dioxin', 'total PAH'))
          FILTER (?country_code in (country:EU28, country:TR, country:NO, 
                                    country:LI, country:IS, country:CH))  
      FILTER (?sector_code != sector:NATIONAL_TOTAL)


    }
    ?sector_code clrtap_nec_unfccc:sector_name_eea ?sector_name_eea .
  }
}
ORDER BY ?year ?pollutant_name