Plan-of-SQLs Interface FN

Sample: 152/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: after 2000 england , the united states , brazil , and and puerto rico each contributed one player

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
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'nationality' is 'england', 'united states', 'brazil', or 'puerto rico'.

Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 4, otherwise return FALSE.

Step 1: Select rows where 'nationality' is 'england', 'united states', 'brazil', or 'puerto rico'.

SQL command for the step:

SELECT * FROM table_sql WHERE nationality IN ('england', 'united states', 'brazil', 'puerto rico');
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: Use a `CASE` statement to return TRUE if the number of rows is equal to 4, otherwise return FALSE.

SQL command for the step:

SELECT CASE WHEN COUNT(*) = 4 THEN TRUE ELSE FALSE END AS verification FROM table_sql;
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

Verification:

The statement is FALSE