Persons employed in total tourism industries and in selected tourism industries as share of those employed in total non-financial business economy

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 indic_sb: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_sb/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>

SELECT 
year(?date) as ?date

bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo

round(( sum(?H51_I55_N79) / sum(?B_N_S95_X_K) )*1000)/10.0 as ?tourism
round(( sum(?TI) / sum(?B_N_S95_X_K) )*1000)/10.0 as ?total_tourism_industries

#sum(?B_N_S95_X_K) as ?B_N_S95_X_K
#sum(?H51_I55_N79) as ?H51_I55_N79
#sum(?TI) as ?TI

WHERE {{ 
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/sbs_na_sca_r2.rdf.gz> 
    {
      _:sbs_na_sca_r2 sdmx-dimension:timePeriod ?date . 
      FILTER (year(?date) >= 2012)
      _:sbs_na_sca_r2 property:indic_sb indic_sb:V16110 . 
      _:sbs_na_sca_r2 sdmx-dimension:refArea ?geo . 
      {
        _:sbs_na_sca_r2 property:nace_r2 ?nace_r2 .
        FILTER (?nace_r2 in (nace_r2:B-N_S95_X_K))
        _:sbs_na_sca_r2 sdmx-measure:obsValue ?B_N_S95_X_K .
      } UNION {
        _:sbs_na_sca_r2 property:nace_r2 ?nace_r2 .
        FILTER (?nace_r2 in (nace_r2:TI))
        _:sbs_na_sca_r2 sdmx-measure:obsValue ?TI .
      } UNION {
        _:sbs_na_sca_r2 property:nace_r2 ?nace_r2 .
        FILTER (?nace_r2 in (nace_r2:H51, nace_r2:I55, nace_r2:N79))
        _:sbs_na_sca_r2 sdmx-measure:obsValue ?H51_I55_N79 .
      }
    }
  ?geo rdfs:label ?ugeo .
}}
ORDER BY ?date desc(?total_tourism_industries) desc(?tourism)