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

L4

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.

Summary

The ten most active chat users.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.