Write a query to identify creators who have experienced a significant drop in monthly recurring revenue (MRR) over the last three months on Patreon.
Use the latest three calendar months represented in the MRR data. Treat a significant drop as the latest month's MRR being at least 30% lower than the earliest month's MRR, and require data for all three months.
creator_id, creator_name, starting_mrr, ending_mrr, and drop_percent.drop_percent descending, then creator_id ascending.| Column | Type | Description |
|---|---|---|
| creator_idPK | INT | Unique Patreon creator identifier |
| creator_name | VARCHAR(100) | Creator display name |
| Column | Type | Description |
|---|---|---|
| creator_id | INT | Creator associated with the monthly MRR record |
| mrr_month | DATE | Month represented by the MRR snapshot |
| mrr_amount | NUMERIC(12,2) | Monthly recurring revenue for the creator |