Error occured in my sql

Hi King!
Thanks for reaching out.

Please, use the following code:

USE sales; 

CREATE TABLE sales (
    purchase_number INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    date_of_purchase DATE NOT NULL,
    customer_id INT,
    item_code VARCHAR(10) NOT NULL
);

Hope this helps.
Best,
Tsvetelin