Inventory Reorder Screen: Filter Before the Rollup
Separate row eligibility from aggregate thresholds in a basic inventory query.
Warehouse control desk beside neat shelving aisles, supervisor with tablet and analyst at laptop, colorful inventory bins and handheld scanners, clean industrial lighting, open floor area for digital overlay, no text, words, letters, numerals, logos. A warehouse supervisor needs aisles with fewer than 40 total units among active SKUs using current shelf counts. Current count and active status are row-level filters; the fewer-than-40 rule is an aisle-level aggregate threshold. The carts are ready, but the low-stock rule must land in the right clause. What should Mateo do in the query? Filter current counts and active SKUs in WHERE, group by…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in