Write a SQL query to compare conversion rates between two cohorts.
Use the users and events tables. A user is converted if they have at least one event where event_type is conversion.
cohort, cohort_size, converted_users, and conversion_rate_pctcohort ascending| Column | Type | Description |
|---|---|---|
| user_idPK | INTEGER | Unique user identifier |
| cohort | VARCHAR(20) | User cohort label |
| Column | Type | Description |
|---|---|---|
| event_idPK | INTEGER | Unique event identifier |
| user_id | INTEGER | User associated with the event |
| event_type | VARCHAR(30) | Type of user event |
| event_date | DATE | Date the event occurred |