Interactive POS Demo

Task: Verify the Statement against the Table

Statement: none teams tied on points , but most were separated by more than 1 goal difference

Table: 1940 in brazilian football

position	team	points	played	against	difference
1	flamengo	13	8	12	8
2	fluminense	13	8	15	10
3	corinthians	9	8	15	4
4	palestra itália	8	8	19	3
5	portuguesa	7	8	23	- 10
6	botafogo	6	8	25	0
7	vasco da gama	6	8	19	- 2
8	américa	6	8	25	- 10
9	são paulo	4	8	24	- 13

Generating plan to answer the query...

Generated steps

Step 1: Order the table by 'points' in descending order.

Step 2: Select row number 1.

Step 3: Select rows where 'team' is not 'flamengo'.

Step 4: 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 'points' in descending order.

SQL command for the step:

SELECT * FROM table_sql ORDER BY points DESC;

position	team	points	played	against	difference
1	flamengo	13	8	12	8
2	fluminense	13	8	15	10
3	corinthians	9	8	15	4
4	palestra itália	8	8	19	3
5	portuguesa	7	8	23	- 10
6	botafogo	6	8	25	0
7	vasco da gama	6	8	19	- 2
8	américa	6	8	25	- 10
9	são paulo	4	8	24	- 13

Step 2: Select row number 1.

SQL command for the step:

SELECT * FROM table_sql LIMIT 1;

position	team	points	played	against	difference
1	flamengo	13	8	12	8
2	fluminense	13	8	15	10
3	corinthians	9	8	15	4
4	palestra itália	8	8	19	3
5	portuguesa	7	8	23	- 10
6	botafogo	6	8	25	0
7	vasco da gama	6	8	19	- 2
8	américa	6	8	25	- 10
9	são paulo	4	8	24	- 13

Step 3: Select rows where 'team' is not 'flamengo'.

SQL command for the step:

SELECT * FROM table_sql WHERE team <> 'flamengo';

position	team	points	played	against	difference
1	flamengo	13	8	12	8

Step 4: 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;

position

team

points

played

against

difference

Verification:

The statement is TRUE