stage date route terrain length winner
stage
date
route
terrain
length
winner
number
number parsed year month day
list length
first second first_number second_number
first second
number date <d, text> text unitnum(unitnum) text(text)
1 1 july saint-brieuc individual time trial 7.3 km (4.5 mi) jacky durand (fra)
which routes were at least 100 km ?
WDT NNS VBD-AUX IN JJS CD NN .
Dinan - Lannion|Perros-Guirec - Vitre|Alençon - Le Havre|Fécamp - Dunkerque|Dunkerque - Charleroi|Charleroi - Liège|Le Grand-Bornand - La Plagne|La Plagne - L'Alpe d'Huez|Le Bourg-d'Oisans - Saint-Étienne|Saint-Étienne - Mende|Mende - Revel|Saint-Orens-de-Gameville - Guzet-Neige|Saint-Girons - Cauterets|Tarbes - Pau|Pau - Bordeaux|Montpon-Ménestérol - Limoges|Sainte-Geneviève-des-Bois - Paris (Champs-Élysées)
select c3 from w where c5_first_number >= 100