Agents With a Dominant Contact Channel

Problem

A customer-support platform logs every conversation an agent handles in the table `support_logs`, one row per conversation, recording the `agent_id`, the `ticket_ref`, and the `channel` it came through (such as 'email', 'phone', 'chat', or 'social'). Management wants the *channel specialists*: agents who handled at least 5 conversations and where at least 60% of those conversations came through a single channel. For each such agent return the `agent_id`, that leading channel as `top_channel`, and the share of their conversations on it as `channel_share` rounded to 2 decimals. Order the result by `channel_share` from highest to lowest, then by `agent_id` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns agent_id, top_channel, channel_share.

Starter code (SQL)

SELECT *
FROM support_logs;

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