Practice Interview Questions
| Question | Status |
|---|---|
Which day had the highest number of activities across all users?
Hint: Activity is logged in the activity_log table. The goal is to identify the day with the highest overall activity count
activity_log:
| activity_id | session_id | user_id | activity_type | activity_time |
|---|---|---|---|---|
| 1 | 1 | 1 | commented | 2025-03-08 09:23:00 |
| 2 | 1 | 1 |
Which day had the highest number of activities across all users?
Hint: Activity is logged in the activity_log table. The goal is to identify the day with the highest overall activity count
activity_log:
| activity_id | session_id | user_id | activity_type | activity_time |
|---|---|---|---|---|
| 1 | 1 | 1 | commented | 2025-03-08 09:23:00 |
| 2 | 1 | 1 |
| deleted_task |
| 2025-03-08 08:19:00 |
| 3 | 1 | 1 | updated_task | 2025-03-08 08:18:00 |
| deleted_task |
| 2025-03-08 08:19:00 |
| 3 | 1 | 1 | updated_task | 2025-03-08 08:18:00 |