Packaging waste recycling

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
bif:either(year(?date) > 2010, 2016, year(?date) ) as ?date
?ugeo

round((sum(?recycled_waste)/sum(?generated_waste))*1000)/10.0 as ?share
55 as ?target_2008
65 as ?target_2025
70 as ?target_2030
sum(?generated_waste) as ?generated_waste
sum(?recycled_waste) as ?recycled_waste
WHERE {{
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waspac.rdf.gz> 
    {{
      _:env_waspac sdmx-dimension:timePeriod ?date .
      _:env_waspac property:stk_flow stk_flow:DOM . 
      _:env_waspac property:waste waste:W1501 . 
      _:env_waspac sdmx-dimension:refArea ?geo . 
      _:env_waspac sdmx-attribute:unitMeasure unit:T . 
      {
        _:env_waspac property:wst_oper wst_oper:GEN .
        _:env_waspac sdmx-measure:obsValue ?generated_waste .
      } UNION {
        _:env_waspac property:wst_oper wst_oper:RCY .
        _:env_waspac sdmx-measure:obsValue ?recycled_waste .
      }


      #select the max year per country
      {
          SELECT DISTINCT
            max(?date) as ?date
            ?geo
          WHERE {{
           GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waspac.rdf.gz> 
              {{
                _:env_waspac sdmx-dimension:timePeriod ?date .
                _:env_waspac sdmx-dimension:refArea ?geo . 
              }}
          }}
          GROUP BY ?geo 
      } UNION {
        {
      #select 2005 year per country
          SELECT DISTINCT
            ?date
            ?geo
          WHERE {{
            GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_waspac.rdf.gz> 
            {{
              _:env_waspac sdmx-dimension:timePeriod ?date .
              _:env_waspac sdmx-dimension:refArea ?geo .
              FILTER (year(?date) = 2005)
            }}
          }}
          GROUP BY ?geo 
        }
      }
    }}
    ?geo skos:exactMatch ?eeauri .
    ?eeauri skos:inScheme <http://dd.eionet.europa.eu/vocabulary/common/countries/> .
    ?eeauri rdfs:label ?ugeo .
}}
GROUP BY ?ugeo ?geo ?date
ORDER BY ?ugeo