SQL from a plain-English question

Here is my schema:

{{schema}}

Write {{dialect}} that answers: {{question}}

After the query, list every assumption you made about the data — what counts as
active, how you handled nulls, which timestamp you trusted — one line each. If
the question is ambiguous, write the query for the most likely reading and say
what the other reading would change.

What to fill in

{{schema}}

Schema — e.g. Paste your CREATE TABLE statements

{{question}}

Question — e.g. which plans churn in month two?

{{dialect}}

Dialect — e.g. MySQL 8