Problem
Given a table of daily store transactions, write a SQL query to calculate a 7-day rolling average of sales by store.
Practicing as: Operations Manager interview at CVS HealthHi, I'll play your CVS Health interviewer for the Operations Manager role. Candidates describe these interviews as mostly positive and moderately difficult, so expect me to be friendly and conversational. Take your time with the question above and answer like we're in the room.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.
