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