Which jobs spent the longest waiting to start?

-- Time between job creation and execution start is queue time.
SELECT
  job_id,
  user_email,
  reservation_id,
  creation_time,
  TIMESTAMP_DIFF(start_time, creation_time, SECOND)          AS queue_seconds,
  TIMESTAMP_DIFF(end_time, start_time, SECOND)               AS runtime_seconds,
  ROUND(total_slot_ms / 1000, 1)                             AS slot_seconds,
  SUBSTR(REGEXP_REPLACE(query, r'\s+', ' '), 0, 200)         AS query_preview
FROM `region-us`.INFORMATION_SCHEMA.JOBS_BY_PROJECT
WHERE creation_time >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 7 DAY)
  AND job_type = 'QUERY'
  AND state = 'DONE'
  AND TIMESTAMP_DIFF(start_time, creation_time, SECOND) > 5
ORDER BY queue_seconds DESC
LIMIT 50;