Ranking cities by percent of their state population in SQL

Hard

You're given the following table showing the population of various cities in the US, along with their associated states:

Table: population_table

state_namecity_nametotal_population
CaliforniaLos Angeles4000000

Sign in to InterviewQs to view this question

Or

New to InterviewQs? Sign up now.

By proceeding, you agree to our Terms and Conditions and Privacy Policy.

Loading editor...