Search results

I am trying to learn subquery can can't wrap my head around this one and hoping someone can show me. Say a table has these fields: 1. Week 2. Item 3. Store Number 4. Sales How should I write a subquery to count the number of stores the have 0 sales for each particular item?

It sound simple enough but I couldn't figure it out. How do you sum numbers for a 4 week period every week? EX: Week Qty ----- ---- 1 10 2 20 3 30 4 40 5 50 6 60 Result: Week Qty ----- ---- 4 100 5 140 6 180 Any help would be appreciated