Plan-of-SQLs Interface TP

Sample: 1931/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: vest county makes 6.270.2 in exports

Table: list of romanian counties by foreign trade

county exports__us_mil_ percent_of_total_exports imports__us_mil_ percent_of_total_imports
bucharest - ilfov 8001.2 19.2 % 26557.8 39.8 %
sud - muntenia 6300 , 7 15.1 % 6785.5 10.2 %
vest 6270.2 15.0 % 6597.6 9.9 %
sud - est 5762 13.8 % 7501.9 11.2 %
centru 5338 12.8 % 7.879.4 11.8 %
nord - vest 4726.6 11.3 % 6999.1 10.5 %
sud - vest oltenia 3226.2 7.7 % 2007.8 3.0 %
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'county' is 'vest'.

Step 2: Extract the numerical value from the 'exports__us_mil_' column then add column 'exports' to existing table.

Step 3: Select rows where 'exports' is 6270.2.

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 'county' is 'vest'.

SQL command for the step:

SELECT * FROM table_sql WHERE county = 'vest';
county exports__us_mil_ percent_of_total_exports imports__us_mil_ percent_of_total_imports
bucharest - ilfov 8001.2 19.2 % 26557.8 39.8 %
sud - muntenia 6300 , 7 15.1 % 6785.5 10.2 %
vest 6270.2 15.0 % 6597.6 9.9 %
sud - est 5762 13.8 % 7501.9 11.2 %
centru 5338 12.8 % 7.879.4 11.8 %
nord - vest 4726.6 11.3 % 6999.1 10.5 %
sud - vest oltenia 3226.2 7.7 % 2007.8 3.0 %

Step 2: Extract the numerical value from the 'exports__us_mil_' column then add column 'exports' to existing table.

SQL command for the step:

ALTER TABLE table_sql ADD COLUMN exports NUMERIC; UPDATE table_sql SET exports = CAST(exports__us_mil_ AS NUMERIC);
county exports__us_mil_ percent_of_total_exports imports__us_mil_ percent_of_total_imports
vest 6270.2 15.0 % 6597.6 9.9 %

Step 3: Select rows where 'exports' is 6270.2.

SQL command for the step:

SELECT * FROM table_sql WHERE exports = 6270.2;
county exports__us_mil_ percent_of_total_exports imports__us_mil_ percent_of_total_imports exports
vest 6270.2 15.0 % 6597.6 9.9 % 6270.2

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;
county exports__us_mil_ percent_of_total_exports imports__us_mil_ percent_of_total_imports exports
vest 6270.2 15.0 % 6597.6 9.9 % 6270.2

Verification:

The statement is TRUE