Write a SQL query to compare revenue per user across different acquisition cohorts.
Use the users and revenue_transactions tables. Include users with no transactions when calculating the cohort average, and exclude users without an acquisition date.
cohort_month, total_users, total_revenue, and revenue_per_user.cohort_month ascending.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| acquisition_date | DATE | Date the user was acquired |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| user_id | INT | User associated with the transaction |
| revenue | DECIMAL(12,2) | Revenue attributed to the transaction |