Your question is Daily IP Takedown Resolution Rate. 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.
Roblox Trust & Safety monitors IP takedown requests submitted through Roblox surfaces. Write a PostgreSQL query that calculates the daily resolution rate for IP takedown requests received during the first five days of March 2025.
A request is resolved when its matching outcome has resolution_status = 'resolved'. Calculate the rate by the request's received date, not the outcome date.
request_type = 'ip_takedown' and received_at is from March 1 through March 5, 2025.| Column | Type | Description |
|---|---|---|
| request_idPK | INT | Unique IP takedown request identifier |
| request_type | VARCHAR(30) | Category of Trust & Safety request |
| received_at | TIMESTAMP | Timestamp when the request was received |
| submission_channel | VARCHAR(30) | Roblox surface used to submit the request |
| Column | Type | Description |
|---|---|---|
| outcome_idPK | INT | Unique outcome identifier |
| request_id | INT | Request identifier associated with the outcome; late-arriving records may temporarily lack a matching request |
| resolution_status | VARCHAR(20) | Current resolution status |
| resolved_at | TIMESTAMP | Timestamp when the outcome was resolved |