Loading…
Identify cities where new_infections rose every day for 5 days in a row, i.e. 6 consecutive days where each day's new_infections is strictly greater than the previous day's. Return city_id, city_name, and starting_date, the first date of each such 6-day window (if a streak is longer, every date that starts a qualifying 6-day window is returned). Sort by city_id, then starting_date, both ascending.
Create a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.