SQL Aggregation Across Country/State/City/Zip Tables

Given four tables: country, state, city, and zip.

  • The zip table contains a population column.
  • You need to query the total population for a given city name by summing populations acros...

Unlock to view complete problem details

and practice with sample input/output

Was this article helpful?

View Test Cases & Run Code requires membership

Standard Input
Execution Result: