INSERT INTO Customers
(customer_id, salutation, customer_first_name, customer_middle_initial,
 customer_last_name, gender, email_address, login_name, login_password,
 phone_number, address, town_city, county, country)
VALUES
(1001, 'Mr.', 'Porter', 'F.', 'Scobey', 'M', 'p_scobey@smu.ca', 'porter', 'porter',
 '902-423-1234', '123 Main St.  A1A B2B', 'Halifax', 'NS', 'Canada');
