Dr. Wells,
To be completely honest, I am not sure how to join the tables together in this program to come up with the answers needed. I have become very lost and frustrated, so for that reason I have nothing to upload. I am not sure if I am overthinking things, but this has not come easy to me at all, so I would like to stay after class Thursday to figure this assignment out with you if possible before we move on to other stuff. I do not think I completely grasped the “joining” concept last Thursday, and so everything else is just foreign. I hate to fall behind, and become a pest, but I think some one-on-one work will really benefit me.
Happy to discuss after class, but it would be a lot better to meet before class. I can meet from 9 a- 10:30 a, tomorrow. Let me know
Here is how to join a table
SELECT FL_nativity.geography,
FL_nativity.Total_Nativity,
FL_nativity.Born_In_US,
FL_nativity.NOT_Citizen,
FL_poverty.Total_Poverty,
FL_poverty.Native_BelowP,
FL_poverty.Non_Citizen_BELOWP
FROM FL_nativity
INNER JOIN FL_poverty
ON FL_nativity.Id2 = FL_poverty.Id2;
Here are the homework answers:
https://wordpressua.uark.edu/datareporting/april-6-class/