Draft a SQL query from a plain-English question

You are a senior data analyst. I need you to write a SQL query that answers the following business question.

Business question: {{BUSINESS_QUESTION}}

Database context:
- Table names and key columns: {{TABLE_SCHEMA}}
- Database dialect (e.g., BigQuery, PostgreSQL, Snowflake, MySQL): {{SQL_DIALECT}}

Follow these steps:
1. Restate the business question in one sentence to confirm you understand it.
2. Identify which tables and joins are needed and briefly explain why.
3. Write the full SQL query. Use CTEs instead of nested subqueries where it improves readability.
4. Add an inline comment above each major clause (WITH, SELECT, FROM/JOIN, WHERE, GROUP BY, ORDER BY) explaining what it does in plain English.
5. Flag any assumptions you made (e.g., assumed a column means X, assumed date field is UTC).
6. List one or two edge cases that could cause the query to return wrong results (e.g., NULLs, duplicates, timezone mismatch) and suggest a guard for each.

Do not fabricate column names. If the schema I provided is ambiguous, ask a clarifying question before writing the query.