Step 1: Select rows where 'lead' is 'brendan melnyk'.
| 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 'skip' is 'ted appelman'.
| skip |
third___vice_skip |
second |
lead |
city |
| ted appelman |
tom appelman |
bradon klassen |
brendan melnyk |
edmonton |
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 |
| ted appelman |
tom appelman |
bradon klassen |
brendan melnyk |
edmonton |