Uber wants to measure early rider retention for users who signed up in January 2024. Write a SQL query to calculate the retention rate for that signup cohort.
Define a retained rider as a rider who signed up in January 2024 and completed at least one trip in February 2024.
signup_date falls between 2024-01-01 and 2024-01-31.| Column | Type | Description |
|---|---|---|
| rider_idPK | INT | Unique rider identifier |
| rider_name | VARCHAR(100) | Rider full name |
| signup_date | DATE | Date the rider signed up for Uber |
| city | VARCHAR(50) | Primary signup city |
| Column | Type | Description |
|---|---|---|
| trip_idPK | INT | Unique trip identifier |
| rider_id | INT | Rider who requested the trip |
| trip_date | DATE | Date of the trip |
| trip_status | VARCHAR(20) | Trip outcome such as completed or canceled |
| fare_usd | NUMERIC(8,2) | Final trip fare in USD |