Number of countries reporting at different levels of the MSW management hierarchy

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 rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX unit: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX wst_oper: <http://rdfdata.eionet.europa.eu/eurostat/dic/wst_oper#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>

SELECT
?date
#ugeo
#?RCY_TOT
sum(?RCY_TOT_25) as ?RCY_TOT_25
#?INC_RCV
sum(?INC_RCV_25) as ?INC_RCV_25
#?DSP_D
sum(?DSP_D_50) as ?DSP_D_50
sum(?DSP_D_75) as ?DSP_D_75
{{
  SELECT
  ?date
  ?ugeo
  bif:either(?RCY_TOT >= 25, 1, 0) as ?RCY_TOT_25
  ?RCY_TOT
  bif:either(?INC_RCV >= 25, 1, 0) as ?INC_RCV_25
  ?INC_RCV
  bif:either(?DSP_D >= 50, 1, 0) as ?DSP_D_50
  bif:either(?DSP_D >= 75, 1, 0) as ?DSP_D_75
  ?DSP_D
  {{
    SELECT
    year(?date) as ?date
    bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
    round(sum(?RCY_M) / sum(?GEN)*100) as ?RCY_M
    round(sum(?RCY_OC) / sum(?GEN)*100) as ?RCY_OC
    round(sum(?INC_RCV) / sum(?GEN)*100) as ?INC_RCV
    round(sum(?DSP_D) / sum(?GEN)*100) as ?DSP_D
    round(( ( sum(?RCY_OC) / sum(?GEN) ) + ( sum(?RCY_M) / sum(?GEN) ) ) *100)  as ?RCY_TOT

    WHERE { 
     { 
      GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasmun.rdf.gz> 
     {    
      _:env_wasmun sdmx-dimension:timePeriod ?date . 
      #FILTER (year(?date) in (2012)) 
      #FILTER (year(?date) in (2001, 2010, 2012)) 
      _:env_wasmun sdmx-attribute:unitMeasure unit:1000T . 
      _:env_wasmun sdmx-dimension:refArea ?geo . 
      {
        _:env_wasmun property:wst_oper wst_oper:GEN .
        _:env_wasmun sdmx-measure:obsValue ?GEN  .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:DSP_D .
        _:env_wasmun sdmx-measure:obsValue ?DSP_D .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:INC_RCV .
        _:env_wasmun sdmx-measure:obsValue ?INC_RCV .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:RCY_M .
        _:env_wasmun sdmx-measure:obsValue ?RCY_M .
      } UNION {
        _:env_wasmun property:wst_oper wst_oper:RCY_OC .
        _:env_wasmun sdmx-measure:obsValue ?RCY_OC .
      }
     }
     FILTER (?geo != geo:EU28 and ?geo != geo:EU27 and ?geo != geo:MK and ?geo != geo:RS and ?geo != geo:BA  and ?geo != geo:HR)
     ?geo rdf-schema:label ?ugeo .
   }} 
 }} 
}}
ORDER BY ?date