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

L3

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.

Summary

Not all messages are created equal.

Practice This Problem

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