MySQL Forums
Forum List  »  Newbie

assistance?
Posted by: David Brown
Date: May 17, 2018 10:08AM

I have 2 tables of data (called 2016data and 2017data). In the tables are like columns of state, yr2010-yr2016. The rows are the states under state column, and population for each state under each year column. In a new table I need to somehow join the two tables so that each table corresponds (2016data.yr2010 with 2017data.yr2010). I then need to find the difference in population numbers(the 2016 population numbers for 2010 are different from the population numbers for 2010 in the 2017 data) for each of these years, and then extract all data points where the delta is 10,00 or more and it needs to be rounded to the nearest 1,000. Any help would be greatly appreciated.

Options: ReplyQuote


Subject
Written By
Posted
assistance?
May 17, 2018 10:08AM
May 17, 2018 10:17AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.