Loading...
Custom Message Type Counts
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- junior, mid
Problem
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.
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.