create table Customers (
 CustomerID int,
 FirstName varchar(30),
 PreferredName varchar(30),
 Title varchar(4),
 LastName varchar(30)
);

insert into Customers (CustomerID, FirstName, PreferredName, Title, LastName)
values (1, 'John', NULL, 'Mr.', 'Smith'), (2, 'Jane', NULL, NULL, 'Smith'),  (3, 'Robert', 'Bob', NULL, 'Jones');