After trying for a good amount of time I think I successfully joined FL_nativity and FL_poverty at the Id2 column. I am still not sure since I don’t know what a proper join looks like between two tables with the same column name, but this is what I came up with:

I hid some columns in the table on the right so that both Id2 columns were visible.

Questions:

The county with the highest estimate of people in poverty is Miami-Dade County with 530,006, while the county with the lowest estimate is Liberty County with1,237.

The top three counties with the highest non-citizen poverty are Miami-Dade County with 164,550, Broward County with 55,443 and Palm Beach County with 41,352.