Statement: after 2000 , only brazil and england contributed one player to the utah jazz
Input Table: utah jazz all - time roster
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 |
SQL Command:
SELECT
CASE
WHEN COUNT(*) = 2 THEN 'TRUE'
ELSE 'FALSE'
END
FROM table_sql
WHERE years_for_jazz > '2000-01-01'
AND (nationality = 'brazil' OR nationality = 'england');