Not being able to name column with more than one word

I found out that I cannot name the columns more than one word and otherwise, the 2nd word of column name appears in Data-Type. Does anyone know how I can name column with more than a word without affecting data-type? Thanks in advance.

Screen Shot 2022-03-01 at 9.50.47 AM

Here is my code and attached is how it appears when I run it.

CREATE TABLE Timetable (
Employee Name TEXT,
ID INTEGER,
DOB DATE,
Management Rating REAL
);

SELECT *
FROM Timetable;

You have to use an underscore.
Ex:
Employee_Name

Or, less clear to read: EmployeeName

1 Like