Total population of a city across zip codes in SQL
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.
NvidiaTechnical phone screenNo answer yet. Write the first one; the best answer gets endorsed.