Step 1: Select rows where 'year' is not 1994 or 1998.
year |
location |
gold |
silver |
bronze |
1982 |
new delhi |
nadia al - moutawaa |
jamila al - moutawaa |
bariaa salem al - sabbah |
1986 |
seoul |
takashi tomura |
shuichi toki |
ryuzo okuno |
1994 |
hiroshima |
konoshin kuwahara |
ryuzo okuno |
natya chantrasmi |
1998 |
bangkok |
jin kanno |
sohn bong - gak |
quzier ambak fathil |
2002 |
busan |
mikaela marãa jaworski |
lee jin - kyung |
tadayoshi hayashi |
2006 |
doha |
ali yousuf al - rumaihi |
jasmine chen - shao man |
joo jung - hyun |
2010 |
guangzhou |
ramzy al duhami |
latifa al maktom |
khaled al - eid |
Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to the number of rows in the original table minus 2, otherwise return FALSE.
year |
location |
gold |
silver |
bronze |
1982 |
new delhi |
nadia al - moutawaa |
jamila al - moutawaa |
bariaa salem al - sabbah |
1986 |
seoul |
takashi tomura |
shuichi toki |
ryuzo okuno |
2002 |
busan |
mikaela marãa jaworski |
lee jin - kyung |
tadayoshi hayashi |
2006 |
doha |
ali yousuf al - rumaihi |
jasmine chen - shao man |
joo jung - hyun |
2010 |
guangzhou |
ramzy al duhami |
latifa al maktom |
khaled al - eid |
Final output table:
verification_result |
FALSE |
Prediction: FALSE
Ground-truth: FALSE