Loading...
Threads Excluding User
A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- junior, mid
Problem
The trust and safety team needs to audit messaging activity that doesn't involve user 1. A thread is defined as a unique sender_id and reply_to pair. Count how many threads exist where neither the sender_id nor the reply_to is user 1, considering only messages that have a non-null reply_to.
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.