create table addresses ( 
   name varchar(40), 
   add1 varchar(40), 
   add2 varchar(40), 
   city varchar(25), 
   state varchar(2), 
   zip varchar(5) ); 


insert into addresses values
  ('John Doe','123 Mount Pleasant', 'Suite 100', 'Chicago', 'IL', '24422'); 
insert into addresses values
  ('Jane Smith','96 East Parkway', '', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Elvis Persy','96 Graceway', '', 'Memphis', 'TN', '38101');
insert into addresses values
  ('Jack Daniels','123 Speakeasy Dr', '', 'Lindenburg', 'TN', '24422');
insert into addresses values
  ('John Doe','123 Mount Pleasant', 'Suite 100', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Jane Smith','96 East Parkway', '', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Elvis Persy','96 Graceway', '', 'Memphis', 'TN', '38101');
insert into addresses values
  ('Jack Daniels','123 Speakeasy Dr', '', 'Lindenburg', 'TN', '24422');
insert into addresses values
  ('John Doe','123 Mount Pleasant', 'Suite 100', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Jane Smith','96 East Parkway', '', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Elvis Persy','96 Graceway', '', 'Memphis', 'TN', '38101');
insert into addresses values
  ('Jack Daniels','123 Speakeasy Dr', '', 'Lindenburg', 'TN', '24422');
insert into addresses values
  ('John Doe','123 Mount Pleasant', 'Suite 100', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Jane Smith','96 East Parkway', '', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Elvis Persy','96 Graceway', '', 'Memphis', 'TN', '38101');
insert into addresses values
  ('Jack Daniels','123 Speakeasy Dr', '', 'Lindenburg', 'TN', '24422');
insert into addresses values
  ('John Doe','123 Mount Pleasant', 'Suite 100', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Jane Smith','96 East Parkway', '', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Elvis Persy','96 Graceway', '', 'Memphis', 'TN', '38101');
insert into addresses values
  ('Jack Daniels','123 Speakeasy Dr', '', 'Lindenburg', 'TN', '24422');
insert into addresses values
  ('John Doe','123 Mount Pleasant', 'Suite 100', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Jane Smith','96 East Parkway', '', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Elvis Persy','96 Graceway', '', 'Memphis', 'TN', '38101');
insert into addresses values
  ('Jack Daniels','123 Speakeasy Dr', '', 'Lindenburg', 'TN', '24422');
insert into addresses values
  ('John Doe','123 Mount Pleasant', 'Suite 100', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Jane Smith','96 East Parkway', '', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Elvis Persy','96 Graceway', '', 'Memphis', 'TN', '38101');
insert into addresses values
  ('Jack Daniels','123 Speakeasy Dr', '', 'Lindenburg', 'TN', '24422');
insert into addresses values
  ('John Doe','123 Mount Pleasant', 'Suite 100', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Jane Smith','96 East Parkway', '', 'Chicago', 'IL', '24422');
insert into addresses values
  ('Elvis Persy','96 Graceway', '', 'Memphis', 'TN', '38101');
insert into addresses values
  ('Jack Daniels','123 Speakeasy Dr', '', 'Lindenburg', 'TN', '24422');



