Plan-of-SQLs (Ours)


Statement: cody zeller went to washington high school , and his hometown is washington , in

Ground-truth: TRUE

Input Table: usa today all - usa high school basketball team

Step 1: Select rows where 'player' is 'cody zeller'.
player height school hometown college
khem birch 6 - 9 notre dame prep montreal , qc , canada pittsburgh / unlv
perry ellis 6 - 8 wichita heights high school wichita , ks kansas
myles mack 5 - 9 st anthony high school jersey city , nj rutgers
shabazz muhammad 6 - 6 bishop gorman high school las vegas , nv ucla
cody zeller 6 - 11 washington high school washington , in indiana

Step 2: Select rows where 'school' is 'washington high school'.
player height school hometown college
cody zeller 6 - 11 washington high school washington , in indiana

Step 3: Select rows where 'hometown' is 'washington, in'.
player height school hometown college
cody zeller 6 - 11 washington high school washington , in indiana

Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
player height school hometown college

Final output table:
verification_result
FALSE

Prediction: FALSE

Ground-truth: TRUE