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');