Interactive POS Demo

Task: Verify the Statement against the Table

Statement: volume 5 , of 4 episodes , took place of september 19 , 2006 , in region 1

Generating plan to answer the query...

Step 1: Select rows where 'volume' is 5.

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

Step 3: Select rows where 'region_1' is '2006-09-19'.

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 WHERE volume = 5;

SELECT * FROM table_sql WHERE episodes = 4;

volume	discs	episodes	region_1	region_2	region_4
5	1	4	2006-09-19	2008-05-26	2009-03-05

SELECT * FROM table_sql WHERE region_1 = '2006-09-19';

volume	discs	episodes	region_1	region_2	region_4
5	1	4	2006-09-19	2008-05-26	2009-03-05

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

volume	discs	episodes	region_1	region_2	region_4
5	1	4	2006-09-19	2008-05-26	2009-03-05

The statement is TRUE