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 |