Step 1: Select rows where 'date' is '9999-10-09'.
date |
event |
winner |
team |
series_leader |
9999-02-24 |
tour du haut var |
davide rebellin ( ita ) |
gerolsteiner |
rinaldo nocentini ( ita ) |
9999-03-23 |
cholet - pays de loire |
janek tombak ( est ) |
mitsubishi - jartazi |
rinaldo nocentini ( ita ) |
9999-04-06 |
grand prix de rennes |
mikhaylo khalilov ( ukr ) |
ceramica flaminia - bossini docce |
jimmy casper ( fra ) |
'9999-04-15' |
paris - camembert |
alejandro valverde ( esp ) |
caisse d'epargne |
jérôme pineau ( fra ) |
0000-04-17 |
grand prix de denain |
edvald boasson hagen ( nor ) |
team high road |
jimmy casper ( fra ) |
9999-04-19 |
tour du finistère |
david lelay ( fra ) |
bretagne - armor lux |
jimmy casper ( fra ) |
9999-04-20 |
tro - bro léon |
frédéric guesdon ( fra ) |
française des jeux |
jimmy casper ( fra ) |
9999-05-04 |
trophée des grimpeurs |
david lelay ( fra ) |
bretagne - armor lux |
david lelay ( fra ) |
9999-05-31 |
grand prix de plumelec - morbihan |
thomas voeckler ( fra ) |
bouygues télécom |
david lelay ( fra ) |
9999-08-03 |
polynormande |
arnaud gérard ( fra ) |
française des jeux |
jérôme pineau ( fra ) |
9999-08-31 |
chteauroux classic |
anthony ravard ( fra ) |
agritubel |
jérôme pineau ( fra ) |
9999-09-21 |
grand prix d'isbergues |
william bonnet ( fra ) |
crédit agricole |
jérôme pineau ( fra ) |
9999-10-05 |
tour de vendée |
koldo fernández ( esp ) |
euskaltel - euskadi |
jérôme pineau ( fra ) |
9999-10-09 |
paris - bourges |
bernhard eisel ( aut ) |
team columbia |
jérôme pineau ( fra ) |
Step 2: Select rows where 'series_leader' is 'jérôme pineau ( fra )'.
date |
event |
winner |
team |
series_leader |
9999-10-09 |
paris - bourges |
bernhard eisel ( aut ) |
team columbia |
jérôme pineau ( fra ) |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
date |
event |
winner |
team |
series_leader |
9999-10-09 |
paris - bourges |
bernhard eisel ( aut ) |
team columbia |
jérôme pineau ( fra ) |
Prediction: TRUE
Ground-truth: TRUE