create table Customers (
 CustomerID int,
 FirstName varchar(30),
 LastName varchar(30)
);

insert into Customers (CustomerID, FirstName, LastName)
values (1, 'John', 'Smith'), (2, 'Jane', 'Smith'),  (3, 'Bob', 'Jones');

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

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