← Questions
Total population of a city across zip codes in SQL
0
I was asked this
No reports yet. Sign in to say where you were asked it.
Four tables describe geography: country, state, city and zip code, each pointing to its parent, and the population is stored per zip code. Write a query that returns the total population of a city given its name. Mind that the same city name can exist in several states or countries.
No official answer yet. Write yours on the right and run it.
Nothing published yet.
Sign in to submit your code; every attempt is kept here.
Write and test your solution herePython in your browser, the question's tests level by level, every submission kept for you.Sign in to start coding