sql-reporting

Source excerpt starting at line 1.

1---2name: sql-reporting3description: Conventions and review steps for writing analytics SQL against the warehouse. Use whenever the task involves querying tables, building a report, or aggregating metrics.4license: Apache-2.05---6<!-- SPDX-License-Identifier: Apache-2.07     https://www.apache.org/licenses/LICENSE-2.0 -->8 9# SQL Reporting Skill10 11Apply this skill before writing or running any analytics SQL so reports stay12consistent and safe.13 14## When to Use This Skill15 16Use this skill when the task involves:17 18- Querying warehouse tables for a metric, report, or dashboard figure19- Aggregating rows (counts, sums, rolling windows)20- Cross-referencing two or more tables21 22## Conventions23 241. Always `SELECT` explicit column names, never `SELECT *`.252. Filter on a partition/date column first to bound the scan.263. Alias aggregates with snake_case names (`order_count`, not `count(*)`).274. Cap exploratory queries with `LIMIT` unless an aggregate already collapses28   the result set.295. Prefer `COUNT(DISTINCT ...)` over a sub-query when de-duplicating.30 31## Review Checklist (run before returning an answer)32 33- [ ] No `SELECT *`.34- [ ] A date or partition predicate is present.35- [ ] Every aggregate has an explicit alias.36- [ ] The query reads only from tables the task actually needs.37 38## Output Format39 40Return the final SQL in a fenced ```sql block, then one sentence describing41what the query returns.42