Share of renewable energy

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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX nrg_bal: <http://dd.eionet.europa.eu/vocabulary/eurostat/nrg_bal/>
PREFIX common_countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
PREFIX proxy: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CSI037/proxy_2020.tsv#>

SELECT 
?date as ?date_original

bif:either(year(?date) = 2021, '2020 target', bif:either(year(?date) = 2020, '2020 proxy' ,year(?date))) as ?date



bif:either(?geo = geo:DE, 'Germany', bif:either(?geo = geo:EU28, 'EU-28', bif:either(?geo = geo:EU27_2020, 'EU-27',?ugeo)) ) as ?ugeo
round(?obsValue*10)/10 as ?obsValue
#?proxy
10 AS ?target
WHERE 
  {{  
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_ind_ren.rdf.gz> 
    {
      _:nrg_ind_ren sdmx-dimension:timePeriod ?date .
      _:nrg_ind_ren sdmx-dimension:refArea ?geo .
      _:nrg_ind_ren sdmx-attribute:unitMeasure unit:PC .
      _:nrg_ind_ren property:nrg_bal nrg_bal:REN_TRA .
      _:nrg_ind_ren sdmx-measure:obsValue ?obsValue .
    }
  } UNION {
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CSI037/proxy_2020.tsv> 
    {
      _:rec proxy:date ?date  .
      _:rec proxy:geo ?geo  .
      _:rec proxy:obsValue ?obsValue  .
      #_:rec proxy:obsValue ?proxy  .
    }
  } UNION {
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/CSI037/proxy_2020.tsv> 
    {
      {
        SELECT 
          xsd:date('2021-01-01') as ?date
          10 AS ?target
          10 AS ?obsValue
          WHERE {} 
      }
      _:rec proxy:geo ?geo  .
    }
  }
  ?geo rdfs:label ?ugeo .
  FILTER (?geo IN (  geo:EU28, geo:EU27_2020, geo:BE, geo:BG,
                     geo:CZ,	geo:DK,	geo:DE,	geo:EE,
                     geo:IE,	geo:EL,	geo:ES,	geo:FR,	
                     geo:HR,	geo:IT,	geo:CY,	geo:LV,
                     geo:LT,	geo:LU,	geo:HU,	geo:MT,		
                     geo:NL,	geo:AT,	geo:PL,	geo:PT,	
                     geo:RO,	geo:SI,	geo:SK,	geo:FI,
                     geo:SE,	geo:UK, geo:TR, geo:NO, 
                     geo:IS))
} 
ORDER BY ?date