Inner Join Id2 field:
Question 3:
Most number of people in poverty – Miami-Dade County
Least number of people in poverty – Liberty County
Top three counties with the highest non-citizen poverty – Nassau County, Holmes County, Walton County
Bonus question:
ALTER TABLE FL_poverty
ADD COLUMN “Native_poverty_rate” NUMERIC ;
UPDATE FL_poverty
SET “Native_poverty_rate” = (Income_below_poverty / Id) ;
Native poverty rate top county – Miami-Dade County (1.06)
Native poverty rate bottom county – Liberty County (.0024)
ALTER TABLE FL_nativity
ADD COLUMN Noncitizen_poverty_rate NUMERIC ;
UPDATE FL_poverty
SET “Noncitizen_poverty_rate” = (Income_below_poverty / Id) ;
Noncitizen poverty rate top county – Miami-Dade County (1.06)
Noncitizen poverty rate bottom county – Liberty County (.0024)
**Not sure if I did the bonus question coding correctly but I didn’t get an error message and added the column so I call that a success!
Great work here. Nice documentation and the rest.
You bravely went where no one has gone with the bonus question. I think there’s a problem with the math, though — you should have divided the poverty into population.
I would do this:
SET “Native_poverty_rate” = (Income_below_poverty / Total) ;
Instead of this:
SET “Native_poverty_rate” = (Income_below_poverty / Id) ;
We will discuss. Great work, regardless.