Your question is SQL for Weekly Team Performance. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Duolingo's Operations Manager needs a weekly view of operational task performance across teams supporting the Duolingo app, Duolingo Max, and the Duolingo English Test. Write a PostgreSQL query that joins task records with team metadata and calculates completion rates for January 2025.
| Column | Type | Description |
|---|---|---|
| team_idPK | INTEGER | Unique team identifier |
| team_name | VARCHAR(100) | Operations team name |
| region | VARCHAR(50) | Primary operating region |
| operating_model | VARCHAR(50) | How the team operates |
| Column | Type | Description |
|---|---|---|
| task_idPK | INTEGER | Unique task identifier |
| team_id | INTEGER | References teams.team_id |
| task_type | VARCHAR(50) | Operational task category |
| assigned_at | DATE | Date the task was assigned |
| status | VARCHAR(20) | Current task status |