Waste generation and decoupling - waste

PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/> 
PREFIX hazard: <http://dd.eionet.europa.eu/vocabulary/eurostat/hazard/>
PREFIX waste: <http://dd.eionet.europa.eu/vocabulary/eurostat/waste/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX indic_de: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_de/> 


SELECT DISTINCT
year(?date) as ?date
?ugeo
?label
round((sum(?obsValue)/sum(?obsValue_idx))*1000)/10.0 as ?index

  {{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasgen.rdf.gz> 
      { 
        _:env_wasgen sdmx-dimension:timePeriod ?date . 
        _:env_wasgen sdmx-dimension:refArea ?geo .
        
        _:env_wasgen sdmx-attribute:unitMeasure unit:T . 
        _:env_wasgen property:hazard hazard:HAZ_NHAZ .
        _:env_wasgen property:waste ?waste .
        _:env_wasgen property:nace_r2 nace_r2:TOTAL_HH .
        _:env_wasgen sdmx-measure:obsValue ?obsValue.

        _:env_wasgen_idx sdmx-dimension:timePeriod ?date_idx . 
        FILTER (year(?date_idx) = 2010)
        _:env_wasgen_idx sdmx-dimension:refArea ?geo . 
        _:env_wasgen_idx sdmx-attribute:unitMeasure unit:T . 
        _:env_wasgen_idx property:hazard hazard:HAZ_NHAZ .
        _:env_wasgen_idx property:waste ?waste .
        _:env_wasgen_idx property:nace_r2 nace_r2:TOTAL_HH .
        _:env_wasgen_idx sdmx-measure:obsValue ?obsValue_idx .

        FILTER (?waste in (waste:TOTAL, waste:TOT_X_MIN))
      }
      
  }
  ?waste rdfs:label ?label .
  ?geo rdfs:label ?ugeo .
  FILTER (?geo = geo:EU28)
  FILTER (year(?date) >= 2010)
}