Write a SQL query to calculate the retention rate of hosts over a specific period on Turo.
Use January 2024 as the cohort period and February 2024 as the retention period. Count a host in the cohort if they completed at least one trip in January, and count them as retained if they completed at least one trip in February.
cohort_period, cohort_hosts, retained_hosts, and retention_rate_pct.| Column | Type | Description |
|---|---|---|
| host_idPK | INT | Unique identifier for the host |
| host_name | VARCHAR(100) | Host display name |
| market | VARCHAR(50) | Primary Turo market for the host |
| created_at | DATE | Date the host joined Turo |
| Column | Type | Description |
|---|---|---|
| trip_idPK | INT | Unique identifier for the trip |
| host_id | INT | Host associated with the trip |
| trip_start | DATE | Trip start date |
| status | VARCHAR(20) | Trip status |