Plan-of-SQLs (Ours)


Statement: equestrian at the asian games has been located in a different city every year that it occurred except 1994 and 1998

Ground-truth: FALSE

Input Table: equestrian at the asian games

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