Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6. MySQL Consider a table with the following columns (US population per state): Column Name Description POP_ESTIMATE_2010 7/1/2010 resident total population estimate POPESTIMATE_2011 7/1/2011 resident

image text in transcribed
6. MySQL Consider a table with the following columns (US population per state): Column Name Description POP_ESTIMATE_2010 7/1/2010 resident total population estimate POPESTIMATE_2011 7/1/2011 resident total population estimate POP_ESTIMATE_2012 7/1/2012 resident total population estimate POP_ESTIMATE_2013 7/1/2013 resident total population estimate POP_ESTIMATE_2014 7/1/2014 resident total population estimate POP_ESTIMATE_2015 7/1/2015 resident total population estimate POP_ESTIMATE_2016 7/1/2016 resident total population estimate POP ESTIMATE 2017 7/1/2017 resident total population estimate Births_2011 Births in period 7/1/2010 to 6/30/2011 Births_2012 Births in period 7/1/2011 to 6/30/2012 Births_2013 Births in period 7/1/2012 to 6/30/2013 Births_2014 Births in period 7/1/2013 to 6/30/2014 Births_2015 Births in period 7/1/2014 to 6/30/2015 Births_2016 Births in period 7/1/2015 to 6/30/2016 Births_2017 Births in period 7/1/2016 to 6/30/2017 Deaths_2011 Deaths in period 7/1/2010 to 6/30/2011 Deaths_2012 Deaths in period 7/1/2011 to 6/30/2012 Deaths_2013 Deaths in period 7/1/2012 to 6/30/2013 Deaths_2014 Deaths in period 7/1/2013 to 6/30/2014 Deaths_2015 Deaths in period 7/1/2014 to 6/30/2015 Deaths_2016 Deaths in period 7/1/2015 to 6/30/2016 Deaths_2017 Deaths in period 7/1/2016 to 6/30/2017 6.1. Write a SQL query to estimate the number of migration of the US. (@2%) 6.2. Write a SQL query to estimate the birth rate and death rate (per 1000 people). (@3%) 6.3. Write a SQL query to show all the states with population ageing problem. (@3%)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Evaluate the importance of diversity in the workforce.

Answered: 1 week ago

Question

Identify the legal standards of the recruitment process.

Answered: 1 week ago