.csv file:
Identify the counties and the rates of all counties with poverty rates greater than 25%:
Hamilton County (29%), Putnam County (28%), Holmes County (27%), Madison County (25%), Gadsden County (26%), Okeechobee County (26%), DeSoto County (29%), Hardee County (26%)
Identify the TOP 10 counties with the highest non-citizen population by ratio:
Miami-Dade County, Hendry County, Broward County, Collier County, DeSoto County, Hardee County, Palm Beach County, Orange County, Glades County, Osceola County
Identify the TOP 10 counties with the highest US poverty by ratio:
Hamilton County, Putnam County, Holmes County, Madison County, Gadsden County, Okeechobee County, DeSoto County, Hardee County, Suwannee County, Gilchrist County
I arrived at a slightly different answer for the first question:
–Identify the counties and the rates of all counties with poverty rates greater than 25%
SELECT Geography, TOTALPOVERTY_Ratio
FROM FL_POV_IMM2
WHERE TOTALPOVERTY_RATIO > 25
Order By TOTALPoverty_Ratio DESC ;
Answer:
DeSoto County, 30.6
Hamilton County, 29.3
Putnam County, 28.7
Holmes County, 27.8
Okeechobee County, 27.7
Hardee County, 27.4
Gadsden County, 27.1
Hendry County, 26.4
Madison County, 25.7
https://wordpressua.uark.edu/datareporting/april-6-class/
You needed to post the data with the counties. That’s sort of self-evident!
Surprised you didn’t tackle the bonus question.