Share of renewable energies in GEIC, compared to target in COM(97) 599 final

PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX g: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX p: <http://rdfdata.eionet.europa.eu/eurostat/dic/product#>
PREFIX indic_nrg: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_nrg#>

SELECT
?country
sum(?1990) as ?1990
sum(?1995) as ?1995
sum(?2000) as ?2000
sum(?2005) as ?2005
sum(?2009) as ?2009
sum(?2010) as ?2010
sum(?2011) as ?2011
bif:either (?ugeo in ('EU15', 'SE', 'AT', 'FI', 'PT','DK', 'ES', 'DE', 'IT','IE', 'FR', 'EL', 'IE', 'BE', 'NL', 'UK', 'LU' ), 12, '') as ?target
bif:either (regex(str(?country), "^Eur", "i"), 1, 0) as ?order


{{

SELECT 
bif:either (?ugeo = 'DE', 'Germany', ?country) as ?country
bif:either (year(?date) = 1990, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?1990
bif:either (year(?date) = 1995, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?1995
bif:either (year(?date) = 2000, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?2000
bif:either (year(?date) = 2005, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?2005
bif:either (year(?date) = 2009, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?2009
bif:either (year(?date) = 2010, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?2010
bif:either (year(?date) = 2011, (round((sum(?nrg_1071a_5500)/sum(?nrg_100a))*10000))/100.0, 0) as ?2011
?ugeo 
WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> 
  {
  _:nrg_100a property:geo ?geo .
  _:nrg_100a property:unit u:1000TOE .
  _:nrg_100a sdmx-dimension:timePeriod ?date .
  _:nrg_100a property:product p:0000 .
  _:nrg_100a property:indic_nrg indic_nrg:B_100900 .
  _:nrg_100a sdmx-measure:obsValue ?nrg_100a .
  } 

  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_1071a.rdf.gz> 
  {
  _:nrg_1071a property:geo ?geo .
  _:nrg_1071a property:unit u:1000TOE .
  _:nrg_1071a sdmx-dimension:timePeriod ?date .
  _:nrg_1071a property:indic_nrg indic_nrg:B_100900 .
  _:nrg_1071a property:product p:5500 .
  _:nrg_1071a sdmx-measure:obsValue ?nrg_1071a_5500 .
 }
}
?geo skos:notation ?ugeo . 
?geo skos:prefLabel ?country .
} 
GROUP BY year(?date) ?country ?ugeo
}} 
GROUP BY ?country ?ugeo
ORDER BY desc(?order) desc(?2011) ?country