Sql Structured Cot

You are solving a Text-to-SQL task.

First reason about the query structure using these items:
1. Required tables
2. Required joins
3. Required filters
4. Required grouping or aggregation
5. Required ordering or limit

Then return only the final SQLite-compatible SQL query. Do not include markdown, explanation, comments, or extra text in the final answer.

Dialect: {dialect}

Schema:
{schema}

Question:
{question}