Ranking cities by percent of their state population in SQL

InterviewQs

Ranking cities by percent of their state population in SQL

SQL Database Querying Window Function

Forward this email to a friend or colleague and challenge them to solve it.

Hi, 

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
California San Francisco 1000000
California Sacramento 500000
New York New York City 8300000
New York Buffalo 250000
New York Rochester 200000
Texas Austin 1000000
Texas Dallas 1300000
Texas Houston 2300000

Using this table, write a SQL query to return the following:

state_name city_name total_population percent_of_state_population
... ... the total population of the given city... the percent of the total state population the given city represents...

You can view/query the table in an interactive SQL fiddle here.


 

You’ve accumulated 381 questions since joining our email list. Create a premium account to access detailed solutions to each problem (including this one) + our new Case studies.


Was this email forwarded to you? You can join our list here to receive questions

How did you like today's question?

15411 Boischatel, Montreal, QC, H9H1Y7, Canada
Don't want to get these emails anymore? We'll forgive you if you unsubscribe

Key phrases

Older messages

Visually checking for bias in housing price prediction

Monday, December 5, 2022

Python, External Dataset, Data Visualization, InterviewQs Visually checking for bias in housing price prediction Python External Dataset Data Visualization Forward this email to a friend or colleague

Rotating a matrix

Friday, December 2, 2022

Python, Data Structures, Algorithms, Matrix Multiplication, InterviewQs Rotating a matrix Python Data Structures Algorithms Matrix Multiplication Forward this email to a friend or colleague and

Experiment with a coin

Wednesday, November 30, 2022

Statistics, Probability Theory, Central Limit Theorem, InterviewQs Experiment with a coin Statistics Probability Theory Central Limit Theorem Forward this email to a friend or colleague and challenge

Pairing animals together based on weight difference in SQL

Monday, November 28, 2022

SQL, Database Querying, CROSS JOIN, InterviewQs Pairing animals together based on weight difference in SQL SQL Database Querying CROSS JOIN Forward this email to a friend or colleague and challenge

Calculating utilization rates of storage units

Friday, November 25, 2022

Python, Data Structures, External Dataset, InterviewQs Calculating utilization rates of storage units Python Data Structures External Dataset Forward this email to a friend or colleague and challenge

You Might Also Like

BetterDev #258 - Build an 8-bit computer from scratch and Home automation with ESP8266

Wednesday, May 1, 2024

Better Dev #258 Apr 30, 2024 Hi all, We come back with a new issue this week. If you like BetterDev, please help spead word out by refer to your friends. Buy me a coffee would be great too. Build an 8-

Interface Interference 👎

Wednesday, May 1, 2024

Amid the AI device dunking, should everything “just be an app”? Here's a version for your browser. Hunting for the end of the long tail • April 30, 2024 Interface Interference The problem

Some Tesla Supercharger jobs get a jolt

Tuesday, April 30, 2024

Plus: Amazon CodeWhisperer changes its name and Arc gets a Windows version View this email online in your browser By Christine Hall Tuesday, April 30, 2024 Welcome to TechCrunch PM, bringing you the

Relief From Tinnitus: Free Discovery Call!

Tuesday, April 30, 2024

Do you suffer from tinnitus or a ringing in your ears? 1 in 3 adults over the age of 65 will suffer from this condition and often don't know there are things you can do to help. Our friends at

WebAIM April 2024 Newsletter

Tuesday, April 30, 2024

WebAIM April 2024 Newsletter Read this newsletter online at https://webaim.org/newsletter/2024/april Feature Web Accessibility in the 2024 Presidential Campaigns WebAIM's John Northup ran the US

👀 Being More Productive on a Smaller Screen — How to Hide Games on Steam Family Sharing

Tuesday, April 30, 2024

Also: What to Expect From Apple's "Let Loose" Event, and More! How-To Geek Logo April 30, 2024 Did You Know The letter J is the only letter that makes no appearance on the Periodic Table.

PEP 686, Lazy Evaluation, Serverless Python, and More

Tuesday, April 30, 2024

PEP 686: Make UTF-8 Mode Default #627 – APRIL 30, 2024 VIEW IN BROWSER The PyCoder's Weekly Logo PEP 686: Make UTF-8 Mode Default This Python Enhancement Proposal outlines making UTF-8 the default

Daily Coding Problem: Problem #1427 [Easy]

Tuesday, April 30, 2024

Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Amazon. Given an array and a number k that's smaller than the length of the array,

🎙 My advice for film + TV creatives on the AI wave

Tuesday, April 30, 2024

Learning AI fast + Karate Kid references ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌

Ranked | The Top 20 Countries in Debt to China 💸

Tuesday, April 30, 2024

The 20 nations featured in this graphic each owe billions in debt to China, often posing concerns for their economic future. View Online | Subscribe Presented by Voronoi: The App Where Data Tells the