Step 1: Select rows where 'years_for_jazz' is after 2000.
| player |
nationality |
position |
years_for_jazz |
school___club_team |
| rick adelman |
united states |
guard |
1974-01-01 |
loyola (ca) |
| john amaechi |
england |
center / forward |
2001-03-01 |
penn state |
| louis amundson |
united states |
forward |
2007-01-01 |
unlv |
| j j anderson |
united states |
forward |
1982-01-01 |
bradley |
| shandon anderson |
united states |
guard / forward |
9999-01-01 |
georgia |
| rafael araãjo |
brazil |
center |
2006-01-01 |
byu |
| carlos arroyo |
puerto rico |
guard |
2002-05-01 |
florida international |
| isaac austin |
united states |
center |
1991-01-01 |
arizona state |
| anthony avent |
united states |
forward |
1998-01-01 |
seton hall |
Step 2: Select rows where 'nationality' is either 'brazil' or 'england'.
| player |
nationality |
position |
years_for_jazz |
school___club_team |
| john amaechi |
england |
center / forward |
2001-03-01 |
penn state |
| louis amundson |
united states |
forward |
2007-01-01 |
unlv |
| shandon anderson |
united states |
guard / forward |
9999-01-01 |
georgia |
| rafael araãjo |
brazil |
center |
2006-01-01 |
byu |
| carlos arroyo |
puerto rico |
guard |
2002-05-01 |
florida international |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 2, otherwise return FALSE.
| player |
nationality |
position |
years_for_jazz |
school___club_team |
| john amaechi |
england |
center / forward |
2001-03-01 |
penn state |
| rafael araãjo |
brazil |
center |
2006-01-01 |
byu |