The buyer and finance operations lead need a follow-up query pack. The requests use the same fictional account with different cohorts and measures from the projects. Read the requested output grain before choosing tables. A supplier comparison starts with products; an order-value report starts with order headers; a unit measure uses order lines.
Keep missing supplier matches visible when the task asks about coverage. Use a half-open date window for timestamp columns, and count distinct customer keys when the measure describes people. The last task saves a report definition as a view, so another worksheet can reuse the same filtering rule. Each exercise starts independently and checks the query against changed fixture values.