Plan-of-SQLs Interface TP

Sample: 225/1952
← Previous Next →

Task: Verify the Statement against the Table

Statement: on sunday , september 30 , the chicago bears beat the green bay packers 31 - 20

Table: bears - packers rivalry

year date winner result loser attendance location
1950 9999-10-01 green bay packers 31 - 21 chicago bears 24893 green bay
1950 01-10-15 chicago bears 28 - 14 green bay packers 51065 chicago
1951 9999-09-30 chicago bears 31 - 20 green bay packers 24666 green bay
1951 9999-11-18 chicago bears 24 - 13 green bay packers 36771 chicago
1952 9999-09-28 chicago bears 24 - 14 green bay packers 24656 green bay
1952 9999-11-09 green bay packers 41 - 28 chicago bears 41751 chicago
1953 9999-10-04 chicago bears 17 - 13 green bay packers 24835 green bay
1953 9999-11-08 chicago bears 21 - 21 green bay packers 39889 chicago
1954 9999-10-03 chicago bears 10 - 3 green bay packers 24414 green bay
1954 9999-11-07 chicago bears 28 - 23 green bay packers 47038 chicago
1955 9999-10-02 green bay packers 24 - 3 chicago bears 24662 green bay
1955 9999-11-06 chicago bears 52 - 31 green bay packers 48890 chicago
1956 9999-10-07 chicago bears 37 - 21 green bay packers 24668 green bay
1956 9999-11-11 chicago bears 38 - 14 green bay packers 49172 chicago
1957 9999-09-29 green bay packers 21 - 17 chicago bears 32132 green bay
1957 9999-11-10 chicago bears 21 - 14 green bay packers 47153 chicago
1958 9999-09-28 chicago bears 34 - 20 green bay packers 32150 green bay
1958 9999-11-09 chicago bears 24 - 10 green bay packers 48424 chicago
1959 9999-09-27 green bay packers 9 - 6 chicago bears 32150 green bay
1959 9999-11-08 chicago bears 28 - 17 green bay packers 46205 chicago
Generating plan to answer the query...

Generated steps

Step 1: Select rows where the 'date' is '9999-09-30'.

Step 2: Select rows where the 'winner' is 'chicago bears'.

Step 3: Select rows where the 'loser' is 'green bay packers'.

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 the 'date' is '9999-09-30'.

SQL command for the step:

SELECT * FROM table_sql WHERE date = '9999-09-30';
year date winner result loser attendance location
1950 9999-10-01 green bay packers 31 - 21 chicago bears 24893 green bay
1950 01-10-15 chicago bears 28 - 14 green bay packers 51065 chicago
1951 9999-09-30 chicago bears 31 - 20 green bay packers 24666 green bay
1951 9999-11-18 chicago bears 24 - 13 green bay packers 36771 chicago
1952 9999-09-28 chicago bears 24 - 14 green bay packers 24656 green bay
1952 9999-11-09 green bay packers 41 - 28 chicago bears 41751 chicago
1953 9999-10-04 chicago bears 17 - 13 green bay packers 24835 green bay
1953 9999-11-08 chicago bears 21 - 21 green bay packers 39889 chicago
1954 9999-10-03 chicago bears 10 - 3 green bay packers 24414 green bay
1954 9999-11-07 chicago bears 28 - 23 green bay packers 47038 chicago
1955 9999-10-02 green bay packers 24 - 3 chicago bears 24662 green bay
1955 9999-11-06 chicago bears 52 - 31 green bay packers 48890 chicago
1956 9999-10-07 chicago bears 37 - 21 green bay packers 24668 green bay
1956 9999-11-11 chicago bears 38 - 14 green bay packers 49172 chicago
1957 9999-09-29 green bay packers 21 - 17 chicago bears 32132 green bay
1957 9999-11-10 chicago bears 21 - 14 green bay packers 47153 chicago
1958 9999-09-28 chicago bears 34 - 20 green bay packers 32150 green bay
1958 9999-11-09 chicago bears 24 - 10 green bay packers 48424 chicago
1959 9999-09-27 green bay packers 9 - 6 chicago bears 32150 green bay
1959 9999-11-08 chicago bears 28 - 17 green bay packers 46205 chicago

Step 2: Select rows where the 'winner' is 'chicago bears'.

SQL command for the step:

SELECT * FROM table_sql WHERE winner = 'chicago bears';
year date winner result loser attendance location
1951 9999-09-30 chicago bears 31 - 20 green bay packers 24666 green bay

Step 3: Select rows where the 'loser' is 'green bay packers'.

SQL command for the step:

SELECT * FROM table_sql WHERE loser = 'green bay packers';
year date winner result loser attendance location
1951 9999-09-30 chicago bears 31 - 20 green bay packers 24666 green bay

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;
year date winner result loser attendance location
1951 9999-09-30 chicago bears 31 - 20 green bay packers 24666 green bay

Verification:

The statement is TRUE