Possibilities of using Selected Visualization Methods for Historical Analysis of Sporting Event – An Example of Stage Cycling Race Tour de France
and
Sep 06, 2018
About this article
Published Online: Sep 06, 2018
Page range: 5 - 22
Received: Oct 04, 2016
DOI: https://doi.org/10.2478/quageo-2018-0022
Keywords
© 2018 Vladimír Bačík et al., published by Sciendo
This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.
Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Examples of selection of necessary data based on query above database tables_
| Question | SQL syntax |
|---|---|
| How many stage finish places were included in the itinerary of the Tour de France before World War II? | Select*, COUNT(finish) AS count_places from tdf_stage_winners,tdf_places WHERE tdf_stage_winners.id_finish=tdf_places. id_place AND year >= 1903 AND year <= 1939 GROUP BY id_finish ORDER BY ‘count_places‘ DESC”); |
| How many cyclists won in individual stages in all editions of the Tour de France? | Select winner,nationality,COUNT(winner) AS countw from tdf_ stage_winners WHERE winner != ‘’ AND year >= 1903 AND rok <= 2015 GROUP BY winner ORDER BY ‘countw‘ DESC”); |
| What are the most successful nations as regards the number of triumphs in mountain crossings? | Select nationality,COUNT(cyclist_name) AS countc from tdf_asc_ cross WHERE year >= 1903 AND year <= 2015 GROUP BY nationality ORDER BY ‘countc‘ DESC”); |
| Which cyclists triumphed more than 1 time in Paris? | Select winner,COUNT(*) AS countw from ‘tdf_stage_winners‘ WHERE id_finish = 434 GROUP BY winner HAVING countw>1 ORDER BY ‘countw‘ DESC |
| Which are the 10 most frequently climbs included in the Tour de France editions after 1980? | Select *,COUNT(cyclist_name) AS countcn from tdf_ascents,tdf_ asc_cross WHERE tdf_ascents.id_ascent=tdf_asc_cross.id_ascent AND rok >= $1980 AND rok <= $2015 GROUP BY id_ascent ORDER BY ‘countcn‘ DESC LIMIT 10 |
| Which are the 5 most frequently starting places included in the history of the Tour de France? | Select *,COUNT(start) AS counts from tdf_stage_winnrs,tdf_places WHERE tdf_stage_winners.id_start=tdf_places.id_place AND year >= 1903 AND rok <= 2015 GROUP BY id_start ORDER BY ‘counts‘ DESC LIMIT 5 |