Task 2: The Hunger Countdown
#2 · 2 of 13Free sampleQuestion
Task 2: The Hunger Countdown
Using the
supplies table, identify the food supplies (where supply_type is 'food') that have less than 7 days remaining (i.e. days_remaining < 7). Return the following columns: district_id, supply_id, supply_type, and days_remaining.
Tables10 tables · 42 columns
Tables
10 tables · 42 columnsresidents3 cols
- district_idINTEGER
- district_nameTEXT
- populationINTEGER
supplies4 cols
- supply_idINTEGER
- district_idINTEGER
- supply_typeTEXT
- days_remainingINTEGER
power_plants4 cols
- plant_idINTEGER
- plant_nameTEXT
- statusTEXT
- district_idINTEGER
medical_supplies5 cols
- supply_idINTEGER
- supply_nameTEXT
- quantityINTEGER
- unitTEXT
- last_updatedTEXT
district_usage5 cols
- district_idINTEGER
- supply_idINTEGER
- quantity_usedINTEGER
- usage_dateTEXT
- usage_timeTEXT
threat_reports5 cols
- report_idINTEGER
- district_idINTEGER
- threat_typeTEXT
- severityTEXT
- timestampTEXT
security_logs6 cols
- log_idINTEGER
- district_idINTEGER
- timestampTEXT
- staff_nameTEXT
- incidentTEXT
- severityTEXT
shelters4 cols
- shelter_idINTEGER
- district_idINTEGER
- capacityINTEGER
- current_occupancyINTEGER
transport4 cols
- vehicle_idINTEGER
- vehicle_typeTEXT
- capacityINTEGER
- effective_capacityINTEGER
exhibits2 cols
- exhibit_idINTEGER
- exhibit_nameTEXT
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