http://sqlfiddle.com/#!9/d7319

I've chosen to use SQL Fiddle to dabble around with.

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 table creations:
https://gyazo.com/378ded091ad7eec1d919dc22b6876165

This is the ddl I used to create my tables (just a segment of the full ddl):
CREATE TABLE Orders
(   
OrderNumber int(9) NOT NULL,   
ShipByDate datetime,   
TimePrinted datetime,   
ItemsOrdered varchar(255),   
TotalCost decimal(10,2),   
PRIMARY KEY (OrderNumber)
) 
;  

CREATE TABLE Products
(
ItemNumber char(8) NOT NULL,   
ItemDescription varchar(125),   
ItemLocation char(11),   
NumberInStock int(10),   
CaseQuantity int(10),   
PRIMARY KEY (ItemNumber)
) 
;  

CREATE TABLE Customers 
(   
CustomerID varchar(9) NOT NULL,   
 FirstName varchar(10) NOT NULL,   
LastName varchar(10) NOT NULL,   
 PhoneNumber char(12),   
Address varchar(255) NOT NULL,   
PRIMARY KEY (CustomerID) 
) 
;