Write a SQL query to calculate the conversion rate between two stages of the funnel.
Assume the stages are signup and assessment_started. Include only non-test users, count each user once, and consider a conversion valid only when the second stage occurs after the first.
from_stage, to_stage, from_users, converted_users, and conversion_rate_pct| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| is_test | BOOLEAN | Whether the account is a test user |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique funnel event identifier |
| user_id | INT | User associated with the event |
| stage | VARCHAR(50) | Funnel stage recorded by the event |
| event_time | TIMESTAMP | Time when the funnel event occurred |