Plan-of-SQLs Interface FN

Sample: 121/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: jose ortiz was the center in the oregon state jazz club from 1988 - 90

Table: utah jazz all - time roster

player nationality position years_for_jazz school___club_team
mehmet okur turkey forward - center 2004 - 11 efes pilsen ( turkey )
josã ortiz puerto rico center 1988 - 90 oregon state
greg ostertag united states center 1995 - 2004 , 2005 - 06 kansas
dan o 'sullivan united states center 1990 - 91 fordham
andre owens united states guard 2005 - 06 houston
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'player' is 'jose ortiz'.

Step 2: Select rows where 'position' is 'center'.

Step 3: Select rows where 'school___club_team' is 'oregon state'.

Step 4: Select rows where 'years_for_jazz' is '1988-90'.

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

Step 1: Select rows where 'player' is 'jose ortiz'.

SQL command for the step:

SELECT * FROM table_sql WHERE player = 'jose ortiz';
player nationality position years_for_jazz school___club_team
mehmet okur turkey forward - center 2004 - 11 efes pilsen ( turkey )
josã ortiz puerto rico center 1988 - 90 oregon state
greg ostertag united states center 1995 - 2004 , 2005 - 06 kansas
dan o 'sullivan united states center 1990 - 91 fordham
andre owens united states guard 2005 - 06 houston

Step 2: Select rows where 'position' is 'center'.

SQL command for the step:

SELECT * FROM table_sql WHERE position = 'center';
player nationality position years_for_jazz school___club_team

Step 3: Select rows where 'school___club_team' is 'oregon state'.

SQL command for the step:

SELECT * FROM table_sql WHERE school___club_team = 'oregon state';
player nationality position years_for_jazz school___club_team

Step 4: Select rows where 'years_for_jazz' is '1988-90'.

SQL command for the step:

SELECT * FROM table_sql WHERE years_for_jazz = '1988-90';
player nationality position years_for_jazz school___club_team

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

SQL command for the step:

SELECT CASE WHEN COUNT(*) = 1 THEN TRUE ELSE FALSE END AS verification FROM table_sql;
player nationality position years_for_jazz school___club_team

Verification:

The statement is FALSE