Plan-of-SQLs (Ours)


Statement: when chicago was home , new jersey was the visitor

Ground-truth: TRUE

Input Table: none

Step 1: Select rows where 'home' is 'chicago'.
date visitor score home record
9999-02-03 ny islanders 7 - 2 new jersey 11 - 32 - 11
9999-02-05 new jersey 4 - 5 washington 11 - 33 - 11
9999-02-06 vancouver 4 - 4 new jersey 11 - 33 - 12
9999-02-09 new jersey 4 - 5 chicago 11 - 34 - 12
01-02-12 new jersey 1 - 5 st louis 11 - 35 - 12
01-02-15 minnesota 3 - 2 new jersey 11 - 36 - 12
9999-02-20 new jersey 0 - 3 philadelphia 11 - 37 - 12
01-02-21 buffalo 4 - 4 new jersey 11 - 37 - 13
9999-02-24 detroit 1 - 4 new jersey 12 - 37 - 13
9999-02-26 new jersey 4 - 5 pittsburgh 12 - 38 - 13
9999-02-27 new jersey 2 - 6 buffalo 12 - 39 - 13

Step 2: Select rows where 'visitor' is 'new jersey'.
date visitor score home record
9999-02-09 new jersey 4 - 5 chicago 11 - 34 - 12

Step 3: Use a `CASE` statement to return TRUE if the number of rows is greater than or equal to 1, otherwise return FALSE.
date visitor score home record
9999-02-09 new jersey 4 - 5 chicago 11 - 34 - 12

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE