Trends in GVA and employment, EU28

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 indic_pi: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_pi/>
PREFIX caparema: <http://dd.eionet.europa.eu/vocabulary/eurostat/ceparema/>
PREFIX nace_r2:<http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX ty: <http://dd.eionet.europa.eu/vocabulary/eurostat/ty/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX age: <http://dd.eionet.europa.eu/vocabulary/eurostat/age/>
PREFIX sex: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX indic_em: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_em/>

SELECT DISTINCT
year(?date) as ?date

round(sum(?env_ac_egss1)/sum(?env_ac_egss1_idx)*1000)/10.0 as ?env_ac_egss1

round(sum(?CLV10_MEUR)/sum(?CLV10_MEUR_idx)*1000)/10.0 as ?CLV10_MEUR

round(sum(?lfsi_emp_a)/sum(?lfsi_emp_a_idx)*1000)/10.0 as ?lfsi_emp_a

round(( sum(?env_ac_egss2)/(sum(?CP_MEUR)/sum(?CLV10_MEUR)) ) /
( sum(?env_ac_egss2_idx)/(sum(?CP_MEUR_idx)/sum(?CLV10_MEUR_idx) ) )*1000)/10.0 as ?env_ac_egss2

#sum(?env_ac_egss1) as ?env_ac_egss1
#sum(?env_ac_egss1_idx) as ?env_ac_egss1_idx
#sum(?env_ac_egss2) as ?env_ac_egss2
#sum(?env_ac_egss2_idx) as ?env_ac_egss2_idx
#sum(?lfsi_emp_a) as ?lfsi_emp_a
#sum(?lfsi_emp_a_idx) as ?lfsi_emp_a_idx
#sum(?CLV10_MEUR) as ?CLV10_MEUR
#sum(?CLV10_MEUR_idx) as ?CLV10_MEUR_idx
#sum(?CP_MEUR) as ?CP_MEUR
#sum(?CP_MEUR_idx) as ?CP_MEUR_idx
#( sum(?CP_MEUR)/sum(?CLV10_MEUR) / sum(?CP_MEUR_idx)/sum(?CLV10_MEUR_idx) ) as ?deflator
#round(sum(?CP_MEUR)/sum(?CLV10_MEUR)*1000)/10.0 as ?deflator
#round(sum(?CP_MEUR_idx)/sum(?CLV10_MEUR_idx)*1000)/10.0 as ?deflator_idx

