Practice Interview Questions
| Question | Status |
|---|---|
What is the overall trend of user activity (activities per day) in the past two months?
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 |
What is the overall trend of user activity (activities per day) in the past two months?
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 |
Hint: Plot the trend of activities per day over the last 60 days. Identify any significant increases or decreases in activity over time.
| 2025-03-08 08:19:00 |
| 3 | 1 | 1 | updated_task | 2025-03-08 08:18:00 |
Hint: Plot the trend of activities per day over the last 60 days. Identify any significant increases or decreases in activity over time.