Plan-of-SQLs Interface TN

Sample: 1933/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: for centru county , the percentage of total exports is 13.8% and the percentage of total imports is 11.2%

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 'centru'.

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

Step 3: Extract the numerical value from the 'percent_of_total_imports' column then add column 'imports_percent' to the existing table.

Step 4: Select rows where 'exports_percent' is 13.8%.

Step 5: Select rows where 'imports_percent' is 11.2%.

Step 6: 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 'centru'.

SQL command for the step:

SELECT * FROM table_sql WHERE county = 'centru';
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 'percent_of_total_exports' column then add column 'exports_percent' to the existing table.

SQL command for the step:

ALTER TABLE table_sql ADD COLUMN exports_percent NUMERIC; UPDATE table_sql SET exports_percent = CAST(percent_of_total_exports AS NUMERIC);
county exports__us_mil_ percent_of_total_exports imports__us_mil_ percent_of_total_imports
centru 5338 12.8 % 7.879.4 11.8 %

Step 3: Extract the numerical value from the 'percent_of_total_imports' column then add column 'imports_percent' to the existing table.

SQL command for the step:

ALTER TABLE table_sql ADD COLUMN imports_percent NUMERIC; UPDATE table_sql SET imports_percent = CAST(percent_of_total_imports AS NUMERIC);
county exports__us_mil_ percent_of_total_exports imports__us_mil_ percent_of_total_imports exports_percent
centru 5338 12.8 % 7.879.4 11.8 % 12.8

Step 4: Select rows where 'exports_percent' is 13.8%.

SQL command for the step:

SELECT * FROM table_sql WHERE exports_percent = 13.8;
county exports__us_mil_ percent_of_total_exports imports__us_mil_ percent_of_total_imports exports_percent imports_percent
centru 5338 12.8 % 7.879.4 11.8 % 12.8 118.0

Step 5: Select rows where 'imports_percent' is 11.2%.

SQL command for the step:

SELECT * FROM table_sql WHERE imports_percent = 11.2;
county exports__us_mil_ percent_of_total_exports imports__us_mil_ percent_of_total_imports exports_percent imports_percent

Step 6: 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_percent imports_percent

Verification:

The statement is FALSE