Plan-of-SQLs (Ours)


Statement: brian watts not the top 25 at the masters tournament one time

Ground-truth: TRUE

Input Table: brian watts

Step 1: Select rows where 'tournament' is 'masters tournament'.
tournament wins top___5 top___25 events cuts_made
masters tournament 0 0 0 2 1
us open 0 0 1 2 1
the open championship 0 1 2 7 4
pga championship 0 0 0 6 4
totals 0 1 3 17 10

Step 2: Select rows where 'top___25' is 0.
tournament wins top___5 top___25 events cuts_made
masters tournament 0 0 0 2 1

Step 3: Select rows where 'top___25' is 0 and 'tournament' is 'masters tournament'.
tournament wins top___5 top___25 events cuts_made
masters tournament 0 0 0 2 1

Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
tournament wins top___5 top___25 events cuts_made
masters tournament 0 0 0 2 1

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE