Here is the link to my complete ddl escapades:
http://sqlfiddle.com/#!9/d7319
In case the link doesn't work, here's a screenshot of my insert statements:
https://gyazo.com/73059e84ce10cf6bfd26b9ee851fb196
And the ddl I used for the INSERT INTO requirement (just a segment of my full ddl):
INSERT INTO Orders (OrderNumber, ShipByDate, TimePrinted, ItemsOrdered, TotalCost)
VALUES ('123456789', '2016-05-01 21:00:00','2016-04-29 09:45:01','QWER1234, TYUI4321, TREW4987','42.97');
INSERT INTO Orders (OrderNumber, ShipByDate, TimePrinted, ItemsOrdered, TotalCost)
VALUES ('798465123', '2016-05-05 21:00:00','2016-05-04 11:01:22','QWER1234','10.11');
INSERT INTO Products (ItemNumber, ItemDescription, ItemLocation, NumberInStock, CaseQuantity)
VALUES ('QWER1234', 'A standard thingy.','04-12-66-01','12','4');
INSERT INTO Products (ItemNumber, ItemDescription, ItemLocation, NumberInStock, CaseQuantity)
VALUES ('TYUI4321', 'A common thingy.','02-34-10-08','5','2');
INSERT INTO Products (ItemNumber, ItemDescription, ItemLocation, NumberInStock, CaseQuantity)
VALUES ('TREW4987', 'An uncommon thingy.','03-04-22-02','4','5');
INSERT INTO Customers (CustomerID, FirstName, LastName, PhoneNumber, Address)VALUES ('CuSto1234', 'Custard','Stove','123-456-7890','1234 W StreetName, CityName, State 12345');
INSERT INTO Customers (CustomerID, FirstName, LastName, PhoneNumber, Address)VALUES ('OrDer4321', 'Ornate','Derivative','111-222-3334','4321 E StreetName, CityName, State 12346');
http://sqlfiddle.com/#!9/d7319
In case the link doesn't work, here's a screenshot of my insert statements:
https://gyazo.com/73059e84ce10cf6bfd26b9ee851fb196
And the ddl I used for the INSERT INTO requirement (just a segment of my full ddl):
INSERT INTO Orders (OrderNumber, ShipByDate, TimePrinted, ItemsOrdered, TotalCost)
VALUES ('123456789', '2016-05-01 21:00:00','2016-04-29 09:45:01','QWER1234, TYUI4321, TREW4987','42.97');
INSERT INTO Orders (OrderNumber, ShipByDate, TimePrinted, ItemsOrdered, TotalCost)
VALUES ('798465123', '2016-05-05 21:00:00','2016-05-04 11:01:22','QWER1234','10.11');
INSERT INTO Products (ItemNumber, ItemDescription, ItemLocation, NumberInStock, CaseQuantity)
VALUES ('QWER1234', 'A standard thingy.','04-12-66-01','12','4');
INSERT INTO Products (ItemNumber, ItemDescription, ItemLocation, NumberInStock, CaseQuantity)
VALUES ('TYUI4321', 'A common thingy.','02-34-10-08','5','2');
INSERT INTO Products (ItemNumber, ItemDescription, ItemLocation, NumberInStock, CaseQuantity)
VALUES ('TREW4987', 'An uncommon thingy.','03-04-22-02','4','5');
INSERT INTO Customers (CustomerID, FirstName, LastName, PhoneNumber, Address)VALUES ('CuSto1234', 'Custard','Stove','123-456-7890','1234 W StreetName, CityName, State 12345');
INSERT INTO Customers (CustomerID, FirstName, LastName, PhoneNumber, Address)VALUES ('OrDer4321', 'Ornate','Derivative','111-222-3334','4321 E StreetName, CityName, State 12346');