Interactive POS Demo

Task: Verify the Statement against the Table

Statement: on march 15 , 2007 and in region 4 , the highest number of episodes was 4

Generating plan to answer the query...

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

Step 2: Select rows where 'region_4' is '2007-03-15'.

Step 3: Select rows where 'episodes' is 4.

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

SELECT * FROM table_sql ORDER BY episodes DESC;

SELECT * FROM table_sql WHERE region_4 = '2007-03-15';

SELECT * FROM table_sql WHERE episodes = 4;

volume	discs	episodes	region_1	region_2	region_4
1	1	4	2006-01-31	2007-02-19	2007-03-15

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

volume	discs	episodes	region_1	region_2	region_4
1	1	4	2006-01-31	2007-02-19	2007-03-15

The statement is TRUE