The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

Create the “customers” table from Sales database

Create the “customers” table from Sales database


After the lesson (Creating a Table). I tried attempting the exercise, which is;
Create the “customers” table in the “sales” database. Let it contain the following 5 columns: customer_idfirst_namelast_nameemail_address, and number_of_complaints. Let the data types of customer_id and number_of_complaints be integer, while the data types of all other columns be VARCHAR of 255.
 But it didn’t pull through when I input the execute icon, showing me an error message. This is my attempt
USE sales;
CREATE TABLE customers,
customers_Id INT,
first_name VARCHAR(255)
last_name VARCHAR(255)
email_address VARCHAR(255)
number_of_complaints INT
Then I press execute. But its giving me an error message. Please assist me. What am I doing wrong

1 Answer

Commas, you forget commas, my friend.
You should not use comma after table name ‘customers’. And you have to use commas in the end of each expression in brackets except the last one.