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

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

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

insert into Orders (OrderID, OrderDate, DeliveryMethod, DeliveryDate,CustomerID)
values (1, '2019-12-01', 'CarrierA', '2019-12-10',1), 
(2, '2019-12-01', 'CarrierA', '2019-12-10',1),  
(3, '2019-12-01', 'Carrier123', '2019-12-11',2),
(4, '2019-12-01', 'CarrierA', '2019-12-09',3),
(5, '2019-12-01', 'CarrierUS', '2019-12-08',1),
(6, '2019-12-01', 'CarrierA', '2019-12-08',3),
(7, '2019-12-02', 'Carrier123', '2019-12-12',2),
(8, '2019-12-02', 'CarrierA', '2019-12-12',2),
(9, '2019-12-02', 'CarrierA', '2019-12-10',2),
(10, '2019-12-03', 'Carrier123', '2019-12-13',3),
(11, '2019-12-04', 'Carrier123', '2019-12-12',1),
(12, '2019-12-04', 'Carrier123', '2019-12-15',1),
(13, '2019-12-06', 'CarrierUS', '2019-12-16',2),
(14, '2019-12-08', 'CarrierUS', '2019-12-17',3),
(15, '2019-12-10', 'CarrierA', '2019-12-19',2);