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/>

#technical debt!!
SELECT DISTINCT
year(?date) as ?date
bif:either(?label = 'Total waste treatment', 'Other', ?label) as ?label
#sum(?obsValue ) as ?obsValue 
#sum(?GEN) as ?GEN
bif:either(?label = 'Total waste treatment', 
           round(((sum(?GEN)-sum(?obsValue))/sum(?GEN))*1000)/10.0, 
           bif:either(?label = 'Recycling', 
                 round(sum(?obsValue)/(sum(?GEN)/2)*1000)/10.0,
                 round(sum(?obsValue)/sum(?GEN)*1000)/10.0 )) as ?share
#     round(((sum(?GEN)-sum(?obsValue))/sum(?GEN))*1000)/10.0,
#     round(sum(?obsValue)/sum(?GEN))*1000)/10.0 as ?share


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 property:wst_oper ?wst_oper . 
    _:env_wasmun sdmx-attribute:unitMeasure unit:THS_T . 
    {
       {SELECT 'Landfill' as ?label {}}
       _:env_wasmun property:wst_oper wst_oper:DSP_L .
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    } UNION {
       {SELECT 'Total incineration (including energy recovery)' as ?label {}}
       _:env_wasmun property:wst_oper wst_oper:INC_RCV .
       _:env_wasmun sdmx-measure:obsValue ?obsValue  .
    } UNION {
       {SELECT 'Total waste treatment' as ?label {}}
       _:env_wasmun property:wst_oper wst_oper:TRT .
       _: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_OC .
       _: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, geo:HR)) 
}
GROUP BY ?date ?label
ORDER BY ?date