Where the Talking Stops
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
The community team is auditing channel health, from the busiest rooms down to the ghost towns. For each channel with at least five messages, report the total message count, how many different people posted, and what percentage of messages were later edited, busiest first.
Summary
Which channels are ghost towns?
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