Step 1: Select rows where 'class' is not 'd'.
call_sign |
frequency_mhz |
city_of_license |
erp_w |
class |
fcc_info |
w221by |
92.1 |
elgin , illinois |
38 |
d |
fcc |
w264bf |
100.7 |
englewood , illinois |
2 |
d |
fcc |
w240bj |
95.9 |
crown point , indiana |
10 |
d |
fcc |
w276bm |
103.1 |
park forest , illinois |
19 |
d |
fcc |
w293al |
106.5 |
rochester , indiana |
80 |
d |
fcc |
w223au |
92.5 |
south bend , indiana |
10 |
d |
fcc |
Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 0, otherwise return FALSE.
call_sign |
frequency_mhz |
city_of_license |
erp_w |
class |
fcc_info |
Prediction: TRUE