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