A report request rarely arrives as a clean formula. The people team needs a usable answer with a named population, a report date and enough detail to investigate the result. Work through the steps in order. The SQL editor carries your previous query into the next step, so you can change the measure without losing the work you just wrote. Each step asks for a different output, and the final step delivers a result the report owner can use. Keep raw identifiers out of aggregate survey reporting. The exercises use fictional records, but the habits of checking keys, dates and denominators apply to a real reporting handoff.
The start boundary is inclusive and the end boundary is exclusive.