Loading this exercise…

Task 2: Spot Cities With Rising Infection Trends

#2 · 2 of 7Free sample

Instructions

Task 2: Spot Cities With Rising Infection Trends

Identify cities where the number of infections increased consecutively for at least 3 days. Include city_id, city_name, and the starting date of the trend.

Loading the practice editor and dataset…

Sign up to unlock

The reference answer is one attempt away.

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.

Save attempts and completed exercises
Reveal this free exercise's answer after an attempt
Return to your progress from any device
Free forever — no credit card

Create free account →Already a member? Log in →

j

Task 3: Leaders In Danger

All exercises in Zombie Virus – Part 2: Aftermath Of The Virus Release

leaders4 cols

leader_idINTEGER
city_idINTEGER
leader_nameTEXT
statusTEXT

lockdown_stats5 cols

record_idINTEGER
city_idINTEGER
start_dateTEXT
end_dateTEXT
compliance_rateREAL