with tls as
  (select
     spanid,
     traceid
   from
     zipkin.zipkin_flat_annotation
   where
     ds = '2020-01-23'
     and endpoint.servicenamejob = 'gizmoduck')
select
  tfeuri,
  count(DISTINCT(spanid)) as num_rpc,
  count(DISTINCT(t1.traceid)) as num_traces
from
  zipkin.zipkin_trace_index t1
    join tls t2 on t1.traceid = t2.traceid
where
    t1.ds = '2020-01-23'
    and tfehost = 'api.twitter.com'
    and isprodonly = true
group by
  tfeuri
order by
  num_traces desc
limit 4