1e) V2: Table definition (Exercise 07)

Question

For task 1e, the format which I wrote in answer: CREATE TABLE securedb(ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT NOT NULL, ADDRESS TEXT NOT NULL, CITY TEXT NOT NULL, SALARY INTEGER) 

- Expected Format example: CREATE TABLE students(ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL)

- This is the feedback which I received after the excersise was graded: The correct answer is: CREATE TABLE securedb ( ID Integer Primary Key AUTOINCREMENT, Name Text NOT Null, Address Text NOT Null, City Text NOT Null, Salary Integer )

Could you please explain me why my answer was marked incorrect? As per me, both are exactly same.

Answer 1

As pointed out in this question, the format example was incorrect. All correct answers that adhered to the format example were re-graded.

However, the answer you give here does not match the table definition, because the column names are different in the database (different capitalization).