Plan-of-SQLs Interface TP

Sample: 1722/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: alfred j elliott was re - elected to california 's 10th district in 1937

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 'incumbent' is 'alfred j elliott'.

Step 2: Select rows where 'result' is 're-elected'.

Step 3: Select rows where 'district' is 'california 10'.

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 'incumbent' is 'alfred j elliott'.

SQL command for the step:

SELECT * FROM table_sql WHERE incumbent = 'alfred j elliott';
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 're-elected'.

SQL command for the step:

SELECT * FROM table_sql WHERE result = 're-elected';
district incumbent party first_elected result candidates
california 10 alfred j elliott democratic 1937-01-01 re - elected alfred j elliott (d) unopposed

Step 3: Select rows where 'district' is 'california 10'.

SQL command for the step:

SELECT * FROM table_sql WHERE district = 'california 10';
district incumbent party first_elected result candidates
california 10 alfred j elliott democratic 1937-01-01 re - elected alfred j elliott (d) unopposed

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;
district incumbent party first_elected result candidates
california 10 alfred j elliott democratic 1937-01-01 re - elected alfred j elliott (d) unopposed

Verification:

The statement is TRUE