Loading this exercise…

Task 1: Identify Cities With The Highest Infection Rates

#1 · 1 of 7Free sample

Instructions

Task 1: Identify Cities With The Highest Infection Rates

Retrieve the city_id, city_name, and total infections for cities where the total infections across all dates exceed 5000.

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 →

Tables

4 tables · 16 columns

cities3 cols

city_idINTEGER
city_nameTEXT
populationINTEGER

infection_stats4 cols

record_idINTEGER
city_idINTEGER
dateTEXT
new_infectionsINTEGER

leaders4 cols

leader_idINTEGER
city_idINTEGER
leader_nameTEXT
statusTEXT

lockdown_stats5 cols

record_idINTEGER
city_idINTEGER
start_dateTEXT
end_dateTEXT
compliance_rateREAL