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