Welcome to the SQL screen.
The question is on your right: Monthly Fusion Team Adoption Summary. Read through the requirements and the three tables first.
Run and submit your code as often as you need. You also have five interviewer messages this session - want to talk through your approach, or are you ready to start coding?
You are given Autodesk Fusion workspace, user, and activity data. Write a PostgreSQL query that returns one row per workspace for March 2024 showing the workspace name, total active users, number of paid active users, total edit events, and an adoption label. Count a user as active only if they had at least one edit event during March 2024. Include workspaces even if they had no March activity.
Use an adoption label of High when at least 60% of active users are paid, Low when the ratio is below 60%, and No Activity when the workspace has no active users.
| Column | Type | Description |
|---|---|---|
| workspace_idPK | INT | Workspace identifier |
| workspace_name | VARCHAR(100) | Workspace name |
| industry | VARCHAR(50) | Industry segment |
| created_at | DATE | Workspace creation date |
| Column | Type | Description |
|---|---|---|
| user_idPK | INT | User identifier |
| workspace_id | INT | Workspace the user belongs to |
| user_name | VARCHAR(100) | User name |
| seat_type | VARCHAR(20) | License seat type |
| joined_at | DATE | Date the user joined the workspace |
| Column | Type | Description |
|---|---|---|
| activity_idPK | INT | Activity identifier |
| user_id | INT | User who performed the action |
| activity_date | DATE | Date of the activity |
| activity_type | VARCHAR(20) | Type of activity |
| minutes_spent | INT | Minutes spent in the session |