Your goal: say how you would build an answer in SQL or a sheet (the output first, the join,
the checks) and catch a wrong query before it ships.
How this works (about 30 minutes)
- Victor is a BizOps interviewer. He describes two tables, made up for the exercise, and reads
sample rows when you ask. It is voice only: talk the query through.
- Ask about the tables, what one row stands for, and the definitions you need.
- A shared notepad is there if you want to write the steps. Ask Victor to open it.
- A trap, a curveball, then a shorter Sheets question.
- No hints and no scores during the call. Your report comes after.
What scores well
- Saying the output (one row per what) before any clause
- Aggregating each side to the grain of the answer before joining
- Catching a fan-out with the arithmetic
- Checks: a row count, a total, one hand-computed row
- Saying what you would send and how it runs again next week
Tips
- Take BizOps Coach · Working the Data first.
- Syntax slips do not matter; the plan does.