MySQL Forums
Forum List  »  Newbie

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

Written By
May 17, 2018 10:08AM
May 17, 2018 10:17AM

Sorry, you can't reply to this topic. It has been closed.

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.