Gross electricity production for Renewables

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 geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>

SELECT 
  year(?date) as ?year
  bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
  'Renewables' as ?sector
  round((( sum(?Renewables_incl_pumped_hydro )-sum(?pumped_hydro)) )/100.0)/10.0 as ?obsValue

WHERE {
  {  
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_105a.rdf.gz> 
    {
    _:nrg_105a sdmx-dimension:refArea ?geo .
    _:nrg_105a sdmx-attribute:unitMeasure unit:GWH .
    _:nrg_105a sdmx-dimension:timePeriod ?date .
    _:nrg_105a property:product product:6000 .
    {
      _:nrg_105a property:indic_nrg ?indic_nrg .
      FILTER (?indic_nrg in (indic_nrg:15_107034,indic_nrg:15_107035,indic_nrg:14_1070421,
      indic_nrg:14_1070422,indic_nrg:14_1070431,indic_nrg:14_1070432,indic_nrg:15_107046,
      indic_nrg:15_107047,indic_nrg:22_108911,indic_nrg:22_108912,indic_nrg:22_108913,
      indic_nrg:22_108914,indic_nrg:22_108931,indic_nrg:22_108932,indic_nrg:22_108933,
      indic_nrg:22_108934,indic_nrg:22_108941,indic_nrg:22_108942,indic_nrg:22_108943,
      indic_nrg:22_108944,indic_nrg:22_108951,indic_nrg:22_108952,indic_nrg:22_108953,
      indic_nrg:22_108954,indic_nrg:22_108971,indic_nrg:22_108972,indic_nrg:22_108973,
      indic_nrg:22_108974,indic_nrg:15_107038,indic_nrg:15_107039,indic_nrg:15_107040,
      indic_nrg:15_107041,indic_nrg:15_107044,indic_nrg:15_107045))
      _:nrg_105a sdmx-measure:obsValue ?Renewables_incl_pumped_hydro .
    } UNION {
      _:nrg_105a property:indic_nrg ?indic_nrg .
      FILTER (?indic_nrg in (indic_nrg:15_107036, indic_nrg:15_107037))
      _:nrg_105a sdmx-measure:obsValue ?pumped_hydro .
    } 
   }
  }
  ?geo rdfs:label ?ugeo .
  FILTER (?geo in (geo:AT, geo:BE, geo:BG, geo:CY, geo:CZ, geo:DE, geo:DK,
                     geo:EE, geo:EL, geo:ES, geo:FI, geo:FR, geo:HR, geo:HU,
                     geo:IE, geo:IT, geo:LT, geo:LU, geo:LV, geo:MT, geo:NL,
                     geo:PL, geo:PT, geo:RO, geo:SE, geo:SI, geo:SK, geo:UK, 
                     geo:EU28))
  
  FILTER (year(?date) >= 1990)
  #FILTER (year(?date) = 2015)
} 
GROUP BY year(?date) ?geo ?ugeo
ORDER BY ?date ?ugeo