CREATE TABLE Vendors
(
Vendor_ID varchar (7) not null PRIMARY KEY,
Name varchar (10) not null,
Order_Address varchar (5) not null,
Order_Street varchar (10) not null,
Order_City varchar (15) not null,
Order_State char (2) not null,
Order_Zip int not null,
Order_Contact char (15) not null,
Order_Phone_Number varchar (15) not null,
Order_Fax_Number varchar (15), 
Billing_Address varchar (5) not null,
Billing_Street varchar (10) not null,
Billing_City varchar (15) not null,
Billing_State char (2) not null,
Billing_Zip int not null,
Billing_Contact char (15) not null,
Billing_Phone_Number varchar (15) not null,
Billing_Fax_Number varchar (15) not null
);
 
INSERT INTO Vendors VALUES
('SAP8','Sears','5178','Pearl Road','Cleveland','OH','44129','Mary Kay','(216)351-3279','(216)351-7500','6600','Bessemer Avenue','Cleveland','OH','44127','John Smith','(216)341-7140','(216)429-3523');
INSERT INTO Vendors VALUES
('NA00','NAPA','3141','Superior Avenue','Cleveland','OH','44114','Andrew Linder','(216)771-1515','(216)398-9800','6600','Bessemer Avenue','Cleveland','OH','44127','John Smith','(216)341-7140','(216)429-3523');
 

CkNSRUFURSBUQUJMRSBWZW5kb3JzCigKVmVuZG9yX0lEIHZhcmNoYXIgKDcpIG5vdCBudWxsIFBSSU1BUlkgS0VZLApOYW1lIHZhcmNoYXIgKDEwKSBub3QgbnVsbCwKT3JkZXJfQWRkcmVzcyB2YXJjaGFyICg1KSBub3QgbnVsbCwKT3JkZXJfU3RyZWV0IHZhcmNoYXIgKDEwKSBub3QgbnVsbCwKT3JkZXJfQ2l0eSB2YXJjaGFyICgxNSkgbm90IG51bGwsCk9yZGVyX1N0YXRlIGNoYXIgKDIpIG5vdCBudWxsLApPcmRlcl9aaXAgaW50IG5vdCBudWxsLApPcmRlcl9Db250YWN0IGNoYXIgKDE1KSBub3QgbnVsbCwKT3JkZXJfUGhvbmVfTnVtYmVyIHZhcmNoYXIgKDE1KSBub3QgbnVsbCwKT3JkZXJfRmF4X051bWJlciB2YXJjaGFyICgxNSksIApCaWxsaW5nX0FkZHJlc3MgdmFyY2hhciAoNSkgbm90IG51bGwsCkJpbGxpbmdfU3RyZWV0IHZhcmNoYXIgKDEwKSBub3QgbnVsbCwKQmlsbGluZ19DaXR5IHZhcmNoYXIgKDE1KSBub3QgbnVsbCwKQmlsbGluZ19TdGF0ZSBjaGFyICgyKSBub3QgbnVsbCwKQmlsbGluZ19aaXAgaW50IG5vdCBudWxsLApCaWxsaW5nX0NvbnRhY3QgY2hhciAoMTUpIG5vdCBudWxsLApCaWxsaW5nX1Bob25lX051bWJlciB2YXJjaGFyICgxNSkgbm90IG51bGwsCkJpbGxpbmdfRmF4X051bWJlciB2YXJjaGFyICgxNSkgbm90IG51bGwKKTsKCklOU0VSVCBJTlRPIFZlbmRvcnMgVkFMVUVTCignU0FQOCcsJ1NlYXJzJywnNTE3OCcsJ1BlYXJsIFJvYWQnLCdDbGV2ZWxhbmQnLCdPSCcsJzQ0MTI5JywnTWFyeSBLYXknLCcoMjE2KTM1MS0zMjc5JywnKDIxNikzNTEtNzUwMCcsJzY2MDAnLCdCZXNzZW1lciBBdmVudWUnLCdDbGV2ZWxhbmQnLCdPSCcsJzQ0MTI3JywnSm9obiBTbWl0aCcsJygyMTYpMzQxLTcxNDAnLCcoMjE2KTQyOS0zNTIzJyk7CklOU0VSVCBJTlRPIFZlbmRvcnMgVkFMVUVTCignTkEwMCcsJ05BUEEnLCczMTQxJywnU3VwZXJpb3IgQXZlbnVlJywnQ2xldmVsYW5kJywnT0gnLCc0NDExNCcsJ0FuZHJldyBMaW5kZXInLCcoMjE2KTc3MS0xNTE1JywnKDIxNikzOTgtOTgwMCcsJzY2MDAnLCdCZXNzZW1lciBBdmVudWUnLCdDbGV2ZWxhbmQnLCdPSCcsJzQ0MTI3JywnSm9obiBTbWl0aCcsJygyMTYpMzQxLTcxNDAnLCcoMjE2KTQyOS0zNTIzJyk7Cg==

c2VsZWN0ICogZnJvbSBWZW5kb3Jz

select * from Vendors