Final energy consumption by transport modes

PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX c: <http://rdfdata.eionet.europa.eu/eurostat/dic/coicop#> 
PREFIX g: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX i: <http://rdfdata.eionet.europa.eu/eurostat/dic/infotype#>
PREFIX u: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX indic_nrg: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_nrg#>

SELECT 
year(?date) as ?year 
sum(?B_100800)/1000 as ?International_Marine_Bunkers 
sum(?B_101910)/1000 as ?Rail_Transport 
sum(?B_101920)/1000 as ?Road_Transport 
sum(?B_101931)/1000 as ?International_Aviation 
sum(?B_101932)/1000 as ?Domestic_Aviation 
sum(?B_101940)/1000 as ?Domestic_Navigation
sum(?total)/1000 as ?Total
WHERE { 
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz> { 
        _:nrg_100a property:unit u:1000TOE .
        _:nrg_100a property:geo g:EU27 .
        _:nrg_100a property:geo ?ugeo .
        _:nrg_100a sdmx-dimension:timePeriod ?date .
        { 
        _:nrg_100a property:indic_nrg indic_nrg:B_100800 .
	_:nrg_100a sdmx-measure:obsValue ?B_100800 .
	} UNION { 
        _:nrg_100a property:indic_nrg indic_nrg:B_101910 .
	_:nrg_100a sdmx-measure:obsValue ?B_101910 .
	} UNION { 
        _:nrg_100a property:indic_nrg indic_nrg:B_101920 .
	_:nrg_100a sdmx-measure:obsValue ?B_101920 .
	} UNION { 
        _:nrg_100a property:indic_nrg indic_nrg:B_101931 .
	_:nrg_100a sdmx-measure:obsValue ?B_101931 .
	} UNION { 
        _:nrg_100a property:indic_nrg indic_nrg:B_101932 .
	_:nrg_100a sdmx-measure:obsValue ?B_101932 .
	} UNION { 
        _:nrg_100a property:indic_nrg indic_nrg:B_101940 .
	_:nrg_100a sdmx-measure:obsValue ?B_101940 .
	} UNION { 
        _:nrg_100a property:indic_nrg ?indic_nrg . FILTER (?indic_nrg IN (indic_nrg:B_100800,indic_nrg:B_101910,indic_nrg:B_101920,indic_nrg:B_101932,indic_nrg:B_101931,indic_nrg:B_101940))
	_:nrg_100a sdmx-measure:obsValue ?total .  
	}
  } 
} GROUP BY ?date 
  ORDER BY ?date