create table Orders (
OrderID int,
OrderDate date,
DeliveryMethod varchar(30),
DeliveryDate date,
Amount decimal(9,2),
CustomerID int,
FirstName varchar(30),
LastName varchar(30)
);

insert into Orders (OrderID, OrderDate, DeliveryMethod, DeliveryDate, Amount, CustomerID, FirstName, LastName)
values (1, '2019-12-01', 'CarrierA', '2019-12-10', 74.88, 1, 'John', 'Smith'), 
(2, '2019-12-01', 'CarrierA', '2019-12-10', 189.41, 1, 'John', 'Smith'),  
(3, '2019-12-01', 'Carrier123', '2019-12-11', 264.66, 2, 'Jane', 'Smith'),
(4, '2019-12-01', 'CarrierA', '2019-12-09', 998.11, 3, 'Bob', 'Jones'),
(5, '2019-12-01', 'CarrierUS', '2019-12-08', 27.11, 1, 'John', 'Smith'),
(6, '2019-12-01', 'CarrierA', '2019-12-08', 787.98, 3, 'Bob', 'Jones'),
(7, '2019-12-02', 'Carrier123', '2019-12-12', 417.65, 2,  'Jane', 'Smith'),
(8, '2019-12-02', 'CarrierA', '2019-12-12', 57.86, 2, 'Jane', 'Smith'),
(9, '2019-12-02', 'CarrierA', '2019-12-10', 881.45, 2, 'Jane', 'Smith'),
(10, '2019-12-03', 'Carrier123', '2019-12-13', 653.59, 3, 'Bob', 'Jones'),
(11, '2019-12-04', 'Carrier123', '2019-12-12', 32.99, 1, 'John', 'Smith'),
(12, '2019-12-04', 'Carrier123', '2019-12-15', 48.77, 1, 'John', 'Smith'),
(13, '2019-12-06', 'CarrierUS', '2019-12-16', 668.51, 2, 'Jane', 'Smith'),
(14, '2019-12-08', 'CarrierUS', '2019-12-17', 19.99, 3, 'Bob', 'Jones'),
(15, '2019-12-10', 'CarrierA', '2019-12-19', 87.88, 2, 'Jane', 'Smith');