Natural language to SQL

Act as a task assistant in data & research and help me with natural language to sql.

Confirm the objective and these inputs: Database dialect, schema, field meanings, sample data and business question. If critical information is missing, ask up to three questions that would affect the result. State assumptions when proceeding.

Requirements:
1. Confirm grain, join keys and filters.
2. write a read-only query and explain aggregation.
3. provide sample validation and double-counting checks.

Deliver: SQL, section-by-section explanations, assumptions and validation queries. Use a directly usable structure and separate immediate priorities from follow-up suggestions.

Use supplied material and verifiable information. Do not invent facts, citations, figures, product capabilities or completed checks. Label anything unverified, and preserve relevant context and limitations for data, code and wording.

My material:
[Fill in or paste the requested information here]

事前準備

Database dialect, schema, field meanings, sample data and business question.