Final energy intensity of households sector (2005=100), EU28

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 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 siec: <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/>
PREFIX nrg_bal: <http://dd.eionet.europa.eu/vocabulary/eurostat/nrg_bal/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX age: <http://dd.eionet.europa.eu/vocabulary/eurostat/age/>
PREFIX sex: <http://purl.org/linked-data/sdmx/2009/code#>

SELECT DISTINCT
year(?date) as ?date
'Households' as ?sector

round(( ( sum(?nrg_bal_c)/ sum(?demo_pjan )  ) / ( sum(?nrg_bal_c_idx)/ sum(?demo_pjan_idx ) ) )*1000)/10.0 as ?index
sum(?nrg_bal_c) as ?nrg_bal_c
sum(?demo_pjan ) as ?demo_pjan 
#sum(?nrg_bal_c_idx)
#sum(?demo_pjan_idx )

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

      _:nrg_bal_c_idx sdmx-dimension:timePeriod ?date_idx .
      _:nrg_bal_c_idx sdmx-attribute:unitMeasure unit:KTOE .
      _:nrg_bal_c_idx sdmx-dimension:refArea geo:EU28 .
      _:nrg_bal_c_idx property:siec siec:TOTAL .
      _:nrg_bal_c_idx property:nrg_bal nrg_bal:FC_OTH_HH_E .
      _:nrg_bal_c_idx sdmx-measure:obsValue ?nrg_bal_c_idx .
     }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/demo_pjan.rdf.gz> 
    {
      _:demo_pjan sdmx-dimension:timePeriod ?date . 
      _:demo_pjan sdmx-dimension:refArea geo:EU28 . 
      _:demo_pjan sdmx-dimension:age age:TOTAL . 
      _:demo_pjan sdmx-dimension:sex sex:sex-T . 
      _:demo_pjan sdmx-measure:obsValue ?demo_pjan . 

      _:demo_pjan_idx sdmx-dimension:timePeriod ?date_idx . 
      _:demo_pjan_idx sdmx-dimension:refArea geo:EU28 . 
      _:demo_pjan_idx sdmx-dimension:age age:TOTAL . 
      _:demo_pjan_idx sdmx-dimension:sex sex:sex-T . 
      _:demo_pjan_idx sdmx-measure:obsValue ?demo_pjan_idx . 

    } 
  }
  FILTER (year(?date) >= 2005)
  FILTER (year(?date_idx) = 2005)
} 

GROUP BY year(?date)
ORDER BY ?date