Custom Message Type Counts
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L3
Interview Prompt
The trust and safety team is tracking custom message types sent to users. Count how many times each user was on the receiving end of a message with a non-standard type (anything other than 'text' or 'image'). Show each recipient, message type, and count.
Summary
Not all messages are created equal.
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