Question: 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
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
Get step-by-step solutions from verified subject matter experts
