Plan-of-SQLs Interface FP

Sample: 157/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: after 2000 , only brazil and england contributed one player to the utah jazz

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 'years_for_jazz' is after 2000.

Step 2: Select rows where 'nationality' is either 'brazil' or 'england'.

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

Step 1: Select rows where 'years_for_jazz' is after 2000.

SQL command for the step:

SELECT * FROM table_sql WHERE years_for_jazz > 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'.

SQL command for the step:

SELECT * FROM table_sql WHERE nationality IN ('brazil', '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.

SQL command for the step:

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

Verification:

The statement is TRUE