orders.sql

--Author - Kushal Jangid

---------------- ----------Guest_ID(PK),Product_ID(PK),Date_Of_Orders(PK),Time(PK),Quantity


insert into Orders values('F1001', 'P0029', '2015/01/01', '13:00', '2');
insert into Orders values('F1001', 'P0035', '2015/01/01', '13:00', '2');
insert into Orders values('F1001', 'P0048', '2015/01/01', '13:00', '1');
insert into Orders values('F1001', 'P0001', '2015/01/01', '13:00', '2');
insert into Orders values('F1001', 'P0011', '2015/01/01', '13:00', '2');
insert into Orders values('F1001', 'P0018', '2015/01/01', '13:00', '7');
insert into Orders values('F1001', 'P0044', '2015/01/01', '13:00', '2');
insert into Orders values('F1001', 'P0060', '2015/01/01', '13:00', '2');

------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1002', 'P0073', '2015/01/01', '14:00', '2');
insert into Orders values('F1002', 'P0085', '2015/01/01', '14:00', '2');
insert into Orders values('F1002', 'P0018', '2015/01/01', '14:00', '8');
insert into Orders values('F1002', 'P0033', '2015/01/01', '14:00', '2');
insert into Orders values('F1002', 'P0101', '2015/01/01', '14:00', '1');
insert into Orders values('F1002', 'P0122', '2015/01/01', '14:00', '2');

------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1003', 'P0043', '2015/01/01', '17:00', '2');
insert into Orders values('F1003', 'P0101', '2015/01/01', '17:00', '1');
insert into Orders values('F1003', 'P0132', '2015/01/01', '17:00', '2');
insert into Orders values('F1003', 'P0116', '2015/01/01', '17:00', '2');
insert into Orders values('F1003', 'P0102', '2015/01/01', '17:00', '1');
insert into Orders values('F1003', 'P0099', '2015/01/01', '17:00', '3');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1001', 'P0077', '2015/01/01', ' 21:00', '1');
insert into Orders values('C1001', 'P0093', '2015/01/01', ' 21:00', '1');
insert into Orders values('C1001', 'P0124', '2015/01/01', ' 21:00', '2');

insert into Orders values('C1001', 'P0002', '2015/01/02', ' 12:00', '1');
insert into Orders values('C1001', 'P0009', '2015/01/02', ' 12:00', '2');
insert into Orders values('C1001', 'P0017', '2015/01/02', ' 12:00', '2');

