Practice Interview Questions
| Question | Status |
|---|---|
Find users who are active but have never submitted a support ticket.
| 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 |
| 4 | 1 | 1 | assigned_task | 2025-03-08 09:12:00 |
| 5 | 1 | 1 | viewed_dashboard | 2025-03-08 08:34:00 |
| ticket_id | user_id | support_agent_id | issue_type | priority | created_at | resolved_at | status |
|---|---|---|---|---|---|---|---|
| 1 | 6 | 101 | Login Issue | Low | 2025-03-18 15:14:00 | null | Open |
| 2 | 5 | 102 | Login Issue | High | 2025-03-06 14:14:00 | 2025-03-09 14:27:00 | Resolved |
| 3 | 6 | 103 | Other | Medium | 2025-03-15 22:37:00 | null | Open |
| 4 | 3 | 101 | UI Feedback | Medium | 2025-03-18 12:13:00 | 2025-03-19 00:37:00 | Resolved |
| 5 | 3 | 102 | Other | Medium | 2025-04-21 09:46:00 | 2025-04-23 10:52:00 | Resolved |
The query should find users who have session logs but no corresponding support tickets submitted in the system.
Find users who are active but have never submitted a support ticket.
| 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 |
| 4 | 1 | 1 | assigned_task | 2025-03-08 09:12:00 |
| 5 | 1 | 1 | viewed_dashboard | 2025-03-08 08:34:00 |
| ticket_id | user_id | support_agent_id | issue_type | priority | created_at | resolved_at | status |
|---|---|---|---|---|---|---|---|
| 1 | 6 | 101 | Login Issue | Low | 2025-03-18 15:14:00 | null | Open |
| 2 | 5 | 102 | Login Issue |
The query should find users who have session logs but no corresponding support tickets submitted in the system.
| High |
| 2025-03-06 14:14:00 |
| 2025-03-09 14:27:00 |
| Resolved |
| 3 | 6 | 103 | Other | Medium | 2025-03-15 22:37:00 | null | Open |
| 4 | 3 | 101 | UI Feedback | Medium | 2025-03-18 12:13:00 | 2025-03-19 00:37:00 | Resolved |
| 5 | 3 | 102 | Other | Medium | 2025-04-21 09:46:00 | 2025-04-23 10:52:00 | Resolved |