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
- L5
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.
Summary
User networks mapped through messages.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision