create table Customers (
 CustomerID int,
 FirstName varchar(30),
 PreferredName varchar(30) not null,
 LastName varchar(30)
);