Step 1: Select rows where 'athlete' is 'bob beamon'.
mark |
wind |
athlete |
nationality |
venue |
date |
8.95 m (29ft4¼in) |
0.3 |
mike powell |
united states |
tokyo |
1991-08-30 |
8.90 m (29ft2¼in) a |
2.0 |
bob beamon |
united states |
mexico city |
1968-10-18 |
8.87 m (29ft1in) |
0.2 |
carl lewis |
united states |
tokyo |
1991-08-30 |
8.86 m (29ft0¾in) a |
1.9 |
robert emmiyan |
soviet union |
tsakhkadzor |
1987-05-22 |
8.74 m (28ft8in) |
1.4 |
larry myricks |
united states |
indianapolis |
1988-07-18 |
8.74 m (28ft8in) a |
2.0 |
erick walder |
united states |
el paso |
1994-04-02 |
8.74 m (28ft8in) |
1.2 |
dwight phillips |
united states |
eugene |
2009-06-07 |
8.73 m (28ft7½in) |
1.2 |
irving saladino |
panama |
hengelo |
2008-05-24 |
8.71 m (28ft6¾in) |
1.9 |
iván pedroso |
cuba |
salamanca |
1995-07-18 |
8.66 m (28ft4¾in) |
1.6 |
loúis tsátoumas |
greece |
kalamáta |
2007-06-02 |
Step 2: Extract the numerical year from the 'date' column to add column 'year' to existing table.
mark |
wind |
athlete |
nationality |
venue |
date |
8.90 m (29ft2¼in) a |
2.0 |
bob beamon |
united states |
mexico city |
1968-10-18 |
Step 3: Cast to INT and order the table by 'year' in ascending order and select the first row.
mark |
wind |
athlete |
nationality |
venue |
date |
year |
8.90 m (29ft2¼in) a |
2.0 |
bob beamon |
united states |
mexico city |
1968-10-18 |
1968 |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
mark |
wind |
athlete |
nationality |
venue |
date |
year |
int_year |
8.90 m (29ft2¼in) a |
2.0 |
bob beamon |
united states |
mexico city |
1968-10-18 |
1968 |
1968 |
Prediction: TRUE