Step 1: Select rows where 'name' is 'calvin o'neal'.
| round |
pick |
overall |
name |
position |
college |
| 1 |
26 |
26 |
randy burke |
wide receiver |
kentucky |
| 2 |
25 |
53 |
mike ozdowski |
defensive end |
virginia |
| 6 |
24 |
163 |
calvin o'neal |
linebacker |
michigan |
| 7 |
26 |
193 |
blanchard carter |
offensive tackle |
unlv |
| 8 |
25 |
220 |
ken helms |
offensive tackle |
georgia |
| 9 |
24 |
247 |
glenn capriola |
running back |
boston college |
| 10 |
26 |
277 |
ron baker |
guard |
oklahoma state |
| 11 |
25 |
304 |
brian ruff |
linebacker |
the citadel |
| 12 |
24 |
331 |
bill deutsch |
running back |
north dakota |
Step 2: Select rows where 'round' is greater than 6.
| round |
pick |
overall |
name |
position |
college |
| 6 |
24 |
163 |
calvin o'neal |
linebacker |
michigan |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 0, otherwise return FALSE.
| round |
pick |
overall |
name |
position |
college |
Prediction: TRUE