The query should take two dates, the start and end date and return the number of days updates were missed and days updates were sent