Plan-of-SQLs Interface FN

Sample: 1947/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: the dundee hurricanes won the same number of games in 2003 and 2004

Table: dundee hurricanes

season division wins losses ties final_position notes
2003 bafl division 2 north 6 4 0 4 / 11 -
2004 bafl division 2 north 6 2 1 1 / 3 -
2005 bafl division 2 scottish 5 5 0 2 / 4 -
2006 bafl division 2 scottish 3 4 0 2 / 3 -
2007 bafl division 2 north 9 1 0 1 / 6 promoted to division 1 north
2008 bafl division 1 north 5 2 3 3 / 6 -
2009 bafl division 1 north 2 6 1 5 / 7 -
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'season' is 2003.

Step 2: Select rows where 'season' is 2004.

Step 3: Select rows where 'wins' is the same for both seasons.

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

Step 1: Select rows where 'season' is 2003.

SQL command for the step:

SELECT * FROM table_sql WHERE season = 2003;
season division wins losses ties final_position notes
2003 bafl division 2 north 6 4 0 4 / 11 -
2004 bafl division 2 north 6 2 1 1 / 3 -
2005 bafl division 2 scottish 5 5 0 2 / 4 -
2006 bafl division 2 scottish 3 4 0 2 / 3 -
2007 bafl division 2 north 9 1 0 1 / 6 promoted to division 1 north
2008 bafl division 1 north 5 2 3 3 / 6 -
2009 bafl division 1 north 2 6 1 5 / 7 -

Step 2: Select rows where 'season' is 2004.

SQL command for the step:

SELECT * FROM table_sql WHERE season = 2004;
season division wins losses ties final_position notes
2003 bafl division 2 north 6 4 0 4 / 11 -

Step 3: Select rows where 'wins' is the same for both seasons.

SQL command for the step:

SELECT * FROM table_sql WHERE wins_season1 = wins_season2;
season division wins losses ties final_position notes

Step 4: 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;
season division wins losses ties final_position notes

Verification:

The statement is FALSE