Step 1: Select rows where 'player' is 'andre owens'.
player |
nationality |
position |
years_for_jazz |
school___club_team |
mehmet okur |
turkey |
forward - center |
2004 - 11 |
efes pilsen ( turkey ) |
josã ortiz |
puerto rico |
center |
1988 - 90 |
oregon state |
greg ostertag |
united states |
center |
1995 - 2004 , 2005 - 06 |
kansas |
dan o 'sullivan |
united states |
center |
1990 - 91 |
fordham |
andre owens |
united states |
guard |
2005 - 06 |
houston |
Step 2: Select rows where 'school___club_team' is 'houston'.
player |
nationality |
position |
years_for_jazz |
school___club_team |
andre owens |
united states |
guard |
2005 - 06 |
houston |
Step 3: Select rows where 'years_for_jazz' is '2005-06'.
player |
nationality |
position |
years_for_jazz |
school___club_team |
andre owens |
united states |
guard |
2005 - 06 |
houston |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
player |
nationality |
position |
years_for_jazz |
school___club_team |