Step 1: Select rows where 'competition' is 'olympic games'.
year |
competition |
venue |
position |
notes |
1984-01-01 |
new york city marathon |
new york , united states |
1st |
2:14:53 |
1985-01-01 |
new york city marathon |
new york , united states |
1st |
2:11:34 |
1986-01-01 |
european championships |
stuttgart , west germany |
2nd |
2:10:57 |
1987-01-01 |
world championships |
rome , italy |
7th |
2:14:03 |
1988-01-01 |
olympic games |
seoul , south korea |
16th |
2:15:20 |
1988-01-01 |
venice marathon |
venice , italy |
1st |
2:15:24 |
Step 2: Select rows where 'venue' is 'venice , italy'.
year |
competition |
venue |
position |
notes |
1988-01-01 |
olympic games |
seoul , south korea |
16th |
2:15:20 |
Step 3: Select rows where 'year' is 1984.
year |
competition |
venue |
position |
notes |
Step 4: Select rows where 'notes' is '2:10:57'.
year |
competition |
venue |
position |
notes |
Step 5: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
year |
competition |
venue |
position |
notes |
Final output table:
verification_result |
FALSE |
Prediction: FALSE