lululemon Interview Question

Rolling average in sql query