CREATE TABLE Customer
 ( 
 CustomerID INTEGER Primary Key NOT NULL, 
 FirstName CHAR(50) NOT NULL, 
 LastName CHAR(50) NOT NULL, 
 HomePhone CHAR(20), 
 Address CHAR(50), 
 State CHAR(02), 
 City CHAR(30), 
 PostalCode INTEGER
 );

 



INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (1, 'John', 'Dentins', '(808) 897-4321', ' 2211 22nd Ave N', 'GA', 'Atlanta', 98718);

INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (2, 'Sam', 'Elliot', '(719) 898-2134', '1601 Center loop', 'FL', 'Tampa', 98982); 

INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (3, 'Adam', 'Williams', '(898) 321-2234', '3890-A Cherry loop', 'ND', 'Fargo', 58729); 

INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (4, 'Jacob', 'Lincoln', NULL, '2609 40th Ave S', 'OK', 'Tulsa', 36711); 

INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (5, 'Timothy', 'Coney', '(202) 827-4331', '1900 3rd St. N', 'OR', 'Salem', 44812); 

INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (6, 'Jill', 'Stephens', '(813) 215-5551', '1544 33rd Ave E', 'FL', 'Miami', 98911); 

INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (7, 'Tina', 'West', '(813) 565-4984', '1000 45th Ave N', 'FL', 'Miami', 98911); 

INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (8, 'Shawn', 'Leaven', '(813) 248-8854', '1908 22nd Ave S', 'FL', 'Miami', 98912); 

INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (9, 'Jackie', 'Justin', NULL, '1800 4rd St. N', 'FL', 'Miami', 98902); 

INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (10, 'Lilly', 'Ward', '(813) 244-5522', '1010 33rd Ave N', 'FL', 'Miami', 98909);

INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (12, 'Larry', 'Carr', '(808) 423-7894', '114 - C 45th Ave N', 'HI', 'Honolulu', 96818);

INSERT INTO Customer (CustomerID, FirstName, LastName, HomePhone, Address, State, City, PostalCode) 
 Values (13, 'Lisa', 'Glenn', '(808) 421-7515', '1542 33rd Ave N', 'HI', 'Honolulu', 96818);