Plan-of-SQLs Interface TP

Sample: 1767/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: 9 adr has a bore of mm (in) just like every other bore in the table

Table: salmson

name cyl bore capacity power weight
9 ad 9 - cyl radial mm (in) l (cuin) at 2000 rpm weight kg (lb)
9 adb 9 - cyl radial mm (in) l (cuin) at 2200 rpm weight kg (lb)
9 adr 9 - cyl radial mm (in) l (cuin) at 2700 rpm weight kg (lb)
7 ac 7 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 ac 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 nc 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 nct 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 ab 9 - cyl radial mm (in) l (cuin) at 1700 rpm weight kg (lb)
9 na 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 nas 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
18 ab 18 - cyl 2 - row radial mm (in) l (cuin) at 1700 rpm weight kg (lb)
18 abs 18 - cyl 2 - row radial mm (in) l (cuin) at 1700 rpm weight kg (lb)
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'bore' is equal to the value of 'bore' in row 3 (9 adr).

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

Step 1: Select rows where 'bore' is equal to the value of 'bore' in row 3 (9 adr).

SQL command for the step:

SELECT * FROM table_sql WHERE bore = (SELECT bore FROM table_sql LIMIT 1 OFFSET 2);
name cyl bore capacity power weight
9 ad 9 - cyl radial mm (in) l (cuin) at 2000 rpm weight kg (lb)
9 adb 9 - cyl radial mm (in) l (cuin) at 2200 rpm weight kg (lb)
9 adr 9 - cyl radial mm (in) l (cuin) at 2700 rpm weight kg (lb)
7 ac 7 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 ac 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 nc 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 nct 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 ab 9 - cyl radial mm (in) l (cuin) at 1700 rpm weight kg (lb)
9 na 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 nas 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
18 ab 18 - cyl 2 - row radial mm (in) l (cuin) at 1700 rpm weight kg (lb)
18 abs 18 - cyl 2 - row radial mm (in) l (cuin) at 1700 rpm weight kg (lb)

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

SQL command for the step:

SELECT CASE WHEN (SELECT COUNT(*) FROM table_sql) = (SELECT COUNT(*) FROM table_sql) THEN TRUE ELSE FALSE END AS verification;
name cyl bore capacity power weight
9 ad 9 - cyl radial mm (in) l (cuin) at 2000 rpm weight kg (lb)
9 adb 9 - cyl radial mm (in) l (cuin) at 2200 rpm weight kg (lb)
9 adr 9 - cyl radial mm (in) l (cuin) at 2700 rpm weight kg (lb)
7 ac 7 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 ac 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 nc 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 nct 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 ab 9 - cyl radial mm (in) l (cuin) at 1700 rpm weight kg (lb)
9 na 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
9 nas 9 - cyl radial mm (in) l (cuin) at 1800 rpm weight kg (lb)
18 ab 18 - cyl 2 - row radial mm (in) l (cuin) at 1700 rpm weight kg (lb)
18 abs 18 - cyl 2 - row radial mm (in) l (cuin) at 1700 rpm weight kg (lb)

Verification:

The statement is TRUE