Hello,
I imported a file called sanfranciscofilmlocations.csv and one of the column headings is "Release Year". I tried the following statement but it gives "Release Year" for all rows. Could you help me with fixing it?
SELECT "Release Year" FROM sanfranciscofilmlocations;
As far as I understood, column headings cannot include two or more words but has to be linked; eg. "Release_Year" instead of "Release Year". I also tried to change the .csv file in that way but couldn't save as a .csv.
I searched online to come up with a solution, but didn't find a method. Please note that I am new to SQL.