Task 1: Identify Cities With The Highest Infection Rates
#1 · 1 of 7Free sampleQuestion
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.Tables4 tables · 16 columns
Tables
4 tables · 16 columnscities3 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
Loading the practice editor and dataset…
Sign up to unlock
The reference answer is one click away.
Free account unlocks the reference answer, the explanation, and the GPT tutor on every exercise in the library.
- Reference answer + explanation revealed after each attempt
- GPT tutor for every problem
- Progress saved on the platform
- 1,598 graded exercises
- Free forever — no credit card