Step 1: Select rows where 'lead' is 'steve gould'.
skip |
third___vice_skip |
second |
lead |
city |
kerry burtnyk |
don walchuk |
richard daneault |
garth smith |
winnipeg |
pat simmons |
gerry adam |
jeff sharp |
steve laycock |
davidson |
jeff stoughton |
kevin park |
rob fowler |
steve gould |
winnipeg |
wayne middaugh |
jon mead |
john epping |
scott bailey |
islington |
brad gushue |
mark nichols |
ryan fry |
jamie korab |
st john 's |
mike mcewen |
b j neufeld |
matt wozniak |
denni neufeld |
winnipeg |
joel jordison |
scott bitz |
aryn schmidt |
dean hicke |
moose jaw |
bob ursel |
jim cotter |
kevin folk |
rick sawatsky |
kelowna |
jean - michel ménard |
martin crête |
éric sylvain |
jean gagnon |
lévis |
ted appelman |
tom appelman |
bradon klassen |
brendan melnyk |
edmonton |
greg mcaulay |
ken maskiewich |
deane horning |
aaron watson |
richmond |
jason gunnlaugson |
justin richter |
braden zawada |
tyler forrest |
beausejour |
Step 2: Select rows where 'city' is 'richmond'.
skip |
third___vice_skip |
second |
lead |
city |
jeff stoughton |
kevin park |
rob fowler |
steve gould |
winnipeg |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
skip |
third___vice_skip |
second |
lead |
city |
Final output table:
verification_result |
FALSE |
Prediction: FALSE