Longest Support Sessions per Channel

Problem

A help desk handles sessions over two channels: `chat` and `voice`. The table `Agents` lists each agent's `agent_id` and `given_name`; the table `Sessions` lists each session's `agent_id`, the `channel` it ran on, and its `seconds_long` (the session length in seconds). For each channel, find the three longest sessions. Return the agent's `given_name`, the `channel`, and the duration as `clock` formatted HH:MM:SS. If two sessions tie on length they are both kept (ranking by length, ties sharing a rank). Order the result by `channel`, then by duration descending, then by `given_name` descending for ties.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 6 rows with the columns given_name, channel, clock.

Starter code (SQL)

SELECT *
FROM Agents;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium