Write a SQL query to identify the top 10% of creators based on engagement metrics over the last 30 days.
Use the provided creators and creator_engagements tables. Treat engagement as the sum of likes, comments, and shares. Include creators with no qualifying activity, and use the current date as the reference date.
creator_id, creator_handle, total_engagements, and creator_rank.creator_rank ascending.| Column | Type | Description |
|---|---|---|
| creator_idPK | INT | Unique creator identifier |
| creator_handle | VARCHAR(80) | TikTok creator handle |
| Column | Type | Description |
|---|---|---|
| engagement_idPK | INT | Unique engagement record identifier |
| creator_id | INT | Creator associated with the engagement record |
| engagement_date | DATE | Date of recorded engagement |
| likes | INT | Number of likes |
| comments | INT | Number of comments |
| shares | INT | Number of shares |