Write a query to find the top 10% of sellers by revenue over the last 30 days on Fiverr.
Use the provided sellers and orders data. Treat the last 30 days as the period from CURRENT_DATE - INTERVAL '30 days' through CURRENT_DATE, inclusive. Include sellers with no qualifying orders as zero revenue. If a boundary tie affects ordering, use seller_id as the tie-breaker.
seller_id, seller_name, and revenue.revenue descending, then seller_id ascending.| Column | Type | Description |
|---|---|---|
| seller_idPK | INT | Unique Fiverr seller identifier |
| seller_name | VARCHAR(100) | Seller display name |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| seller_id | INT | Seller who completed the order |
| order_date | DATE | Date the order was completed |
| order_amount | NUMERIC(10,2) | Revenue attributed to the seller for the order |