Employment by activity in the Environmental Goods and Services Sector, 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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX ceparema: <http://dd.eionet.europa.eu/vocabulary/eurostat/ceparema/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>
PREFIX ty: <http://dd.eionet.europa.eu/vocabulary/eurostat/ty/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>

SELECT DISTINCT
year(?date) as ?date
bif:either(?nace_r2 = nace_r2:D_E, 'Electricity, water and waste', ?nace_r2_label) as ?nace_r2_label
(?obsValue/1000000.0) as ?obsValue

WHERE {
{
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_ac_egss3.rdf.gz>
  {
    _:env_ac_egss3 sdmx-dimension:timePeriod ?date . 
    _:env_ac_egss3 property:ceparema ceparema:TOTAL .
    _:env_ac_egss3 property:nace_r2 ?nace_r2 . 

    _:env_ac_egss3 property:ceparema ceparema:TOTAL . 
    _:env_ac_egss3 sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss1_idx property:na_item na_item:EMP_DC .
    _:env_ac_egss3 property:ty ty:TOT_EGSS . 
    _:env_ac_egss3 sdmx-attribute:unitMeasure unit:FTE . 

    _:env_ac_egss3 sdmx-measure:obsValue ?obsValue .
  } 
  ?nace_r2 rdfs:label ?nace_r2_label .
 }
}
ORDER BY ?date