Table Schema
Inspect
Table
| Column | Type |
|---|---|
| session_id | integer |
| user_id | integer |
| duration_minutes | integer |
Browser
Session
Time
Find total browsing time per user.
Inspect
Sample Data
Input
Output
Sample Input: browser_sessions
| session_id | user_id | duration_minutes |
|---|---|---|
| 1 | 101 | 60 |
| 2 | 101 | 90 |
| 3 | 102 | 45 |
| 4 | 103 | 80 |
| 5 | 101 | 30 |
Expected Output
| user_id | total_time |
|---|---|
| 101 | 180 |
| 102 | 45 |
| 103 | 80 |
SQL Editor
Run
Query
Waiting for query
| user_id | total_time |
|---|---|
| 101 | 180 |
| 102 | 45 |
| 103 | 80 |
Hints
Unlock
Clues
Hint 01: Total time is a SUM.
Hint 02: Aggregate by user_id.
Hint 03: Alias the result as total_time.
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, SUM(duration_minutes) AS total_time FROM browser_sessions GROUP BY user_id;
Explanation
Step By
Step
01
Group sessions by user.
02
Add all duration_minutes.
03
Return one row per user.
Related Questions