with tls as(
   select
      spanid,
      traceid,
      Max(intV) as query_width
   from
      zipkin.zipkin_flat_annotation
   where
      ds = '2020-01-23' and
      endpoint.servicenamejob = 'gizmoduck' and
      label='query_width'
    group by spanid, traceid
)
select
    tfeuri,
    avg(query_width) as avg_query_width
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 avg_query_width desc
limit 4;