Task 3: Determine the Vaccine Distribution Dates for Cities
#3 · 3 of 8Free sampleQuestion
Task 3: Determine the Vaccine Distribution Dates for Cities
Using the
vaccine_distribution and cities tables, list each city and the corresponding date the vaccine was distributed. Join the tables on city_id and return the following columns: city_id, city_name, and vaccine_distribution_date (renamed as distribution_date).
Tables4 tables · 17 columns
Tables
4 tables · 17 columnscities3 cols
- city_idINTEGER PRIMARY KEY
- city_nameTEXT NOT NULL
- populationINTEGER NOT NULL
infection_stats5 cols
- record_idINTEGER PRIMARY KEY
- city_idINTEGER NOT NULL
- dateTEXT NOT NULL
- new_infectionsINTEGER NOT NULL
- FOREIGNKEY(city_id) REFERENCES cities(city_id)
vaccine_distribution3 cols
- city_idINTEGER PRIMARY KEY
- vaccine_distribution_dateTEXT NOT NULL
- FOREIGNKEY(city_id) REFERENCES cities(city_id)
survivor_camps6 cols
- camp_idINTEGER PRIMARY KEY
- city_idINTEGER NOT NULL
- camp_nameTEXT NOT NULL
- capacityINTEGER NOT NULL
- current_populationINTEGER NOT NULL
- FOREIGNKEY(city_id) REFERENCES cities(city_id)
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