Plan-of-SQLs Interface TN

Sample: 1903/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: the name of the visitor in vancouver on february 24 , is winnipeg

Table: 1992 - 93 vancouver canucks season

date visitor score home decision attendance record
01-02-9999 minnesota 5 - 4 vancouver mclean 14830 29 - 15 - 8
9999-02-03 tampa bay 2 - 4 vancouver whitmore 14171 30 - 15 - 8
9999-02-09 vancouver 5 - 1 quebec mclean 14360 31 - 15 - 8
01-02-11 vancouver 2 - 5 toronto mclean 15720 31 - 16 - 8
01-02-12 vancouver 3 - 1 buffalo whitmore 16325 32 - 16 - 8
01-02-15 vancouver 0 - 3 los angeles mclean 16005 32 - 17 - 8
9999-02-18 philadelphia 3 - 2 vancouver whitmore 16150 32 - 18 - 8
9999-02-20 winnipeg 2 - 4 vancouver mclean 16150 33 - 18 - 8
9999-02-22 toronto 8 - 1 vancouver mclean 16150 33 - 19 - 8
9999-02-24 ny rangers 4 - 5 vancouver whitmore 16150 34 - 19 - 8
9999-02-26 vancouver 7 - 4 winnipeg mclean 15398 35 - 19 - 8
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'date' is '9999-02-24'.

Step 2: Select rows where 'home' is 'vancouver'.

Step 3: Select rows where 'visitor' is 'winnipeg'.

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

Step 1: Select rows where 'date' is '9999-02-24'.

SQL command for the step:

SELECT * FROM table_sql WHERE date = '9999-02-24';
date visitor score home decision attendance record
01-02-9999 minnesota 5 - 4 vancouver mclean 14830 29 - 15 - 8
9999-02-03 tampa bay 2 - 4 vancouver whitmore 14171 30 - 15 - 8
9999-02-09 vancouver 5 - 1 quebec mclean 14360 31 - 15 - 8
01-02-11 vancouver 2 - 5 toronto mclean 15720 31 - 16 - 8
01-02-12 vancouver 3 - 1 buffalo whitmore 16325 32 - 16 - 8
01-02-15 vancouver 0 - 3 los angeles mclean 16005 32 - 17 - 8
9999-02-18 philadelphia 3 - 2 vancouver whitmore 16150 32 - 18 - 8
9999-02-20 winnipeg 2 - 4 vancouver mclean 16150 33 - 18 - 8
9999-02-22 toronto 8 - 1 vancouver mclean 16150 33 - 19 - 8
9999-02-24 ny rangers 4 - 5 vancouver whitmore 16150 34 - 19 - 8
9999-02-26 vancouver 7 - 4 winnipeg mclean 15398 35 - 19 - 8

Step 2: Select rows where 'home' is 'vancouver'.

SQL command for the step:

SELECT * FROM table_sql WHERE home = 'vancouver';
date visitor score home decision attendance record
9999-02-24 ny rangers 4 - 5 vancouver whitmore 16150 34 - 19 - 8

Step 3: Select rows where 'visitor' is 'winnipeg'.

SQL command for the step:

SELECT * FROM table_sql WHERE visitor = 'winnipeg';
date visitor score home decision attendance record
9999-02-24 ny rangers 4 - 5 vancouver whitmore 16150 34 - 19 - 8

Step 4: 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;
date visitor score home decision attendance record

Verification:

The statement is FALSE