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

Q1JFQVRFIFRBQkxFIFZlbmRvcnMKKApWZW5kb3JfSUQgdmFyY2hhciAoNykgbm90IG51bGwgUFJJTUFSWSBLRVksCk5hbWUgdmFyY2hhciAoMTApIG5vdCBudWxsLApPcmRlcl9BZGRyZXNzIHZhcmNoYXIgKDUpIG5vdCBudWxsLApPcmRlcl9TdHJlZXQgdmFyY2hhciAoMTApIG5vdCBudWxsLApPcmRlcl9DaXR5IHZhcmNoYXIgKDE1KSBub3QgbnVsbCwKT3JkZXJfU3RhdGUgY2hhciAoMikgbm90IG51bGwsCk9yZGVyX1ppcCBpbnQgbm90IG51bGwsCk9yZGVyX0NvbnRhY3QgY2hhciAoMTUpIG5vdCBudWxsLApPcmRlcl9QaG9uZV9OdW1iZXIgdmFyY2hhciAoMTUpIG5vdCBudWxsLApPcmRlcl9GYXhfTnVtYmVyIHZhcmNoYXIgKDE1KSwgCkJpbGxpbmdfQWRkcmVzcyB2YXJjaGFyICg1KSBub3QgbnVsbCwKQmlsbGluZ19TdHJlZXQgdmFyY2hhciAoMTApIG5vdCBudWxsLApCaWxsaW5nX0NpdHkgdmFyY2hhciAoMTUpIG5vdCBudWxsLApCaWxsaW5nX1N0YXRlIGNoYXIgKDIpIG5vdCBudWxsLApCaWxsaW5nX1ppcCBpbnQgbm90IG51bGwsCkJpbGxpbmdfQ29udGFjdCBjaGFyICgxNSkgbm90IG51bGwsCkJpbGxpbmdfUGhvbmVfTnVtYmVyIHZhcmNoYXIgKDE1KSBub3QgbnVsbCwKQmlsbGluZ19GYXhfTnVtYmVyIHZhcmNoYXIgKDE1KSBub3QgbnVsbAopOwoKSU5TRVJUIElOVE8gVmVuZG9ycyBWQUxVRVMKKCdTQVA4JywnU2VhcnMnLCc1MTc4JywnUGVhcmwgUm9hZCcsJ0NsZXZlbGFuZCcsJ09IJywnNDQxMjknLCdNYXJ5IEtheScsJygyMTYpMzUxLTMyNzknLCcoMjE2KTM1MS03NTAwJywnNjYwMCcsJ0Jlc3NlbWVyIEF2ZW51ZScsJ0NsZXZlbGFuZCcsJ09IJywnNDQxMjcnLCdKb2huIFNtaXRoJywnKDIxNikzNDEtNzE0MCcsJygyMTYpNDI5LTM1MjMnKTsKSU5TRVJUIElOVE8gVmVuZG9ycyBWQUxVRVMKKCdOQTAwJywnTkFQQScsJzMxNDEnLCdTdXBlcmlvciBBdmVudWUnLCdDbGV2ZWxhbmQnLCdPSCcsJzQ0MTE0JywnQW5kcmV3IExpbmRlcicsJygyMTYpNzcxLTE1MTUnLCcoMjE2KTM5OC05ODAwJywnNjYwMCcsJ0Jlc3NlbWVyIEF2ZW51ZScsJ0NsZXZlbGFuZCcsJ09IJywnNDQxMjcnLCdKb2huIFNtaXRoJywnKDIxNikzNDEtNzE0MCcsJygyMTYpNDI5LTM1MjMnKTsK

c2VsZWN0ICogZnJvbSBWZW5kb3Jz

select * from Vendors