case study 1 Task is to write sql query for 7 day rolling average and i tried this please check