Real price indices of passenger transport based on a TERM020 - fixed transport product in the EU 25 Member States (2005=100) - prc_hicp_aind

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#>

SELECT 
year(?date) as ?year 
(round((sum(?CP07)/sum(?CP00))*10000))/100.0 as ?All_Transport 
(round((sum(?CP0711)/sum(?CP00))*10000))/100.0 as ?Purchase_of_motor_cars 
(round((sum(?CP072)/sum(?CP00))*10000))/100.0 as ?Operation_of_personal_transport_equipment 
(round((sum(?CP0731)/sum(?CP00))*10000))/100.0 as ?Passenger_transport_by_railway 
(round((sum(?CP0732)/sum(?CP00))*10000))/100.0 as ?Passenger_transport_by_road 
(round((sum(?CP0733)/sum(?CP00))*10000))/100.0 as ?Passenger_transport_by_air 
(round((sum(?CP0734)/sum(?CP00))*10000))/100.0 as ?Passenger_transport_by_sea_and_inland_waterway

WHERE { 
 GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/prc_hicp_aind.rdf.gz> { 
        _:guard property:geo g:EU28 .
        _:guard property:infotype i:AVX .
        _:guard sdmx-dimension:timePeriod ?date . FILTER (?date > "1995-01-01"^^xsd:date)
        { 
        _:guard property:coicop c:CP07 .
        _:guard sdmx-measure:obsValue ?CP07 .
        } UNION {
        _:guard property:coicop c:CP0711 .
        _:guard sdmx-measure:obsValue ?CP0711 .
        } UNION {
        _:guard property:coicop c:CP072 .
        _:guard sdmx-measure:obsValue ?CP072 .
        } UNION {
        _:guard property:coicop c:CP0731 .
        _:guard sdmx-measure:obsValue ?CP0731 .
        } UNION {
        _:guard property:coicop c:CP0732 .
        _:guard sdmx-measure:obsValue ?CP0732 .
        } UNION {
        _:guard property:coicop c:CP0733 .
        _:guard sdmx-measure:obsValue ?CP0733 .
        }  UNION {
        _:guard property:coicop c:CP0734 .
        _:guard sdmx-measure:obsValue ?CP0734 .
        } UNION {
        _:guard property:coicop c:CP00 .
        _:guard sdmx-measure:obsValue ?CP00 .
        } 
  } 
} group by ?date order by ?year