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_name | city_name | total_population |
|---|---|---|
| California | Los Angeles | 4000000 |
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...