# SQL testing checklist for QA

## Context and safety
- [ ] Confirm the database engine and version.
- [ ] Confirm the environment, host, database, and schema.
- [ ] Use an approved read-only account when possible.
- [ ] Record the data refresh time and test-data setup.
- [ ] Review every statement before execution.

## Query correctness
- [ ] Match every filter to the business rule.
- [ ] Check missing and duplicate rows after joins.
- [ ] Test NULL behavior explicitly.
- [ ] Check inclusive and exclusive boundaries.
- [ ] Confirm time zone, date range, and precision.
- [ ] Review grouping keys and aggregate behavior.
- [ ] Compare important results with a second method.

## Evidence
- [ ] Save the exact query and parameters.
- [ ] Record the engine, environment, and execution time.
- [ ] Capture row counts and a representative sample.
- [ ] Mask personal data, credentials, and secrets.
- [ ] State what the evidence proves and does not prove.