Write a SQL query to calculate average revenue per user from a dataset for Wix.
The user_revenue table contains one row per user and their total revenue. Treat a NULL revenue value as zero when calculating the average.
average_revenue_per_user.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique Wix user identifier |
| revenue | NUMERIC(12,2) | Total revenue attributed to the user |