Plan-of-SQLs Interface TP

Sample: 211/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: the highest number of discs released for any of the volumes is only 1

Table: none

volume discs episodes region_1 region_2 region_4
1 1 4 2006-01-31 2007-02-19 2007-03-15
2 1 4 2006-03-28 2007-06-04 2007-07-05
3 1 4 2006-05-30 2007-09-03 2008-03-13
4 1 4 2006-07-18 2008-02-18 2008-06-19
5 1 4 2006-09-19 2008-05-26 2009-03-05
Generating plan to answer the query...

Generated steps

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

Step 2: Select row number 1.

Step 3: Select rows where 'discs' is greater than 1.

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 'discs' in descending order.

SQL command for the step:

SELECT * FROM table_sql ORDER BY discs DESC;
volume discs episodes region_1 region_2 region_4
1 1 4 2006-01-31 2007-02-19 2007-03-15
2 1 4 2006-03-28 2007-06-04 2007-07-05
3 1 4 2006-05-30 2007-09-03 2008-03-13
4 1 4 2006-07-18 2008-02-18 2008-06-19
5 1 4 2006-09-19 2008-05-26 2009-03-05

Step 2: Select row number 1.

SQL command for the step:

SELECT * FROM table_sql LIMIT 1;
volume discs episodes region_1 region_2 region_4
1 1 4 2006-01-31 2007-02-19 2007-03-15
2 1 4 2006-03-28 2007-06-04 2007-07-05
3 1 4 2006-05-30 2007-09-03 2008-03-13
4 1 4 2006-07-18 2008-02-18 2008-06-19
5 1 4 2006-09-19 2008-05-26 2009-03-05

Step 3: Select rows where 'discs' is greater than 1.

SQL command for the step:

SELECT * FROM table_sql WHERE discs > 1;
volume discs episodes region_1 region_2 region_4
1 1 4 2006-01-31 2007-02-19 2007-03-15

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;
volume discs episodes region_1 region_2 region_4

Verification:

The statement is TRUE