Table Schema
Inspect
Table
| Column | Type |
|---|---|
| email_id | integer |
| sender_id | integer |
| sent_date | date |
Email
Activity
Find users who sent more than 5 emails in a single day.
Inspect
Sample Data
Input
Output
Sample Input: emails
| email_id | sender_id | sent_date |
|---|---|---|
| 1 | 101 | 2024-01-01 |
| 2 | 101 | 2024-01-01 |
| 3 | 101 | 2024-01-01 |
| 4 | 101 | 2024-01-01 |
| 5 | 101 | 2024-01-01 |
| 6 | 101 | 2024-01-01 |
| 7 | 102 | 2024-01-02 |
| 8 | 103 | 2024-01-02 |
Expected Output
| sender_id |
|---|
| 101 |
SQL Editor
Run
Query
Waiting for query
| sender_id |
|---|
| 101 |
Hints
Unlock
Clues
Hint 01: Group by sender and day.
Hint 02: Count emails in each sender-day group.
Hint 03: Return senders whose daily count is greater than 5.
Solution
Locked
Answer
Solution is locked until you decide to reveal it. Try the editor first, then open this when you want the reference answer.
SELECT DISTINCT sender_id FROM emails GROUP BY sender_id, sent_date HAVING COUNT(*) > 5;
Explanation
Step By
Step
01
Create daily sender groups.
02
Use COUNT(*) for emails sent.
03
Keep only groups above 5 emails.
Related Questions