Finding the population changes rate.
As I understand your requirement:
1. you want to figure out the difference between Current population count and previously latest population count of each U.S. state.
Provided by Census Bureau to figure out the growth ratio of the state between two consecutive years for two different table.
-- Tell me this is for 1 time or it's continuous process for future, this information is important to complete the work. and taking necessary steps.
--If it for continuous process tell can you tell me how we can identify the table name, I means to say, I have to select manually.
--All this sql side work is need to be inside the database or you need some script or program to run the function.
2. Need join query between two dataset and display data in negative if the earlier estimates are greater than 10000,
--Ok you need the screen shot, I need the sample of the data to work it properly without making any confusion of my understanding over.
3. Tell me about "K. Explain how you prepared the data", I just need to confirm If you want me create a sample dataset and do whole work and send you the screen shot to me let me confirm.
I have few more question to ask, ping me when you available, there are some point to discuss.
Thank you