Member states progress towards indicative national energy efficiency targets for 2020

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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 siec: <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/>
PREFIX nrg_bal: <http://dd.eionet.europa.eu/vocabulary/eurostat/nrg_bal/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX tableFile: <http://semantic7.eea.europa.eu/project/indicators/gap_filling_data/ENER/national_energy_efficiency_targets_2020_2017.txt#>

SELECT
year(?date) as ?date
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
round(sum(?obsValue)/100)/10.0 as ?total
round(sum(xsd:integer(?final ))/100)/10.0 as ?target
(( sum(?obsValue)-sum(xsd:integer(?final)) )/100)/10.0 as ?distance

round(( sum(?obsValue) - sum(xsd:integer(?final )) ) / sum(xsd:integer(?final )) * 1000)/10.0 as ?percentage_distance

WHERE {
  { 
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_bal_c.rdf.gz> {
    ?nrg_bal_c sdmx-dimension:refArea ?geo .
    ?nrg_bal_c sdmx-attribute:unitMeasure unit:KTOE .
    ?nrg_bal_c sdmx-dimension:timePeriod ?date .
    ?nrg_bal_c property:siec siec:TOTAL .

    ?nrg_bal_c property:nrg_bal nrg_bal:FC_E .
    ?nrg_bal_c sdmx-measure:obsValue ?obsValue .

{SELECT
       xsd:date(?date) as ?date
       iri(?geo) as ?geo
       xsd:double(?primary) as ?primary
       xsd:double(?final ) as ?final 
     WHERE {
       { 
       GRAPH <http://semantic7.eea.europa.eu/project/indicators/gap_filling_data/ENER/national_energy_efficiency_targets_2020_2017.txt> 
         {
           _:rec tableFile:date ?date .
           _:rec tableFile:geo ?geo .
           _:rec tableFile:primary ?primary .
           _:rec tableFile:final ?final .
         }
       }
     }
    }
  } 
  
 }
?geo rdfs:label ?ugeo
FILTER (year(?date) = 2017)
}
GROUP BY year(?date) ?ugeo ?geo