A midlevel SQL task usually combines a business rule with a boundary condition. A latest-order query needs a tie rule. An item total needs the right grain. A pipeline repair needs a decision about what a rerun does after a write has already succeeded. State those rules before choosing the function.
This set uses original reporting and engineering prompts on the fictional warehouse. Some tasks have several valid SQL approaches; the checker compares their results on a hidden variant rather than demanding one template. When a task specifically practices QUALIFY or another construct, the prompt names it. The scenario questions ask for the design that satisfies all the stated constraints, not a product feature recalled in isolation. Read the feedback after a miss and identify which requirement your choice overlooked.