SQL Puzzle :)

DaveS · 5 April 2020 23:46

here is the correct query

select date_time, glucose, 
(select Avg(glucose) 
   from glucose b
  where b.date_time between Date(a.date_time, '-90 Days') 
    and Date(a.date_time, '1 day')) as item90DayAvg 
    from glucose a

Thanks