insert into sales_rep values 
('03','Jones','Mary','123 Main','Grant','MI','49219',2150,0.05);
insert into sales_rep values 
('06','Smith','William','102 Raymond','Ada','MI','49441',4912.5,0.07);
insert into sales_rep values 
('12','Diaz','Miguel','419 Harper','Lansing','MI','49224',2150,0.05);


insert into customer values 
('124','Adams','Sally','481 Oak','Lansing','MI','49224',818.75,1000,'03');
insert into customer values 
('256','Samuels','Ann','215 Pete','Grant','MI','49219',21.5,1500,'06');
insert into customer values 
('311','Charles','Don','48 College','Ira','MI','49034',825.75,1000,'12');
insert into customer values 
('315','Daniels','Tom','914 Cherry','Kent','MI','48391',770.75,750,'06');
insert into customer values 
('405','Williams','Al','519 Watson','Grant','MI','49219',402.75,1500,'12');
insert into customer values 
('412','Adams','Sally','16 Elm','Lansing','MI','49224',1817.5,2000,'03');
insert into customer values 
('522','Nelson','Mary','108 Pine','Ada','MI','49441',98.75,1500,'12');
insert into customer values 
('567','Dinh','Tran','808 Ridge','Harper','MI','48421',402.4,750,'06');
insert into customer values 
('587','Galvez','Mara','512 Pine','Ada','MI','49441',114.6,1000,'06');
insert into customer values 
('622','Martin','Dan','419 Chip','Grant','MI','49219',1045.75,1000,'03');


insert into orders values
('12489','02-Sep-1998','124');
insert into orders values
('12491','02-Sep-1998','311');
insert into orders values
('12494','04-Sep-1998','315');
insert into orders values
('12495','04-Sep-1998','256');
insert into orders values
('12498','05-Sep-1998','522');
insert into orders values
('12500','05-Sep-1998','124');
insert into orders values
('12504','05-Sep-1998','522');


insert into part values 
('AX12','Iron',104,'HW','3',24.95);
insert into part values 
('AZ52','Dartboard',20,'SG','2',12.95);
insert into part values 
('BA74','Basketball',40,'SG','1',29.95);
insert into part values 
('BH22','Cornpopper',95,'HW','3',24.95);
insert into part values 
('BT04','Gas Grill',11,'AP','2',149.99);
insert into part values 
('BZ66','Washer',52,'AP','3',399.99);
insert into part values 
('CA14','Griddle',78,'HW','3',39.99);
insert into part values 
('CB03','Bike',44,'SG','1',299.99);
insert into part values 
('CX11','Blender',112,'HW','3',22.95);
insert into part values 
('CZ81','Treadmill',68,'SG','2',349.95);


insert into order_line values 
('12489','AX12',11,21.95);
insert into order_line values 
('12491','BT04',1,149.99);
insert into order_line values 
('12491','BZ66',1,399.99);
insert into order_line values 
('12494','CB03',4,279.99);
insert into order_line values 
('12495','CX11',2,22.95);
insert into order_line values 
('12498','AZ52',2,12.95);
insert into order_line values 
('12498','BA74',4,24.95);
insert into order_line values 
('12500','BT04',1,149.99);
insert into order_line values 
('12504','CZ81',2,325.99);