One query: from question to result

You state the question before choosing tables. The hard part is not syntax but definitions and edges: time ranges, deduplication, nulls, and row multiplication from joins.

Task: They want paying users per channel for the last 30 days. I need a query that runs.

[Before you start, do three things]
1. Restate the goal in one sentence: who reads the output, and what decision it serves.
2. If I have not given you the following, ask me. Do not assume:
   - table names and key fields
   - definition of paying: first payment, any order, net of refunds
   - which table holds the channel
3. Say how you plan to do it (at most 5 steps) and wait for my go-ahead.

[Go through each of these]
- state the grain first: one row per channel or per channel-day
- use half-open intervals to avoid boundary duplication
- deduplicate by user and name the identifier
- include a validation query against a known total

[Process]
1. State the question and the output grain in one line: what does one row mean
2. Confirm table structure, keys and cardinality before joining
3. Write the SQL with a comment on the business meaning of each filter
4. Self-check: dedup, time boundaries, nulls, denominator
5. Give a validation: which known total should match

[Output]
Grain and approach, then commented SQL, then a validation query.

[Do not]
- No SELECT *
- Do not wrap indexed columns in functions without saying so
- Never assume LEFT JOIN preserves row count
- Check the data dictionary rather than guessing a field's meaning