Share of treatment methods of municipal 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 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

bif:either(?label = 'Recycling', 'Recycling (incl. composting/digestion)', ?label) as ?label
bif:either(?label = 'Other', round(((?GEN-sum(?obsValue))/?GEN)*1000)/10.0, round((sum(?obsValue)/?GEN)*1000)/10.0) as ?share

#sum(?obsValue) as ?obsValue
#sum(?obsValue_other)
#?GEN

WHERE {{
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_wasmun.rdf.gz> { 
  {
    
    _:env_wasmun sdmx-dimension:timePeriod ?date . 
    _:env_wasmun sdmx-dimension:refArea ?geo . 
    _:env_wasmun sdmx-attribute:unitMeasure unit:THS_T . 
    {
       {SELECT 'Landfill' as ?label {}}
       _:env_wasmun property:wst_oper wst_oper:DSP_L_OTH .
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    } UNION {
       {SELECT 'Total incineration (including energy recovery)' as ?label {}}
       _:env_wasmun property:wst_oper wst_oper:DSP_I_RCV_E .
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    } UNION {
       {SELECT 'Recycling' as ?label {}}
       _:env_wasmun property:wst_oper wst_oper:RCY_M .
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    } UNION {
       {SELECT 'Recycling' as ?label {}}
       _:env_wasmun property:wst_oper wst_oper:RCY_C_D .
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    } UNION {
       {SELECT 'Other' as ?label {}}
       _:env_wasmun property:wst_oper ?wst_oper .
       FILTER (?wst_oper IN (wst_oper:DSP_L_OTH, wst_oper:DSP_I_RCV_E, 
                            wst_oper:RCY_M, wst_oper:RCY_C_D))
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    }

    _:env_wasmun_total sdmx-dimension:timePeriod ?date . 
    _:env_wasmun_total sdmx-dimension:refArea ?geo . 
    _:env_wasmun_total property:wst_oper ?wst_oper_total . 
    _:env_wasmun_total sdmx-attribute:unitMeasure unit:THS_T .
    _:env_wasmun_total property:wst_oper wst_oper:GEN .
    _:env_wasmun_total sdmx-measure:obsValue ?GEN .
   }
  }
 }
 ?geo rdf-schema:label ?ugeo .
 FILTER (?geo in (geo:EU27))
 FILTER (year(?date) > 2003) 
}

ORDER BY ?date