The people director at fictional Alder Works needs a report that can be checked from the extract. Build the requested query pack in order. Your previous query carries into the next step. The last step is the checked report output; keep the date, unit and denominator rules visible in your handoff.
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.
Completed candidate intervals use the application and acceptance events, not the employee start date.