Meta's integrity team promises to act on reported posts quickly. They want to check the speed for each removal reason.
For posts that were reported and later removed, show per removal reason: the number of removed posts, the average days from the first report to removal, and the percentage removed on the same day as the first report.
Expected output
Example of the shape (made-up values):
| reason | removed_posts | avg_days_to_remove | same_day_pct |
|---|---|---|---|
| spam | 30 | 0.9 | 66.7 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.