drop table customer1;

create table customer1 (
  SSN varchar(9),
  lastNAme varchar(20),
  firstname varchar(20),
  address1 varchar(20),
  address2 varchar(20),
  city varchar(10),
  state varchar(10),
  zipcode varchar(5),
  balance decimal(10,2) );

insert into customer1 values ('123456789', 'Smith', 'Rob', '1111', 'First Street', 'San Jose', 'CA', '12345', 123);