insert into Orders values('C1001', 'P0032', '2015/01/02', ' 20:00', '3');
insert into Orders values('C1001', 'P0052', '2015/01/02', ' 20:00', '1');
insert into Orders values('C1001', 'P0145', '2015/01/02', ' 20:00', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1004', 'P0003', '2015/01/02', ' 12:00', '2');
insert into Orders values('F1004', 'P0011', '2015/01/02', ' 12:00', '3');
insert into Orders values('F1004', 'P0023', '2015/01/02', ' 12:00', '2');

insert into Orders values('F1004', 'P0031', '2015/01/02', ' 20:00', '1');
insert into Orders values('F1004', 'P0043', '2015/01/02', ' 20:00', '1');
insert into Orders values('F1004', 'P0054', '2015/01/02', ' 20:00', '2');

insert into Orders values('F1004', 'P0006', '2015/01/03', ' 12:00', '1');
insert into Orders values('F1004', 'P0014', '2015/01/03', ' 12:00', '2');
insert into Orders values('F1004', 'P0025', '2015/01/03', ' 12:00', '4');

insert into Orders values('F1004', 'P0032', '2015/01/03', ' 21:00', '1');
insert into Orders values('F1004', 'P0041', '2015/01/03', ' 21:00', '2');
insert into Orders values('F1004', 'P0059', '2015/01/03', ' 21:00', '1');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1002', 'P0099', '2015/01/02', ' 21:00', '2');
insert into Orders values('C1002', 'P0104', '2015/01/02', ' 21:00', '2');
insert into Orders values('C1002', 'P0111', '2015/01/02', ' 21:00', '2');

insert into Orders values('C1002', 'P0003', '2015/01/03', ' 12:00', '3');
insert into Orders values('C1002', 'P0019', '2015/01/03', ' 12:00', '1');
insert into Orders values('C1002', 'P0046', '2015/01/03', ' 12:00', '1');

insert into Orders values('C1002', 'P0054', '2015/01/03', ' 21:30', '2');
insert into Orders values('C1002', 'P0062', '2015/01/03', ' 21:30', '1');
insert into Orders values('C1002', 'P0098', '2015/01/03', ' 21:30', '2');

insert into Orders values('C1002', 'P0013', '2015/01/04', ' 12:00', '1');
insert into Orders values('C1002', 'P0055', '2015/01/04', ' 12:00', '2');
insert into Orders values('C1002', 'P0066', '2015/01/04', ' 12:00', '2');


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1005', 'P0034', '2015/01/03', ' 12:00', '2');
insert into Orders values('F1005', 'P0051', '2015/01/03', ' 12:00', '2');
insert into Orders values('F1005', 'P0066', '2015/01/03', ' 12:00', '2');

insert into Orders values('F1005', 'P0004', '2015/01/03', ' 21:00', '2');
insert into Orders values('F1005', 'P0014', '2015/01/03', ' 21:00', '2');
insert into Orders values('F1005', 'P0018', '2015/01/03', ' 21:00', '2');

insert into Orders values('F1005', 'P0111', '2015/01/04', ' 12:00', '2');
insert into Orders values('F1005', 'P0125', '2015/01/04', ' 12:00', '2');
insert into Orders values('F1005', 'P0130', '2015/01/04', ' 12:00', '2');

insert into Orders values('F1005', 'P0083', '2015/01/04', ' 20:00', '2');
insert into Orders values('F1005', 'P0075', '2015/01/04', ' 20:00', '2');
insert into Orders values('F1005', 'P0105', '2015/01/04', ' 20:00', '2');




----------------------------------------------------------------------------------------------------------------------------------------------------------------------


insert into Orders values('C1003', 'P0009', '2015/01/03', ' 12:00', '1');
insert into Orders values('C1003', 'P0012', '2015/01/03', ' 12:00', '3');
insert into Orders values('C1003', 'P0026', '2015/01/03', ' 12:00', '2');

insert into Orders values('C1003', 'P0029', '2015/01/03', ' 21:30', '2');
insert into Orders values('C1003', 'P0038', '2015/01/03', ' 21:30', '1');
insert into Orders values('C1003', 'P0050', '2015/01/03', ' 21:30', '2');

insert into Orders values('C1003', 'P0061', '2015/01/04', ' 12:30', '2');
insert into Orders values('C1003', 'P0068', '2015/01/04', ' 12:30', '2');
insert into Orders values('C1003', 'P0073', '2015/01/04', ' 12:30', '1');

insert into Orders values('C1003', 'P0082', '2015/01/04', ' 21:00', '1');
insert into Orders values('C1003', 'P0094', '2015/01/04', ' 21:00', '2');
insert into Orders values('C1003', 'P0099', '2015/01/04', ' 21:00', '2');
insert into Orders values('C1003', 'P0125', '2015/01/04', ' 21:00', '1');

insert into Orders values('C1003', 'P0008', '2015/01/05', ' 12:30', '2');
insert into Orders values('C1003', 'P0013', '2015/01/05', ' 12:30', '1');
insert into Orders values('C1003', 'P0019', '2015/01/05', ' 12:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1004', 'P0082', '2015/01/03', ' 12:30', '1');
insert into Orders values('C1004', 'P0094', '2015/01/03', ' 12:30', '2');
insert into Orders values('C1004', 'P0099', '2015/01/03', ' 12:30', '2');
insert into Orders values('C1004', 'P0125', '2015/01/03', ' 12:30', '1');

insert into Orders values('C1004', 'P0008', '2015/01/03', ' 21:00', '2');
insert into Orders values('C1004', 'P0013', '2015/01/03', ' 21:00', '1');
insert into Orders values('C1004', 'P0019', '2015/01/03', ' 21:00', '2');

insert into Orders values('C1004', 'P0031', '2015/01/04', ' 13:00', '1');
insert into Orders values('C1004', 'P0038', '2015/01/04', ' 13:00', '1');
insert into Orders values('C1004', 'P0053', '2015/01/04', ' 13:00', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1006', 'P0082', '2015/01/03', ' 21:00', '1');
insert into Orders values('F1006', 'P0093', '2015/01/03', ' 21:00', '1');
insert into Orders values('F1006', 'P0099', '2015/01/03', ' 21:00', '2');
insert into Orders values('F1006', 'P0105', '2015/01/03', ' 21:00', '2');

insert into Orders values('F1006', 'P0113', '2015/01/04', ' 13:00', '2');
insert into Orders values('F1006', 'P0128', '2015/01/04', ' 13:00', '2');
insert into Orders values('F1006', 'P0135', '2015/01/04', ' 13:00', '1');

insert into Orders values('F1006', 'P0001', '2015/01/04', ' 20:00', '3');
insert into Orders values('F1006', 'P0012', '2015/01/04', ' 20:00', '1');
insert into Orders values('F1006', 'P0017', '2015/01/04', ' 20:00', '1');

insert into Orders values('F1006', 'P0028', '2015/01/05', ' 12:00', '1');
insert into Orders values('F1006', 'P0035', '2015/01/05', ' 12:00', '2');
insert into Orders values('F1006', 'P0048', '2015/01/05', ' 12:00', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1005', 'P0028', '2015/01/04', ' 12:00', '1');
insert into Orders values('C1005', 'P0035', '2015/01/04', ' 12:00', '2');
insert into Orders values('C1005', 'P0048', '2015/01/04', ' 12:00', '2');

insert into Orders values('C1005', 'P0061', '2015/01/04', ' 21:00', '1');
insert into Orders values('C1005', 'P0064', '2015/01/04', ' 21:00', '1');
insert into Orders values('C1005', 'P0073', '2015/01/04', ' 21:00', '1');
insert into Orders values('C1005', 'P0084', '2015/01/04', ' 21:00', '2');

insert into Orders values('C1005', 'P0095', '2015/01/05', ' 13:00', '1');
insert into Orders values('C1005', 'P0099', '2015/01/05', ' 13:00', '2');
insert into Orders values('C1005', 'P0101', '2015/01/05', ' 13:00', '2');

insert into Orders values('C1005', 'P0107', '2015/01/05', ' 21:00', '1');
insert into Orders values('C1005', 'P0116', '2015/01/05', ' 21:00', '2');
insert into Orders values('C1005', 'P0127', '2015/01/05', ' 21:00', '3');
insert into Orders values('C1005', 'P0137', '2015/01/05', ' 21:00', '1');


------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1006', 'P0031', '2015/01/04', ' 21:00', '1');
insert into Orders values('C1006', 'P0064', '2015/01/04', ' 21:00', '1');
insert into Orders values('C1006', 'P0033', '2015/01/04', ' 21:00', '1');
insert into Orders values('C1006', 'P0084', '2015/01/04', ' 21:00', '2');

insert into Orders values('C1006', 'P0107', '2015/01/05', ' 12:00', '1');
insert into Orders values('C1006', 'P0099', '2015/01/05', ' 12:00', '2');
insert into Orders values('C1006', 'P0129', '2015/01/05', ' 12:00', '3');
insert into Orders values('C1006', 'P0137', '2015/01/05', ' 12:00', '1');


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1007', 'P0102', '2015/01/04', ' 21:30', '2');
insert into Orders values('C1007', 'P0108', '2015/01/04', ' 21:30', '1');
insert into Orders values('C1007', 'P0111', '2015/01/04', ' 21:30', '2');
insert into Orders values('C1007', 'P0063', '2015/01/04', ' 21:30', '2');

insert into Orders values('C1007', 'P0005', '2015/01/05', ' 12:00', '2');
insert into Orders values('C1007', 'P0013', '2015/01/05', ' 12:00', '1');
insert into Orders values('C1007', 'P0019', '2015/01/05', ' 12:00', '2');
insert into Orders values('C1007', 'P0026', '2015/01/05', ' 12:00', '1');
insert into Orders values('C1007', 'P0030', '2015/01/05', ' 12:00', '1');
insert into Orders values('C1007', 'P0039', '2015/01/05', ' 12:00', '1');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1007', 'P0066', '2015/01/05', ' 13:30', '1');
insert into Orders values('F1007', 'P0073', '2015/01/05', ' 13:30', '2');
insert into Orders values('F1007', 'P0082', '2015/01/05', ' 13:30', '1');

insert into Orders values('F1007', 'P0093', '2015/01/05', ' 21:00', '2');
insert into Orders values('F1007', 'P0099', '2015/01/05', ' 21:00', '2');
insert into Orders values('F1007', 'P0106', '2015/01/05', ' 21:00', '2');

insert into Orders values('F1007', 'P0111', '2015/01/06', ' 13:00', '1');
insert into Orders values('F1007', 'P0124', '2015/01/06', ' 13:00', '2');
insert into Orders values('F1007', 'P0130', '2015/01/06', ' 13:00', '2');

insert into Orders values('F1007', 'P0041', '2015/01/06', ' 21:30', '2');
insert into Orders values('F1007', 'P0123', '2015/01/06', ' 21:30', '2');
insert into Orders values('F1007', 'P0141', '2015/01/06', ' 21:30', '1');
insert into Orders values('F1007', 'P0087', '2015/01/06', ' 21:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1008', 'P0004', '2015/01/04', ' 21:00', '2');
insert into Orders values('C1008', 'P0033', '2015/01/04', ' 21:00', '2');
insert into Orders values('C1008', 'P0019', '2015/01/04', ' 21:00', '2');
insert into Orders values('C1008', 'P0030', '2015/01/04', ' 21:00', '1');

insert into Orders values('C1008', 'P0057', '2015/01/05', ' 12:00', '2');
insert into Orders values('C1008', 'P0050', '2015/01/05', ' 12:00', '2');
insert into Orders values('C1008', 'P0102', '2015/01/05', ' 12:00', '2');
insert into Orders values('C1008', 'P0097', '2015/01/05', ' 12:00', '1');
insert into Orders values('C1008', 'P0074', '2015/01/05', ' 12:00', '2');


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1008', 'P0030', '2015/01/06', ' 21:00', '1');
insert into Orders values('F1008', 'P0037', '2015/01/06', ' 21:00', '2');
insert into Orders values('F1008', 'P0050', '2015/01/06', ' 21:00', '2');

insert into Orders values('F1008', 'P0062', '2015/01/07', ' 12:00', '2');
insert into Orders values('F1008', 'P0067', '2015/01/07', ' 12:00', '1');
insert into Orders values('F1008', 'P0074', '2015/01/07', ' 12:00', '2');

insert into Orders values('F1008', 'P0082', '2015/01/07', ' 21:00', '2');
insert into Orders values('F1008', 'P0093', '2015/01/07', ' 21:00', '2');
insert into Orders values('F1008', 'P0100', '2015/01/07', ' 21:00', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1009', 'P0106', '2015/01/07', ' 12:00', '1');
insert into Orders values('C1009', 'P0112', '2015/01/07', ' 12:00', '1');
insert into Orders values('C1009', 'P0125', '2015/01/07', ' 12:00', '2');

insert into Orders values('C1009', 'P0131', '2015/01/07', ' 21:00', '2');
insert into Orders values('C1009', 'P0121', '2015/01/07', ' 21:00', '2');
insert into Orders values('C1009', 'P0142', '2015/01/07', ' 21:00', '1');

insert into Orders values('C1009', 'P0005', '2015/01/08', ' 12:00', '2');
insert into Orders values('C1009', 'P0014', '2015/01/08', ' 12:00', '1');
insert into Orders values('C1009', 'P0020', '2015/01/08', ' 12:00', '2');

insert into Orders values('C1009', 'P0031', '2015/01/08', ' 21:00', '2');
insert into Orders values('C1009', 'P0038', '2015/01/08', ' 21:00', '2');
insert into Orders values('C1009', 'P0051', '2015/01/08', ' 21:00', '2');

insert into Orders values('C1009', 'P0063', '2015/01/09', ' 12:30', '2');
insert into Orders values('C1009', 'P0068', '2015/01/09', ' 12:30', '1');
insert into Orders values('C1009', 'P0075', '2015/01/09', ' 12:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1010', 'P0083', '2015/01/08', ' 12:00', '2');
insert into Orders values('C1010', 'P0094', '2015/01/08', ' 12:00', '2');
insert into Orders values('C1010', 'P0101', '2015/01/08', ' 12:00', '2');

insert into Orders values('C1010', 'P0107', '2015/01/08', ' 20:00', '2');
insert into Orders values('C1010', 'P0113', '2015/01/08', ' 20:00', '2');
insert into Orders values('C1010', 'P0126', '2015/01/08', ' 20:00', '2');

insert into Orders values('C1010', 'P0006', '2015/01/09', ' 13:30', '2');
insert into Orders values('C1010', 'P0016', '2015/01/09', ' 13:30', '1');
insert into Orders values('C1010', 'P0023', '2015/01/09', ' 13:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1009', 'P0077', '2015/01/08', ' 20:30', '2');
insert into Orders values('F1009', 'P0085', '2015/01/08', ' 20:30', '2');
insert into Orders values('F1009', 'P0096', '2015/01/08', ' 20:30', '1');
insert into Orders values('F1009', 'P0115', '2015/01/08', ' 20:30', '2');
insert into Orders values('F1009', 'P0007', '2015/01/08', ' 20:30', '2');
insert into Orders values('F1009', 'P0017', '2015/01/08', ' 20:30', '1');
insert into Orders values('F1009', 'P0023', '2015/01/08', ' 20:30', '2');


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1010', 'P0084', '2015/01/09', ' 09:00', '2');
insert into Orders values('F1010', 'P0021', '2015/01/09', ' 09:00', '1');
insert into Orders values('F1010', 'P0036', '2015/01/09', ' 09:00', '2');
insert into Orders values('F1010', 'P0024', '2015/01/09', ' 09:00', '2');
insert into Orders values('F1010', 'P0114', '2015/01/09', ' 09:00', '2');
insert into Orders values('F1010', 'P0118', '2015/01/09', ' 09:00', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------


insert into Orders values('F1011', 'P0034', '2015/01/09', ' 12:00', '2');
insert into Orders values('F1011', 'P0051', '2015/01/09', ' 12:00', '1');
insert into Orders values('F1011', 'P0066', '2015/01/09', ' 12:00', '2');

insert into Orders values('F1011', 'P0004', '2015/01/09', ' 20:00', '2');
insert into Orders values('F1011', 'P0014', '2015/01/09', ' 20:00', '2');
insert into Orders values('F1011', 'P0018', '2015/01/09', ' 20:00', '2');

insert into Orders values('F1011', 'P0011', '2015/01/10', ' 12:00', '2');
insert into Orders values('F1011', 'P0115', '2015/01/10', ' 12:00', '1');
insert into Orders values('F1011', 'P0100', '2015/01/10', ' 12:00', '2');

insert into Orders values('F1011', 'P0083', '2015/01/10', ' 20:00', '2');
insert into Orders values('F1011', 'P0075', '2015/01/10', ' 20:00', '2');
insert into Orders values('F1011', 'P0105', '2015/01/10', ' 20:00', '2');

insert into Orders values('F1011', 'P0003', '2015/01/11', ' 11:30', '2');
insert into Orders values('F1011', 'P0045', '2015/01/11', ' 11:30', '2');
insert into Orders values('F1011', 'P0137', '2015/01/11', ' 11:30', '2');



----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1012', 'P0131', '2015/01/09', ' 14:00', '2');
insert into Orders values('F1012', 'P0125', '2015/01/09', ' 14:00', '1');
insert into Orders values('F1012', 'P0142', '2015/01/09', ' 14:00', '2');

insert into Orders values('F1012', 'P0053', '2015/01/09', ' 20:00', '2');
insert into Orders values('F1012', 'P0025', '2015/01/09', ' 20:00', '2');
insert into Orders values('F1012', 'P0125', '2015/01/09', ' 20:00', '2');

insert into Orders values('F1012', 'P0096', '2015/01/10', ' 12:30', '2');
insert into Orders values('F1012', 'P0104', '2015/01/10', ' 12:30', '2');
insert into Orders values('F1012', 'P0110', '2015/01/10', ' 12:30', '2');

insert into Orders values('F1012', 'P0145', '2015/01/10', ' 20:30', '2');
insert into Orders values('F1012', 'P0033', '2015/01/10', ' 20:30', '2');
insert into Orders values('F1012', 'P0039', '2015/01/10', ' 20:30', '2');


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1011', 'P0008', '2015/01/10', ' 12:30', '2');
insert into Orders values('C1011', 'P0016', '2015/01/10', ' 12:30', '1');
insert into Orders values('C1011', 'P0026', '2015/01/10', ' 12:30', '2');
insert into Orders values('C1011', 'P0045', '2015/01/10', ' 12:30', '1');

insert into Orders values('C1011', 'P0067', '2015/01/10', ' 20:30', '2');
insert into Orders values('C1011', 'P0077', '2015/01/10', ' 20:30', '1');
insert into Orders values('C1011', 'P0083', '2015/01/10', ' 20:30', '2');

insert into Orders values('C1011', 'P0087', '2015/01/11', ' 12:30', '2');
insert into Orders values('C1011', 'P0096', '2015/01/11', ' 12:30', '2');
insert into Orders values('C1011', 'P0105', '2015/01/11', ' 12:30', '2');

insert into Orders values('C1011', 'P0010', '2015/01/11', ' 20:30', '1');
insert into Orders values('C1011', 'P0016', '2015/01/11', ' 20:30', '2');
insert into Orders values('C1011', 'P0027', '2015/01/11', ' 20:30', '2');
insert into Orders values('C1011', 'P0047', '2015/01/11', ' 20:30', '2');

insert into Orders values('C1011', 'P0059', '2015/01/12', ' 12:30', '1');
insert into Orders values('C1011', 'P0064', '2015/01/12', ' 12:30', '2');
insert into Orders values('C1011', 'P0071', '2015/01/12', ' 12:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1013', 'P0003', '2015/01/10', ' 13:30', '2');
insert into Orders values('F1013', 'P0014', '2015/01/10', ' 13:30', '14');
insert into Orders values('F1013', 'P0020', '2015/01/10', ' 13:30', '1');
insert into Orders values('F1013', 'P0032', '2015/01/10', ' 13:30', '1');
insert into Orders values('F1013', 'P0040', '2015/01/10', ' 13:30', '2');
insert into Orders values('F1013', 'P0054', '2015/01/10', ' 13:30', '2');


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1012', 'P0001', '2015/01/10', ' 15:30', '1');
insert into Orders values('C1012', 'P0103', '2015/01/10', ' 15:30', '2');
insert into Orders values('C1012', 'P0019', '2015/01/10', ' 15:30', '2');

insert into Orders values('C1012', 'P0031', '2015/01/10', ' 20:30', '2');
insert into Orders values('C1012', 'P0038', '2015/01/10', ' 20:30', '1');
insert into Orders values('C1012', 'P0051', '2015/01/10', ' 20:30', '2');

insert into Orders values('C1012', 'P0032', '2015/01/11', ' 12:30', '1');
insert into Orders values('C1012', 'P0076', '2015/01/11', ' 12:30', '2');
insert into Orders values('C1012', 'P0044', '2015/01/11', ' 12:30', '1');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1013', 'P0001', '2015/01/11', ' 12:30', '1');
insert into Orders values('C1013', 'P0013', '2015/01/11', ' 12:30', '2');
insert into Orders values('C1013', 'P0019', '2015/01/11', ' 12:30', '2');

insert into Orders values('C1013', 'P0031', '2015/01/11', ' 20:30', '2');
insert into Orders values('C1013', 'P0038', '2015/01/11', ' 20:30', '1');
insert into Orders values('C1013', 'P0051', '2015/01/11', ' 20:30', '2');

insert into Orders values('C1013', 'P0062', '2015/01/12', ' 12:30', '1');
insert into Orders values('C1013', 'P0076', '2015/01/12', ' 12:30', '2');
insert into Orders values('C1013', 'P0084', '2015/01/12', ' 12:30', '1');

insert into Orders values('C1013', 'P0095', '2015/01/12', ' 20:30', '2');
insert into Orders values('C1013', 'P0101', '2015/01/12', ' 20:30', '2');
insert into Orders values('C1013', 'P0112', '2015/01/12', ' 20:30', '2');

insert into Orders values('C1013', 'P0002', '2015/01/13', ' 12:00', '2');
insert into Orders values('C1013', 'P0014', '2015/01/13', ' 12:00', '2');
insert into Orders values('C1013', 'P0020', '2015/01/13', ' 12:00', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1014', 'P0063', '2015/01/11', ' 14:30', '1');
insert into Orders values('C1014', 'P0077', '2015/01/11', ' 14:30', '2');
insert into Orders values('C1014', 'P0085', '2015/01/11', ' 14:30', '2');

insert into Orders values('C1014', 'P0032', '2015/01/11', ' 20:30', '2');
insert into Orders values('C1014', 'P0039', '2015/01/11', ' 20:30', '1');
insert into Orders values('C1014', 'P0052', '2015/01/11', ' 20:30', '2');

insert into Orders values('C1014', 'P0096', '2015/01/12', ' 12:30', '2');
insert into Orders values('C1014', 'P0102', '2015/01/12', ' 12:30', '2');
insert into Orders values('C1014', 'P0113', '2015/01/12', ' 12:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1014', 'P0003', '2015/01/11', ' 15:00', '1');
insert into Orders values('F1014', 'P0015', '2015/01/11', ' 15:00', '2');
insert into Orders values('F1014', 'P0021', '2015/01/11', ' 15:00', '2');

insert into Orders values('F1014', 'P0033', '2015/01/11', ' 21:30', '2');
insert into Orders values('F1014', 'P0040', '2015/01/11', ' 21:30', '2');
insert into Orders values('F1014', 'P0053', '2015/01/11', ' 21:30', '2');

insert into Orders values('F1014', 'P0064', '2015/01/12', ' 12:30', '2');
insert into Orders values('F1014', 'P0078', '2015/01/12', ' 12:30', '2');
insert into Orders values('F1014', 'P0086', '2015/01/12', ' 12:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1015', 'P0044', '2015/01/11', ' 16:30', '1');
insert into Orders values('F1015', 'P0036', '2015/01/11', ' 16:30', '1');
insert into Orders values('F1015', 'P0022', '2015/01/11', ' 16:30', '2');
insert into Orders values('F1015', 'P0034', '2015/01/11', ' 16:30', '2');
insert into Orders values('F1015', 'P0041', '2015/01/11', ' 16:30', '2');
insert into Orders values('F1015', 'P0054', '2015/01/11', ' 16:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1016', 'P0004', '2015/01/12', ' 12:30', '1');
insert into Orders values('F1016', 'P0016', '2015/01/12', ' 12:30', '1');
insert into Orders values('F1016', 'P0022', '2015/01/12', ' 12:30', '2');

insert into Orders values('F1016', 'P0034', '2015/01/12', ' 21:30', '2');
insert into Orders values('F1016', 'P0041', '2015/01/12', ' 21:30', '2');
insert into Orders values('F1016', 'P0054', '2015/01/12', ' 21:30', '2');

insert into Orders values('F1016', 'P0065', '2015/01/13', ' 12:00', '1');
insert into Orders values('F1016', 'P0079', '2015/01/13', ' 12:00', '2');
insert into Orders values('F1016', 'P0087', '2015/01/13', ' 12:00', '2');

insert into Orders values('F1016', 'P0103', '2015/01/13', ' 20:30', '2');
insert into Orders values('F1016', 'P0116', '2015/01/13', ' 20:30', '2');
insert into Orders values('F1016', 'P0137', '2015/01/13', ' 20:30', '2');

insert into Orders values('F1016', 'P0009', '2015/01/14', ' 13:00', '2');
insert into Orders values('F1016', 'P0017', '2015/01/14', ' 13:00', '1');
insert into Orders values('F1016', 'P0018', '2015/01/14', ' 13:00', '8');

insert into Orders values('F1016', 'P0144', '2015/01/14', ' 21:30', '1');
insert into Orders values('F1016', 'P0042', '2015/01/14', ' 21:30', '2');
insert into Orders values('F1016', 'P0055', '2015/01/14', ' 21:30', '2');

insert into Orders values('F1016', 'P0063', '2015/01/15', ' 12:30', '2');
insert into Orders values('F1016', 'P0080', '2015/01/15', ' 12:30', '1');
insert into Orders values('F1016', 'P0098', '2015/01/15', ' 12:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1015', 'P0005', '2015/01/12', ' 13:00', '2');
insert into Orders values('C1015', 'P0017', '2015/01/12', ' 13:00', '1');
insert into Orders values('C1015', 'P0023', '2015/01/12', ' 13:00', '2');

insert into Orders values('C1015', 'P0035', '2015/01/12', ' 21:30', '1');
insert into Orders values('C1015', 'P0042', '2015/01/12', ' 21:30', '2');
insert into Orders values('C1015', 'P0055', '2015/01/12', ' 21:30', '2');

insert into Orders values('C1015', 'P0066', '2015/01/13', ' 13:30', '2');
insert into Orders values('C1015', 'P0080', '2015/01/13', ' 13:30', '1');
insert into Orders values('C1015', 'P0088', '2015/01/13', ' 13:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1016', 'P0029', '2015/01/12', '17:00', '2');
insert into Orders values('C1016', 'P0035', '2015/01/12', '17:00', '1');
insert into Orders values('C1016', 'P0048', '2015/01/12', '17:00', '1');
insert into Orders values('C1016', 'P0056', '2015/01/12', '17:00', '2');

insert into Orders values('C1016', 'P0001', '2015/01/12', '22:00', '2');
insert into Orders values('C1016', 'P0011', '2015/01/12', '22:00', '2');
insert into Orders values('C1016', 'P0018', '2015/01/12', '22:00', '7');

insert into Orders values('C1016', 'P0060', '2015/01/13', '12:00', '2');
insert into Orders values('C1016', 'P0065', '2015/01/13', '12:00', '1');
insert into Orders values('C1016', 'P0098', '2015/01/13', '12:00', '1');
insert into Orders values('C1016', 'P0105', '2015/01/13', '12:00', '2');
insert into Orders values('C1016', 'P0112', '2015/01/13', '12:00', '1');

insert into Orders values('C1016', 'P0072', '2015/01/13', '20:00', '2');
insert into Orders values('C1016', 'P0080', '2015/01/13', '20:00', '2');
insert into Orders values('C1016', 'P0091', '2015/01/13', '20:00', '1');

insert into Orders values('C1016', 'P0124', '2015/01/14', '12:00', '2');
insert into Orders values('C1016', 'P0131', '2015/01/14', '12:00', '2');
insert into Orders values('C1016', 'P0144', '2015/01/14', '12:00', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1017', 'P0073', '2015/01/13', '12:00', '2');
insert into Orders values('F1017', 'P0085', '2015/01/13', '12:00', '2');
insert into Orders values('F1017', 'P0018', '2015/01/13', '12:00', '8');

insert into Orders values('F1017', 'P0033', '2015/01/13', '21:00', '2');
insert into Orders values('F1017', 'P0101', '2015/01/13', '21:00', '1');
insert into Orders values('F1017', 'P0122', '2015/01/13', '21:00', '2');

insert into Orders values('F1017', 'P0138', '2015/01/14', '13:00', '2');
insert into Orders values('F1017', 'P0082', '2015/01/14', '13:00', '1');
insert into Orders values('F1017', 'P0088', '2015/01/14', '13:00', '8');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------


insert into Orders values('C1017', 'P0063', '2015/01/13', '12:30', '2');
insert into Orders values('C1017', 'P0075', '2015/01/13', '12:30', '2');
insert into Orders values('C1017', 'P0028', '2015/01/13', '12:30', '8');

insert into Orders values('C1017', 'P0043', '2015/01/13', '21:00', '2');
insert into Orders values('C1017', 'P0121', '2015/01/13', '21:00', '1');
insert into Orders values('C1017', 'P0142', '2015/01/13', '21:00', '2');

insert into Orders values('C1017', 'P0106', '2015/01/14', '12:00', '2');
insert into Orders values('C1017', 'P0052', '2015/01/14', '12:00', '1');
insert into Orders values('C1017', 'P0008', '2015/01/14', '12:00', '8');

insert into Orders values('C1017', 'P0011', '2015/01/14', '20:00', '1');
insert into Orders values('C1017', 'P0017', '2015/01/14', '20:00', '2');

insert into Orders values('C1017', 'P0058', '2015/01/15', '12:30', '2');
insert into Orders values('C1017', 'P0034', '2015/01/15', '12:30', '2');
insert into Orders values('C1017', 'P0047', '2015/01/15', '12:30', '2');


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1018', 'P0072', '2015/01/13', ' 13:30', '1');
insert into Orders values('F1018', 'P0079', '2015/01/13', ' 13:30', '2');
insert into Orders values('F1018', 'P0090', '2015/01/13', ' 13:30', '2');
insert into Orders values('F1018', 'P0091', '2015/01/13', ' 13:00', '2');
insert into Orders values('F1018', 'P0104', '2015/01/13', ' 13:00', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1019', 'P0088', '2015/01/14', ' 12:00', '2');
insert into Orders values('F1019', 'P0049', '2015/01/14', ' 12:00', '3');
insert into Orders values('F1019', 'P0063', '2015/01/14', ' 12:00', '1');

insert into Orders values('F1019', 'P0077', '2015/01/14', ' 20:00', '1');
insert into Orders values('F1019', 'P0073', '2015/01/14', ' 20:00', '1');
insert into Orders values('F1019', 'P0124', '2015/01/14', ' 20:00', '2');

insert into Orders values('F1019', 'P0102', '2015/01/15', ' 12:30', '1');
insert into Orders values('F1019', 'P0099', '2015/01/15', ' 12:30', '2');
insert into Orders values('C1018', 'P0038', '2015/01/15', ' 12:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1018', 'P0038', '2015/01/14', ' 13:00', '2');
insert into Orders values('C1018', 'P0049', '2015/01/14', ' 13:00', '3');
insert into Orders values('C1018', 'P0063', '2015/01/14', ' 13:00', '1');

insert into Orders values('C1018', 'P0077', '2015/01/14', ' 20:00', '1');
insert into Orders values('C1018', 'P0093', '2015/01/14', ' 20:00', '1');
insert into Orders values('C1018', 'P0124', '2015/01/14', ' 20:00', '2');

insert into Orders values('C1018', 'P0002', '2015/01/15', ' 12:00', '1');
insert into Orders values('C1018', 'P0009', '2015/01/15', ' 12:00', '2');
insert into Orders values('C1018', 'P0017', '2015/01/15', ' 12:00', '2');

insert into Orders values('C1019', 'P0003', '2015/01/15', ' 20:30', '2');
insert into Orders values('C1019', 'P0071', '2015/01/15', ' 20:30', '3');
insert into Orders values('C1019', 'P0063', '2015/01/15', ' 20:30', '2');

insert into Orders values('C1019', 'P0041', '2015/01/16', ' 11:30', '1');
insert into Orders values('C1019', 'P0043', '2015/01/16', ' 11:30', '1');
insert into Orders values('C1019', 'P0094', '2015/01/16', ' 11:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1019', 'P0003', '2015/01/15', ' 12:00', '2');
insert into Orders values('C1019', 'P0011', '2015/01/15', ' 12:00', '3');
insert into Orders values('C1019', 'P0023', '2015/01/15', ' 12:00', '2');

insert into Orders values('C1019', 'P0031', '2015/01/15', ' 20:00', '1');
insert into Orders values('C1019', 'P0043', '2015/01/15', ' 20:00', '1');
insert into Orders values('C1019', 'P0054', '2015/01/15', ' 20:00', '2');

insert into Orders values('C1019', 'P0006', '2015/01/16', ' 12:00', '1');
insert into Orders values('C1019', 'P0014', '2015/01/16', ' 12:00', '2');
insert into Orders values('C1019', 'P0025', '2015/01/16', ' 12:00', '4');

insert into Orders values('C1019', 'P0032', '2015/01/16', ' 20:00', '1');
insert into Orders values('C1019', 'P0041', '2015/01/16', ' 20:00', '2');
insert into Orders values('C1019', 'P0059', '2015/01/16', ' 20:00', '1');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1020', 'P0067', '2015/01/15', ' 14:00', '2');
insert into Orders values('C1020', 'P0078', '2015/01/15', ' 14:00', '3');
insert into Orders values('C1020', 'P0089', '2015/01/15', ' 14:00', '2');

insert into Orders values('C1020', 'P0099', '2015/01/15', ' 20:00', '2');
insert into Orders values('C1020', 'P0104', '2015/01/15', ' 20:00', '2');
insert into Orders values('C1020', 'P0111', '2015/01/15', ' 20:00', '2');

insert into Orders values('C1020', 'P0016', '2015/01/16', ' 12:00', '3');
insert into Orders values('C1020', 'P0019', '2015/01/16', ' 12:00', '1');
insert into Orders values('C1020', 'P0046', '2015/01/16', ' 12:00', '1');

insert into Orders values('C1020', 'P0044', '2015/01/16', ' 20:00', '2');
insert into Orders values('C1020', 'P0062', '2015/01/16', ' 20:00', '1');
insert into Orders values('C1020', 'P0098', '2015/01/16', ' 20:00', '2');


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1020', 'P0001', '2015/01/15', ' 15:30', '1');
insert into Orders values('F1020', 'P0011', '2015/01/15', ' 15:30', '2');
insert into Orders values('F1020', 'P0018', '2015/01/15', ' 15:30', '2');
insert into Orders values('F1020', 'P0029', '2015/01/15', ' 15:30', '1');
insert into Orders values('F1020', 'P0005', '2015/01/15', ' 15:30', '2');
insert into Orders values('F1020', 'P0066', '2015/01/15', ' 15:30', '2');
insert into Orders values('F1020', 'P0017', '2015/01/15', ' 15:30', '1');
insert into Orders values('F1020', 'P0065', '2015/01/15', ' 15:30', '2');
insert into Orders values('F1020', 'P0087', '2015/01/15', ' 15:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------Only Eat Food---------------------------------------------------------------------------------------------

insert into Orders values('F1021', 'P0001', '2015/01/15', ' 15:30', '1');
insert into Orders values('F1021', 'P0011', '2015/01/15', ' 15:30', '2');
insert into Orders values('F1021', 'P0018', '2015/01/15', ' 15:30', '2');
insert into Orders values('F1021', 'P0029', '2015/01/15', ' 15:30', '1');


insert into Orders values('F1021', 'P0021', '2015/01/15', ' 21:30', '1');
insert into Orders values('F1021', 'P0051', '2015/01/15', ' 21:30', '2');
insert into Orders values('F1021', 'P0038', '2015/01/15', ' 21:30', '2');
insert into Orders values('F1021', 'P0109', '2015/01/15', ' 21:30', '1');


insert into Orders values('F1021', 'P0031', '2015/01/16', ' 11:30', '1');
insert into Orders values('F1021', 'P0058', '2015/01/16', ' 11:30', '2');
insert into Orders values('F1021', 'P0078', '2015/01/16', ' 11:30', '2');
insert into Orders values('F1021', 'P0099', '2015/01/16', ' 11:30', '1');



----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1022', 'P0005', '2015/01/15', ' 15:00', '2');
insert into Orders values('F1022', 'P0017', '2015/01/15', ' 15:00', '1');
insert into Orders values('F1022', 'P0065', '2015/01/15', ' 15:00', '2');
insert into Orders values('F1022', 'P0087', '2015/01/15', ' 15:00', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1023', 'P0003', '2015/01/15', ' 15:30', '1');
insert into Orders values('F1023', 'P0055', '2015/01/15', ' 15:30', '2');
insert into Orders values('F1023', 'P0088', '2015/01/15', ' 15:30', '1');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1024', 'P0096', '2015/01/16', ' 12:30', '1');
insert into Orders values('F1024', 'P0105', '2015/01/16', ' 12:30', '3');
insert into Orders values('F1024', 'P0117', '2015/01/16', ' 12:30', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('F1025', 'P0139', '2015/01/16', ' 15:30', '1');
insert into Orders values('F1025', 'P0145', '2015/01/16', ' 15:30', '2');
insert into Orders values('F1025', 'P0087', '2015/01/16', ' 15:30', '1');
insert into Orders values('F1025', 'P0066', '2015/01/16', ' 15:30', '2');

insert into Orders values('F1025', 'P0002', '2015/01/16', ' 21:50', '1');
insert into Orders values('F1025', 'P0012', '2015/01/16', ' 21:50', '2');
insert into Orders values('F1025', 'P0019', '2015/01/16', ' 21:50', '2');
insert into Orders values('F1025', 'P0030', '2015/01/16', ' 21:50', '1');

insert into Orders values('F1025', 'P0006', '2015/01/17', ' 12:10', '2');
insert into Orders values('F1025', 'P0018', '2015/01/17', ' 12:10', '1');
insert into Orders values('F1025', 'P0066', '2015/01/17', ' 12:10', '2');
insert into Orders values('F1025', 'P0088', '2015/01/17', ' 12:10', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------


------------------------Company Extra----------------------------------------------------------------------------------------------------------

insert into Orders values('C1021', 'P0002', '2015/01/15', ' 14:50', '1');
insert into Orders values('C1021', 'P0012', '2015/01/15', ' 14:50', '2');
insert into Orders values('C1021', 'P0019', '2015/01/15', ' 14:50', '2');
insert into Orders values('C1021', 'P0030', '2015/01/15', ' 14:50', '1');

insert into Orders values('C1021', 'P0012', '2015/01/15', ' 20:50', '1');
insert into Orders values('C1021', 'P0032', '2015/01/15', ' 20:50', '2');
insert into Orders values('C1021', 'P0079', '2015/01/15', ' 20:50', '2');
insert into Orders values('C1021', 'P0060', '2015/01/15', ' 20:50', '1');

insert into Orders values('C1021', 'P0022', '2015/01/16', ' 12:50', '1');
insert into Orders values('C1021', 'P0042', '2015/01/16', ' 12:50', '2');
insert into Orders values('C1021', 'P0089', '2015/01/16', ' 12:50', '2');
insert into Orders values('C1021', 'P0040', '2015/01/16', ' 12:50', '1');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1022', 'P0006', '2015/01/15', ' 15:10', '2');
insert into Orders values('C1022', 'P0018', '2015/01/15', ' 15:10', '1');
insert into Orders values('C1022', 'P0066', '2015/01/15', ' 15:10', '2');

insert into Orders values('C1022', 'P0016', '2015/01/15', ' 21:10', '2');
insert into Orders values('C1022', 'P0028', '2015/01/15', ' 21:10', '2');
insert into Orders values('C1022', 'P0088', '2015/01/15', ' 21:10', '2');

insert into Orders values('C1022', 'P0026', '2015/01/16', ' 12:10', '3');
insert into Orders values('C1022', 'P0038', '2015/01/16', ' 12:10', '2');
insert into Orders values('C1022', 'P0079', '2015/01/16', ' 12:10', '2');

insert into Orders values('C1022', 'P0036', '2015/01/16', ' 21:10', '2');
insert into Orders values('C1022', 'P0048', '2015/01/16', ' 21:10', '1');
insert into Orders values('C1022', 'P0069', '2015/01/16', ' 21:10', '2');

insert into Orders values('C1022', 'P0046', '2015/01/17', ' 13:10', '2');
insert into Orders values('C1022', 'P0088', '2015/01/17', ' 13:10', '4');
insert into Orders values('C1022', 'P0108', '2015/01/17', ' 13:10', '2');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1023', 'P0013', '2015/01/15', ' 12:00', '1');
insert into Orders values('C1023', 'P0025', '2015/01/15', ' 12:00', '2');
insert into Orders values('C1023', 'P0068', '2015/01/15', ' 12:00', '1');

insert into Orders values('C1023', 'P0023', '2015/01/15', ' 21:00', '1');
insert into Orders values('C1023', 'P0035', '2015/01/15', ' 21:00', '2');
insert into Orders values('C1023', 'P0078', '2015/01/15', ' 21:00', '1');

insert into Orders values('C1023', 'P0033', '2015/01/16', ' 13:00', '1');
insert into Orders values('C1023', 'P0045', '2015/01/16', ' 13:00', '2');
insert into Orders values('C1023', 'P0088', '2015/01/16', ' 13:00', '1');

insert into Orders values('C1023', 'P0043', '2015/01/16', ' 20:00', '1');
insert into Orders values('C1023', 'P0055', '2015/01/16', ' 20:00', '2');
insert into Orders values('C1023', 'P0098', '2015/01/16', ' 20:00', '1');

insert into Orders values('C1023', 'P0053', '2015/01/17', ' 12:30', '1');
insert into Orders values('C1023', 'P0065', '2015/01/17', ' 12:30', '2');
insert into Orders values('C1023', 'P0108', '2015/01/17', ' 12:30', '1');

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1024', 'P0097', '2015/01/15', ' 13:30', '1');
insert into Orders values('C1024', 'P0105', '2015/01/15', ' 13:30', '1');
insert into Orders values('C1024', 'P0118', '2015/01/15', ' 13:30', '1');

insert into Orders values('C1024', 'P0017', '2015/01/15', ' 21:30', '1');
insert into Orders values('C1024', 'P0115', '2015/01/15', ' 21:30', '1');
insert into Orders values('C1024', 'P0128', '2015/01/15', ' 21:30', '1');

insert into Orders values('C1024', 'P0047', '2015/01/16', ' 12:30', '1');
insert into Orders values('C1024', 'P0125', '2015/01/16', ' 12:30', '1');
insert into Orders values('C1024', 'P0142', '2015/01/16', ' 12:30', '1');


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

insert into Orders values('C1025', 'P0143', '2015/01/15', ' 15:30', '1');
insert into Orders values('C1025', 'P0014', '2015/01/15', ' 15:30', '2');
insert into Orders values('C1025', 'P0087', '2015/01/15', ' 15:30', '1');
insert into Orders values('C1025', 'P0062', '2015/01/15', ' 15:30', '2');

insert into Orders values('C1025', 'P0119', '2015/01/15', ' 21:30', '1');
insert into Orders values('C1025', 'P0114', '2015/01/15', ' 21:30', '2');
insert into Orders values('C1025', 'P0037', '2015/01/15', ' 21:30', '1');

insert into Orders values('C1025', 'P0022', '2015/01/16', ' 11:30', '2');
insert into Orders values('C1025', 'P0144', '2015/01/16', ' 11:30', '1');
insert into Orders values('C1025', 'P0054', '2015/01/16', ' 11:30', '2');

insert into Orders values('C1025', 'P0047', '2015/01/16', ' 21:30', '5');
insert into Orders values('C1025', 'P0072', '2015/01/16', ' 21:30', '2');
insert into Orders values('C1025', 'P0141', '2015/01/16', ' 21:30', '1');

insert into Orders values('C1025', 'P0064', '2015/01/17', ' 12:30', '2');
insert into Orders values('C1025', 'P0057', '2015/01/17', ' 12:30', '4');
insert into Orders values('C1025', 'P0042', '2015/01/17', ' 12:30', '2');


----------------------------------------------------------------------------------------------------------------------------------------------------------------------