Plan-of-SQLs Interface FN

Sample: 89/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: vca 40t (44.1tons) and 155 mm (6.1in) l / 41 howitzer have a vctm of 26t (28.7tons) and 120 mm (4.72in) mortar respectively

Table: tam (tank)

vctp vca_155 vctm vcpc vclc vcrt
28.2 t (31.1 tons ) 40t (44.1tons) 26t (28.7tons) 25t (27.6tons) 32t (35.3tons) 32t (35.3tons)
20 mm (79in) rh - 202 autocannon 155 mm (6.1in) l / 41 howitzer 120 mm (4.72in) mortar 7.62 mm (0.3in) fn mag 60 - 20 machine gun 160 mm (6.3in) or 350 mm (13.8in) rockets 7.62 mm (0.3in) fn mag 60 - 20 machine gun
km (mi) - km (mi) - km (mi) km (mi)
24hp / t (23hp / ton) 18hp / t ( 16.5hp / ton) 28.8hp / t (25.1hp / ton) 28.8hp / t (25.1hp / ton) 22.5hp / t (20.4hp / ton) 22.5hp / t (20.4hp / ton)
75 km / h (47 mph) 55 km / h (34 mph) 75 km / h (47 mph) 75 km / h (47 mph) 75 km / h (47 mph) 75 km / h (47 mph)
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'vca_155' is '40t (44.1tons)'.

Step 2: Select rows where 'vctm' is '26t (28.7tons)'.

Step 3: Select rows where 'vctp' is '155 mm (6.1in) l / 41 howitzer'.

Step 4: Select rows where 'vcpc' is '120 mm (4.72in) mortar'.

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

Step 1: Select rows where 'vca_155' is '40t (44.1tons)'.

SQL command for the step:

SELECT * FROM table_sql WHERE vca_155 = '40t (44.1tons)';
vctp vca_155 vctm vcpc vclc vcrt
28.2 t (31.1 tons ) 40t (44.1tons) 26t (28.7tons) 25t (27.6tons) 32t (35.3tons) 32t (35.3tons)
20 mm (79in) rh - 202 autocannon 155 mm (6.1in) l / 41 howitzer 120 mm (4.72in) mortar 7.62 mm (0.3in) fn mag 60 - 20 machine gun 160 mm (6.3in) or 350 mm (13.8in) rockets 7.62 mm (0.3in) fn mag 60 - 20 machine gun
km (mi) - km (mi) - km (mi) km (mi)
24hp / t (23hp / ton) 18hp / t ( 16.5hp / ton) 28.8hp / t (25.1hp / ton) 28.8hp / t (25.1hp / ton) 22.5hp / t (20.4hp / ton) 22.5hp / t (20.4hp / ton)
75 km / h (47 mph) 55 km / h (34 mph) 75 km / h (47 mph) 75 km / h (47 mph) 75 km / h (47 mph) 75 km / h (47 mph)

Step 2: Select rows where 'vctm' is '26t (28.7tons)'.

SQL command for the step:

SELECT * FROM table_sql WHERE vctm = '26t (28.7tons)';
vctp vca_155 vctm vcpc vclc vcrt
28.2 t (31.1 tons ) 40t (44.1tons) 26t (28.7tons) 25t (27.6tons) 32t (35.3tons) 32t (35.3tons)

Step 3: Select rows where 'vctp' is '155 mm (6.1in) l / 41 howitzer'.

SQL command for the step:

SELECT * FROM table_sql WHERE vctp = '155 mm (6.1in) l / 41 howitzer';
vctp vca_155 vctm vcpc vclc vcrt
28.2 t (31.1 tons ) 40t (44.1tons) 26t (28.7tons) 25t (27.6tons) 32t (35.3tons) 32t (35.3tons)

Step 4: Select rows where 'vcpc' is '120 mm (4.72in) mortar'.

SQL command for the step:

SELECT * FROM table_sql WHERE vcpc = '120 mm (4.72in) mortar';
vctp vca_155 vctm vcpc vclc vcrt

Step 5: Use a `CASE` statement to return TRUE if the number of rows for each step 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;
vctp vca_155 vctm vcpc vclc vcrt

Verification:

The statement is FALSE