Practice Interview Questions
| Question | Status |
|---|---|
You are tasked with cleaning the Columne Project Management tool dataset.
The dataset activity_log contains the following columns: activity_id, session_id, user_id, activity_type, and activity_time. Identify and remove any duplicate rows where the combination of user_id and activity_time are the same.
Table:
| 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 |
You cannot perform any DELETE OR INSERT INTO - only share the query that will perform this action.
You are tasked with cleaning the Columne Project Management tool dataset.
The dataset activity_log contains the following columns: activity_id, session_id, user_id, activity_type, and activity_time. Identify and remove any duplicate rows where the combination of user_id and activity_time are the same.
Table:
| 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 |
You cannot perform any DELETE OR INSERT INTO - only share the query that will perform this action.