Recycling rates by waste streams

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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX wst_oper: <http://dd.eionet.europa.eu/vocabulary/eurostat/wst_oper/>
PREFIX stk_flow: <http://dd.eionet.europa.eu/vocabulary/eurostat/stk_flow/>
PREFIX waste: <http://dd.eionet.europa.eu/vocabulary/eurostat/waste/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>

SELECT DISTINCT

year(?date) as ?date
?label
round((sum(?RCY )/sum(?GEN))*1000)/10.0 as ?share

WHERE {{
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waspac.rdf.gz> 
  {
    {SELECT 'Packaging waste' as ?label {}}
    _:env_waspac sdmx-dimension:refArea ?geo .
    _:env_waspac sdmx-dimension:timePeriod ?date .
    _:env_waspac property:stk_flow stk_flow:DOM . 
    _:env_waspac property:waste waste:W1501 . 
    _:env_waspac sdmx-attribute:unitMeasure unit:T . 
    {
      _:env_waspac property:wst_oper wst_oper:GEN .
      _:env_waspac sdmx-measure:obsValue ?GEN .
    } UNION {
       _:env_waspac property:wst_oper wst_oper:RCY .
      _:env_waspac sdmx-measure:obsValue ?RCY .
    }
     FILTER (?geo in (geo:EU28, geo:NO, geo:IS, geo:CH)) 
  }
 } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasmun.rdf.gz> { 
  {
    {SELECT 'Municipal waste' as ?label {}}
    _:env_wasmun sdmx-dimension:timePeriod ?date . 
    _:env_wasmun sdmx-dimension:refArea ?geo . 
    _:env_wasmun property:wst_oper ?wst_oper . 
    _:env_wasmun sdmx-attribute:unitMeasure unit:THS_T . 
    {
      _:env_wasmun property:wst_oper wst_oper:GEN .
      _:env_wasmun sdmx-measure:obsValue ?GEN .
    } UNION {
       _:env_wasmun property:wst_oper ?wst_oper .
       FILTER (?wst_oper in (wst_oper:RCY_M, wst_oper:RCY_C_D))
      _:env_wasmun sdmx-measure:obsValue ?RCY .
    }
    FILTER (?geo in (geo:EU27, geo:HR, geo:NO, geo:IS, geo:CH)) 
   }
  }
 }
 ?geo rdf-schema:label ?ugeo .
 

 FILTER (year(?date) >= 2004)
}
GROUP BY ?date ?label
ORDER BY ?date