Plan-of-SQLs (Ours)


Statement: the hometown of the last player of the list is las vegas , nv

Ground-truth: FALSE

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

Step 1: Select the last row of the table.
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: Extract the 'hometown' value from the selected row.
player height school hometown college
cody zeller 6 - 11 washington high school washington , in indiana

Step 3: Select rows where 'hometown' is 'las vegas , nv'.
hometown
washington , in

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

Final output table:
verification_result
FALSE

Prediction: FALSE

Ground-truth: FALSE