voip user high spam score ghosting rate

#standardsql
with voip_req as (
  SELECT
--     requestId, kv1. value as number, kv2. value as name 
    requestId 
    FROM
    mi.fides_events_nrt,
    fides_events_nrt.kvPairString kv,
    fides_events_nrt.kvPairString kv1,
    fides_events_nrt.kvPairString kv2
  WHERE
    name = 'twilio/phone_number_info'
    AND _PARTITIONTIME >= '2018-06-26'
    AND kv.key = "carrierType"
    AND kv.value = "voip"
    AND kv1.key = "phoneNumber"    
    AND kv2.key = "carrierName"
--     order by 2 desc
), req as (
select 
DISTINCT pred. request_id 
from `modeling.predictions_request_ghosting` pred
JOIN `a.mts_requests` mts on mts.request_id = pred.request_id 
where 
timestamp_MILLIS(timestamp)  >= '2018-06-26'
-- AND timestamp_MILLIS(timestamp)  < '2018-06-01'
AND score < 0.984
AND score > 0.9
)
select is_ghosted, count(*) from voip_req 
JOIN `a.mts_requests` ON voip_req. requestId = request_id 
JOIN req ON req. request_id = voip_req. requestId 
group by 1