Loading interview...

Shared Channel Contacts

A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
SQL
Difficulty
hard
Seniority
senior

Interview Prompt

Using our chat message data, build a contact overlap picture. For each sender, count how many other unique senders share at least one channel with them. Show each sender and their shared contact count, sorted from most contacts to least.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision