Table Schema
Inspect
Table
| Column | Type |
|---|---|
| file_id | integer |
| user_id | integer |
| size_mb | integer |
Storage
Usage
Find users who exceeded 15GB storage.
Inspect
Sample Data
Input
Output
Sample Input: files
| file_id | user_id | size_mb |
|---|---|---|
| 1 | 101 | 5000 |
| 2 | 101 | 6000 |
| 3 | 101 | 7000 |
| 4 | 102 | 3000 |
| 5 | 102 | 2000 |
| 6 | 103 | 16000 |
| 7 | 104 | 2000 |
Expected Output
| user_id |
|---|
| 101 |
| 103 |
SQL Editor
Run
Query
Waiting for query
| user_id |
|---|
| 101 |
| 103 |
Hints
Unlock
Clues
Hint 01: 15GB equals 15360MB if 1GB is 1024MB.
Hint 02: Sum size_mb by user.
Hint 03: Filter users above the threshold.
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 user_id FROM files GROUP BY user_id HAVING SUM(size_mb) > 15360;
Explanation
Step By
Step
01
Group files by user.
02
Sum storage in MB.
03
Keep users whose total exceeds 15360 MB.
Related Questions