Interactive POS Demo

Task: Verify the Statement against the Table

Statement: the dundee hurricanes did not win the same number of games in any of the seasons they played between 2003 and 2009

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: Order the table by 'season' in ascending order.

Step 2: Select rows where the 'wins' column has the same value as any other row.

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

Step 1: Order the table by 'season' in ascending order.

SQL command for the step:

SELECT * FROM table_sql ORDER BY season ASC;

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 the 'wins' column has the same value as any other row.

SQL command for the step:

SELECT * FROM table_sql a WHERE EXISTS (SELECT 1 FROM table_sql b WHERE a.wins = b.wins AND a.id <> b.id);

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 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 0, otherwise return FALSE.

SQL command for the step:

SELECT CASE WHEN COUNT(*) = 0 THEN TRUE ELSE FALSE END AS verification FROM table_sql;

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	-
2008	bafl division 1 north	5	2	3	3 / 6	-

Verification:

The statement is FALSE