Employment by activity in the Environmental Goods and Services Sector, EU28

PREFIX qb: <http://purl.org/linked-data/cube#> 
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 env_dom: <http://dd.eionet.europa.eu/vocabulary/eurostat/env_dom/>
PREFIX env_exp: <http://dd.eionet.europa.eu/vocabulary/eurostat/env_exp/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX ty: <http://dd.eionet.europa.eu/vocabulary/eurostat/ty/>
PREFIX indic_pi: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_pi/>
PREFIX ceparema: <http://dd.eionet.europa.eu/vocabulary/eurostat/ceparema/>

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
round(sum(?obsValue)/1000) 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:nace_r2 ?nace_r2 . 
    _:env_ac_egss3 property:ty ty:TOT_EGSS . 
    _:env_ac_egss3 property:ceparema ceparema:TOTAL . 
    _:env_ac_egss3 sdmx-dimension:refArea geo:EU28 . 
    _:env_ac_egss3 sdmx-attribute:unitMeasure unit:FTE . 
    _:env_ac_egss3 property:indic_pi indic_pi:EMP . 
    _:env_ac_egss3 sdmx-measure:obsValue ?obsValue .
  } 
  ?nace_r2 rdfs:label ?nace_r2_label .
 }
}
GROUP BY ?date ?nace_r2_label ?nace_r2
ORDER BY ?date ?nace_r2_label