Plan-of-SQLs Interface TP

Sample: 150/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: the utah jazz had six player from the united states

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 'united states'.

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

Step 1: Select rows where 'nationality' is 'united states'.

SQL command for the step:

SELECT * FROM table_sql WHERE nationality = 'united states';
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 6, otherwise return FALSE.

SQL command for the step:

SELECT CASE WHEN COUNT(*) = 6 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)
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
isaac austin united states center 1991-01-01 arizona state
anthony avent united states forward 1998-01-01 seton hall

Verification:

The statement is TRUE