Plan-of-SQLs Interface TP

Sample: 1723/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: california 22 , a newly created district , resulted in a republican gain

Table: united states house of representatives elections , 1942

district incumbent party first_elected result candidates
california 2 harry lane englebright republican 1926-01-01 re - elected harry lane englebright (r) unopposed
california 4 thomas rolph republican 1940-01-01 re - elected thomas rolph (r) 98.3% archie brown ( w / i ) 1.7%
california 7 john h tolan democratic 1934-01-01 re - elected john h tolan (d) unopposed
california 9 bertrand w gearhart republican 1934-01-01 re - elected bertrand w gearhart (r) unopposed
california 10 alfred j elliott democratic 1937-01-01 re - elected alfred j elliott (d) unopposed
california 17 cecil r king democratic 1942-08-25 re - elected cecil r king (d) unopposed
california 22 none (district created) none (district created) 9999-01-01 new seat republican gain john j phillips (r) 57.6% n e west (d) 42.4%
Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'district' is 'california 22'.

Step 2: Select rows where 'result' is 'new seat republican gain'.

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

Step 1: Select rows where 'district' is 'california 22'.

SQL command for the step:

SELECT * FROM table_sql WHERE district = 'california 22';
district incumbent party first_elected result candidates
california 2 harry lane englebright republican 1926-01-01 re - elected harry lane englebright (r) unopposed
california 4 thomas rolph republican 1940-01-01 re - elected thomas rolph (r) 98.3% archie brown ( w / i ) 1.7%
california 7 john h tolan democratic 1934-01-01 re - elected john h tolan (d) unopposed
california 9 bertrand w gearhart republican 1934-01-01 re - elected bertrand w gearhart (r) unopposed
california 10 alfred j elliott democratic 1937-01-01 re - elected alfred j elliott (d) unopposed
california 17 cecil r king democratic 1942-08-25 re - elected cecil r king (d) unopposed
california 22 none (district created) none (district created) 9999-01-01 new seat republican gain john j phillips (r) 57.6% n e west (d) 42.4%

Step 2: Select rows where 'result' is 'new seat republican gain'.

SQL command for the step:

SELECT * FROM table_sql WHERE result = 'new seat republican gain';
district incumbent party first_elected result candidates
california 22 none (district created) none (district created) 9999-01-01 new seat republican gain john j phillips (r) 57.6% n e west (d) 42.4%

Step 3: 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;
district incumbent party first_elected result candidates
california 22 none (district created) none (district created) 9999-01-01 new seat republican gain john j phillips (r) 57.6% n e west (d) 42.4%

Verification:

The statement is TRUE