Plan-of-SQLs Interface TN

Sample: 1731/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: the actor of the character ariadne oliver is hugh fraser

Table: list of agatha christie 's poirot episodes

actor character title___rank series years
david suchet hercule poirot various 1 - 13 1989 - 2013
hugh fraser arthur hastings captain obe 1 - 8 , 13 1989 - 2002 , 2013
philip jackson james japp chief inspector 1 - 8 , 13 1989 - 2001 , 2013
pauline moran felicity lemon secretary 1 - 3 , 5 - 8 , 13 1989 - 1991 , 1993 - 2001 , 2013
zoë wanamaker ariadne oliver crime novelist 10 - 13 2006 - 2013
david yelland george butler 10 - 13 2006 - 2013
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'character' is 'ariadne oliver'.

Step 2: Select rows where 'actor' is 'hugh fraser'.

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

Step 1: Select rows where 'character' is 'ariadne oliver'.

SQL command for the step:

SELECT * FROM table_sql WHERE character = 'ariadne oliver';
actor character title___rank series years
david suchet hercule poirot various 1 - 13 1989 - 2013
hugh fraser arthur hastings captain obe 1 - 8 , 13 1989 - 2002 , 2013
philip jackson james japp chief inspector 1 - 8 , 13 1989 - 2001 , 2013
pauline moran felicity lemon secretary 1 - 3 , 5 - 8 , 13 1989 - 1991 , 1993 - 2001 , 2013
zoë wanamaker ariadne oliver crime novelist 10 - 13 2006 - 2013
david yelland george butler 10 - 13 2006 - 2013

Step 2: Select rows where 'actor' is 'hugh fraser'.

SQL command for the step:

SELECT * FROM table_sql WHERE actor = 'hugh fraser';
actor character title___rank series years
zoë wanamaker ariadne oliver crime novelist 10 - 13 2006 - 2013

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

SQL command for the step:

SELECT CASE WHEN COUNT(*) = 1 THEN TRUE ELSE FALSE END AS verification FROM table_sql;
actor character title___rank series years

Verification:

The statement is FALSE