WHERE {
 {
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_egss1.rdf.gz>
  {
    _:env_ac_egss1 sdmx-dimension:timePeriod ?date . 
    _:env_ac_egss1 property:nace_r2 nace_r2:TOTAL . 
    _:env_ac_egss1 property:ty ty:TOT_EGSS . 
    _:env_ac_egss1 property:ceparema caparema:TOTAL . 
    _:env_ac_egss1 sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss1 sdmx-attribute:unitMeasure unit:FTE . 
    _:env_ac_egss1 property:indic_pi indic_pi:EMP . 
    _:env_ac_egss1 sdmx-measure:obsValue ?env_ac_egss1 .

    _:env_ac_egss1_idx sdmx-dimension:timePeriod ?date_idx .
    FILTER (year(?date_idx) = 2003)
    _:env_ac_egss1_idx property:nace_r2 nace_r2:TOTAL . 
    _:env_ac_egss1_idx property:ty ty:TOT_EGSS . 
    _:env_ac_egss1_idx property:ceparema caparema:TOTAL . 
    _:env_ac_egss1_idx sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss1_idx sdmx-attribute:unitMeasure unit:FTE . 
    _:env_ac_egss1_idx property:indic_pi indic_pi:EMP . 
    _:env_ac_egss1_idx sdmx-measure:obsValue ?env_ac_egss1_idx .
  }
 } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_egss2.rdf.gz>
  {
    _:env_ac_egss2 sdmx-dimension:timePeriod ?date . 
    _:env_ac_egss2 property:nace_r2 nace_r2:TOTAL . 
    _:env_ac_egss2 property:ty ty:TOT_EGSS . 
    _:env_ac_egss2 property:ceparema caparema:TOTAL . 
    _:env_ac_egss2 sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss2 sdmx-attribute:unitMeasure unit:MIO_EUR . 
    _:env_ac_egss2 property:indic_pi indic_pi:VA . 
    _:env_ac_egss2 sdmx-measure:obsValue ?env_ac_egss2 .
    
    _:env_ac_egss2_idx sdmx-dimension:timePeriod ?date_idx .
    FILTER (year(?date_idx) = 2003)
    _:env_ac_egss2_idx property:nace_r2 nace_r2:TOTAL . 
    _:env_ac_egss2_idx property:ty ty:TOT_EGSS . 
    _:env_ac_egss2_idx property:ceparema caparema:TOTAL . 
    _:env_ac_egss2_idx sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss2_idx sdmx-attribute:unitMeasure unit:MIO_EUR . 
    _:env_ac_egss2_idx property:indic_pi indic_pi:VA . 
    _:env_ac_egss2_idx sdmx-measure:obsValue ?env_ac_egss2_idx .
  }
 } UNION {
   GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/lfsi_emp_a.rdf.gz>
  {
    _:lfsi_emp_a sdmx-dimension:timePeriod ?date . 
    _:lfsi_emp_a sdmx-dimension:age age:Y15-64 . 
    _:lfsi_emp_a sdmx-dimension:sex sex:sex-T .
    _:lfsi_emp_a property:indic_em indic_em:EMP_LFS . 
    _:lfsi_emp_a sdmx-dimension:refArea geo:EU28 . 
    _:lfsi_emp_a sdmx-attribute:unitMeasure unit:THS_PER . 
    _:lfsi_emp_a sdmx-measure:obsValue ?lfsi_emp_a .

    _:lfsi_emp_a_idx sdmx-dimension:timePeriod ?date_idx .
    FILTER (year(?date_idx) = 2003) 
    _:lfsi_emp_a_idx sdmx-dimension:age age:Y15-64 . 
    _:lfsi_emp_a_idx sdmx-dimension:sex sex:sex-T .
    _:lfsi_emp_a_idx property:indic_em indic_em:EMP_LFS . 
    _:lfsi_emp_a_idx sdmx-dimension:refArea geo:EU28 . 
    _:lfsi_emp_a_idx sdmx-attribute:unitMeasure unit:THS_PER . 
    _:lfsi_emp_a_idx sdmx-measure:obsValue ?lfsi_emp_a_idx .
  }
 } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_10_gdp.rdf.gz>
  {
    _:nama_10_gdp sdmx-dimension:timePeriod ?date . 
    _:nama_10_gdp property:na_item na_item:B1GQ . 
    _:nama_10_gdp sdmx-dimension:refArea geo:EU28 .
    _:nama_10_gdp sdmx-attribute:unitMeasure ?unit .
    {
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CLV10_MEUR .
      _:nama_10_gdp sdmx-measure:obsValue ?CLV10_MEUR .
    } UNION {
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CP_MEUR .
      _:nama_10_gdp sdmx-measure:obsValue ?CP_MEUR .
    }

    _:nama_10_gdp_idx sdmx-dimension:timePeriod ?date_idx .
    FILTER (year(?date_idx) = 2003) 
    _:nama_10_gdp_idx property:na_item na_item:B1GQ . 
    _:nama_10_gdp_idx sdmx-dimension:refArea geo:EU28 .
    _:nama_10_gdp_idx sdmx-attribute:unitMeasure ?unit .
    {
      _:nama_10_gdp_idx sdmx-attribute:unitMeasure unit:CLV10_MEUR .
      _:nama_10_gdp_idx sdmx-measure:obsValue ?CLV10_MEUR_idx .
    } UNION {
      _:nama_10_gdp sdmx-attribute:unitMeasure unit:CP_MEUR .
      _:nama_10_gdp_idx sdmx-measure:obsValue ?CP_MEUR_idx .
    }
  }

 }
 FILTER (year(?date) >= 2003)
}
GROUP BY year(?date) ?date_idx
ORDER BY ?date