Plan-of-SQLs Interface FP

Sample: 151/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: of the three different position georgia and penn state contributed two of the same

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 'position' is 'guard' or 'forward'.

Step 2: Select rows where 'school___club_team' is 'georgia' or 'penn state'.

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 'position' is 'guard' or 'forward'.

SQL command for the step:

SELECT * FROM table_sql WHERE position IN ('guard', 'forward');
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 'school___club_team' is 'georgia' or 'penn state'.

SQL command for the step:

SELECT * FROM table_sql WHERE school___club_team IN ('georgia', 'penn state');
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
carlos arroyo puerto rico guard 2002-05-01 florida international
anthony avent united states forward 1998-01-01 seton hall

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
shandon anderson united states guard / forward 9999-01-01 georgia

Verification:

The statement is TRUE