Loading
Join `tickets` and `answers` (on `tickets.id = answers.ticket_id`). Return `customer`, `topic` and `latency_ms` for unresolved tickets whose answer took more than 600 ms, slowest first.
tickets(id, customer, channel, topic, minutes, resolved 0/1) answers(ticket_id, model, grounded 0/1, latency_ms)
where t.resolved = 0 and a.latency_ms > 600 order by a.latency_ms desc