by Nathan Smith | Apr 16, 2017 | Student_Work
I had a couple issues with the Homework. I could not get my data, whenever I imported it to SQL, to show that the numbers on the data are actual numbers. It kept reading them as text and I could not figure out how to fix this.
by Nathan Smith | Apr 16, 2017 | Student_Work
I used the formula: SELECT * FROM Census INNER JOIN Crime ON Census.County = Crime.County I changed Place in the Crime sheet to be called “County” and tried cleaning the data so that both had columns on the far left side with counties in them, but while...
by Nathan Smith | Apr 16, 2017 | Student_Work
SELECT * FROM Census_data INNER JOIN FBI_data ON Census_data.County = FBI_data.Place Census_FBIcrime_combined
by Nathan Smith | Apr 16, 2017 | Student_Work
Code Used: SELECT * FROM Census_SR INNER JOIN Crime_SR ON Census_SR.County = Crime_SR.Place ; Census_Crime_Combined_SR3 Not sure if I exported my file correctly, I can show you in class my file on SQL if necessary.
by Nathan Smith | Apr 16, 2017 | Student_Work
Crime_Census_COMBINED Code: SELECT * FROM Census INNER JOIN Crime ON Census.County = Crime.Place ;
Recent Comments