I had a few problems upon trying to do this assignment. My first initial problem came when I noticed that I did not save what we were working on class to my flash drive. I think from now on I’m just going to bring my laptop to class that way I can always ensure that I have my classwork saved. So, because I did not save my work, I had to create a new database with the FL_nativity. I was finally successful with this, as I was able to upload the csv file for FL_nativity. This is where I began to feel like I truly did not know where to turn. I began to import FL_poverty, so that I could link the two tables together and run some codes. However upon doing this, I remembered that we used specific labels for the many columns in FL_poverty, and I did not remember what those labels were, which would certainly affect how I come up with answers and running codes properly.  I let the existing labels stay the same for the FL_poverty table. I then went on, to try to do the first step of joining the two tables at id2, however I was unsure of how to join the two tables together. I viewed the tutorial, and used coding:

 

SELECT Id2
FROM FL_nativity_1
INNER JOIN FL_poverty2 ON FL_nativity_1.Id2 = FL_poverty2.Id2;

 

However, I received an error message back that said “ambiguous column name: Id2”.

I’m assuming my coding is what is wrong, though I toyed around with the code for a bit trying to get it to work and was unsuccessful. Being unable to join the two tables together, I was unable to do any of the following steps. I would say this assignment was a failure for me, but by paying closer attention in class, taking detailed notes in class, and by making sure that I bring my laptop to class each day, I feel that I will be successful on upcoming assignments.