SQL query from natural language

Schema:
{{schema}}

Question: {{question}}

Write a single Postgres query that answers the question. Use CTEs if it improves readability. Include comments explaining any non-obvious joins or filters. After the query, briefly explain what it returns and call out any assumptions you made about the schema.