Step 1: Select rows where 'owner' is 'bell media'.
frequency |
call_sign |
branding |
format |
owner |
1150 am |
ckfr |
am 1150 |
news / talk |
astral media |
00 88.9 fm |
cbtk - fm |
cbc radio one |
public news / talk |
canadian broadcasting corporation |
00 89.7 fm |
cbu - fm - 3 |
cbc radio 2 |
public music |
canadian broadcasting corporation |
00 90.5 fm |
cbuf - fm - 2 |
première chaîne |
public news / talk |
canadian broadcasting corporation |
00 96.3 fm |
ckko - fm |
k96.3 |
classic rock |
sun country cablevision |
00 99.9 fm |
chsu - fm |
99.9 sun fm |
contemporary hits radio |
bell media |
0 101.5 fm |
cilk - fm |
101.5 ez rock |
adult contemporary |
bell media |
0 103.1 fm |
ckqq - fm |
q103 |
hot adult contemporary |
jim pattison group |
0 103.9 fm |
cjui - fm |
103.9 the juice |
adult hits |
vista broadcast group |
0 104.7 fm |
cklz - fm |
power 104 |
active rock |
jim pattison group |
Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 3, otherwise return FALSE.
frequency |
call_sign |
branding |
format |
owner |
00 99.9 fm |
chsu - fm |
99.9 sun fm |
contemporary hits radio |
bell media |
0 101.5 fm |
cilk - fm |
101.5 ez rock |
adult contemporary |
bell media |
Final output table:
verification_result |
FALSE |
Prediction: FALSE
Ground-truth: FALSE