Loading...
Top Chat Contributors
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid
Problem
The chat_messages table records senders and reply_to references. Find the top 10 most active users by total messages. A user can be either a sender or a receiver (via reply-to). Count both sent and received messages per user, sorted from most active to least, limited to 10.
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.