Step 1: Select rows where 'gold' is 'nadia al - moutawaa'.
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: Select rows where 'silver' is not 'nadia al - moutawaa'.
year |
location |
gold |
silver |
bronze |
1982 |
new delhi |
nadia al - moutawaa |
jamila al - moutawaa |
bariaa salem al - sabbah |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
year |
location |
gold |
silver |
bronze |
1982 |
new delhi |
nadia al - moutawaa |
jamila al - moutawaa |
bariaa salem al - sabbah |
Prediction: TRUE