Plan-of-SQLs (Ours)


Statement: bell media 's call sign was chsu - fm on the frequency 99.9 fm

Ground-truth: TRUE

Input Table: media in kelowna

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: Select rows where 'call_sign' is 'chsu - fm'.
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

Step 3: Select rows where 'frequency' is '99.9 fm'.
frequency call_sign branding format owner
00 99.9 fm chsu - fm 99.9 sun fm contemporary hits radio bell media

Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
frequency call_sign branding format owner
00 99.9 fm chsu - fm 99.9 sun fm contemporary hits radio bell media

Final output table:
verification_result
TRUE

Prediction: TRUE

Ground-truth: TRUE