Plan-of-SQLs Interface FP

Sample: 1844/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: less than 3 teams hold a minus goal difference , while more than 5 have scored more goals against them

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: Select rows where the 'difference' column is less than 0.

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

Step 1: Select rows where the 'difference' column is less than 0.

SQL command for the step:

SELECT * FROM table_sql WHERE difference < 0;
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: Use a `CASE` statement to return TRUE if the number of rows is less than 3, otherwise return FALSE.

SQL command for the step:

SELECT CASE WHEN COUNT(*) < 3 THEN TRUE ELSE FALSE END AS verification FROM table_sql;
position team points played against difference

Verification:

The statement is TRUE