Step 1: Select rows where 'athlete' is 'milcah chemos'.
event |
record |
athlete |
nationality |
date |
100 m |
10.72 ( - 0.3 m / s) |
shelly - ann fraser - pryce |
jamaica |
2013-09-06 |
200 m |
21.64 ( + 0.8 m / s) |
merlene ottey |
jamaica |
1991-09-13 |
400 m |
48.83 |
sanya richards |
united states |
2009-09-04 |
800 m |
1:55.16 |
pamela jelimo |
kenya |
2008-09-06 |
1000 m |
2:28.98 |
svetlana masterkova |
russia |
1996-08-23 |
1500 m |
3:55.33 |
süreyya ayhan |
turkey |
2003-09-05 |
mile |
4:17.75 |
maryam yusuf jamal |
bahrain |
2007-09-14 |
2000 m |
5:30.19 |
gelete burka |
ethiopia |
2009-09-04 |
3000 m |
8:24.81 + |
meseret defar |
ethiopia |
2007-09-14 |
two miles |
8:58.58 |
meseret defar |
ethiopia |
2007-09-14 |
5000 m |
14:25.43 |
vivian cheruiyot |
kenya |
2008-09-06 |
100 m hurdles |
12.42 ( - 0.3 m / s) |
yordanka donkova |
bulgaria |
1986-09-05 |
400 m hurdles |
53.43 |
nezha bidouane |
morocco |
1998-08-28 |
3000 m steeplechase |
9:15.06 |
milcah chemos |
kenya |
2013-09-06 |
high jump |
2.05 m |
anna chicherova |
russia |
2011-09-16 |
pole vault |
4.93 m |
yelena isinbayeva |
russia |
2005-08-26 |
long jump |
7.25 m ( + 1.7 m / s) |
heike drechsler |
germany |
1991-09-13 |
triple jump |
15.14 m ( + 0.3 m / s) |
tatyana lebedeva |
russia |
2003-09-05 |
shot put |
20.57 m |
natalya lisovskaya |
soviet union |
1987-09-11 |
discus throw |
69.84 m |
tsvetanka christova |
bulgaria |
1986-09-05 |
javelin throw |
72.18 m ( old design ) 67.76 m ( current design ) |
fatima whitbread trine hattestad |
united kingdom norway |
1986-09-05 |
4100 m relay |
42.97 |
united states |
united states |
1988-08-19 |
Step 2: Select rows where 'event' is '3000 m steeplechase'.
event |
record |
athlete |
nationality |
date |
3000 m steeplechase |
9:15.06 |
milcah chemos |
kenya |
2013-09-06 |
Step 3: Select rows where 'record' is '9:15.06'.
event |
record |
athlete |
nationality |
date |
3000 m steeplechase |
9:15.06 |
milcah chemos |
kenya |
2013-09-06 |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
event |
record |
athlete |
nationality |
date |
3000 m steeplechase |
9:15.06 |
milcah chemos |
kenya |
2013-09-06 |
Prediction: TRUE