Step 1: Select rows where the 'frequency_mhz' is in the range of 100 to 199.
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: Select rows where the 'frequency_mhz' is in the range of 90 to 99.
call_sign |
frequency_mhz |
city_of_license |
erp_w |
class |
fcc_info |
w264bf |
100.7 |
englewood , illinois |
2 |
d |
fcc |
w276bm |
103.1 |
park forest , illinois |
19 |
d |
fcc |
w293al |
106.5 |
rochester , indiana |
80 |
d |
fcc |
Step 3: Use a `CASE` statement to return TRUE if the number of rows from step 1 is equal to 3 and the number of rows from step 2 is equal to 3, otherwise return FALSE.
call_sign |
frequency_mhz |
city_of_license |
erp_w |
class |
fcc_info |
Final output table:
verification_result |
FALSE |
Prediction: FALSE