I had a lot of help with this. We originally tried uploading the data into SQL without changing the headings to match (match each other in order to join in SQL; they were cleaned up and such before hand). Then the person helping me figured out that we had to make the headings match. We used to find & replace to change all the headings to match with the counties. We uploaded the data back into SQL and created the attached table by inner-joining by county.
I’m not sure that this is what the table is supposed to look like, but at least I (we) got something to show up.
Good -you put in a solid effort.
Something is still wrong here. I matched 14 fields; you matched four. I am thinking the data on the matching columns was not trimmed properly.
See the homework answer and data that I posted:
https://wordpressua.uark.edu/datareporting/final-project-april-18-may-4/