Step 1: Select rows where 'call_sign' is 'w269ax'.
call_sign |
frequency_mhz |
city_of_license |
erp_w |
class |
fcc_info |
w230av |
93.9 fm |
gadsden , alabama |
10 |
d |
fcc |
w269ax |
101.7 fm |
anniston , alabama |
10 |
d |
fcc |
w273ae |
102.5 fm |
albany , georgia |
55 |
d |
fcc |
w282ae |
104.3 fm |
macon , georgia |
27 |
d |
fcc |
w290ag |
105.9 fm |
griffin , georgia |
27 |
d |
fcc |
Step 2: Select rows where 'call_sign' is 'w273ae'.
call_sign |
frequency_mhz |
city_of_license |
erp_w |
class |
fcc_info |
w269ax |
101.7 fm |
anniston , alabama |
10 |
d |
fcc |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1 for both call signs, otherwise return FALSE.
call_sign |
frequency_mhz |
city_of_license |
erp_w |
class |
fcc_info |
Final output table:
verification_result |
FALSE |
Prediction: FALSE