Step 1: Select rows where 'pick' is 155.
round |
pick |
player |
position |
college |
1 |
16 |
james williams |
defensive back |
fresno state |
2 |
43 |
carwell gardner |
running back |
louisville |
3 |
70 |
glenn parker |
guard |
arizona |
4 |
101 |
eddie fuller |
running back |
lsu |
6 |
155 |
john nies |
punter |
arizona |
7 |
167 |
brent griffith |
guard |
minnesota - duluth |
7 |
171 |
brent collins |
linebacker |
carson - newman |
7 |
182 |
fred deriggi |
nose tackle |
syracuse |
8 |
209 |
marvcus patton |
middle linebacker |
ucla |
9 |
239 |
clarkston hines |
wide receiver |
duke |
10 |
266 |
mike lodish |
defensive tackle |
ucla |
11 |
293 |
al edwards |
wide receiver |
northwestern state , la |
Step 2: Select rows where 'college' is 'arizona'.
round |
pick |
player |
position |
college |
6 |
155 |
john nies |
punter |
arizona |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
round |
pick |
player |
position |
college |
6 |
155 |
john nies |
punter |
arizona |
Prediction: TRUE
Ground-truth: TRUE