Loading...
Mutual Channel Connections
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid
Problem
Our messaging platform tracks which senders post in which channels. Find all sender IDs that appear in at least one channel where user 197 posted and also in at least one channel where user 585 posted, excluding those two users themselves.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.