LISTING 1: Code That Creates and Populates Three Sample Tables

USE tempdb
GO

CREATE TABLE Customers
(
	CustomerID        CHAR (5)           NOT NULL PRIMARY KEY,
	CompanyName   VARCHAR (40) NOT NULL,
	ContactName      VARCHAR (30) NULL
)
GO

INSERT INTO Customers VALUES ('BONAP', 'Bon app''', 'Laurence Lebihan')
INSERT INTO Customers VALUES ('QUICK', 'QUICK-Stop', 'Horst Kloss')
INSERT INTO Customers VALUES ('QUEDE', 'Que Delícia', 'Bernardo Batista')
INSERT INTO Customers VALUES ('NORTS', 'North/South', 'Simon Crowther')

GO

CREATE TABLE Employees
(
	EmployeeID       INT                     NOT NULL PRIMARY KEY,
	LastName          VARCHAR (20)  NOT NULL,
	FirstName          VARCHAR (10)  NOT NULL,
	ReportsTo          INT                    NULL
)
GO

INSERT INTO Employees VALUES (1, 'Davolio', 'Nancy', 2)
INSERT INTO Employees VALUES (2, 'Fuller', 'Andrew', NULL)
INSERT INTO Employees VALUES (3, 'Leverling', 'Janet', 2)
INSERT INTO Employees VALUES (4, 'Peacock', 'Margaret', 5)

GO

CREATE TABLE Orders
(
	OrderID              INT               NOT NULL PRIMARY KEY,
	CustomerID       CHAR (5)      NULL,
	EmployeeID       INT               NULL,
	OrderDate          DATETIME   NULL,
	ShipVia              INT               NULL
)
GO

INSERT INTO Orders VALUES (10248, 'VINET', 5, '07/04/1996', 3)
INSERT INTO Orders VALUES (10249, 'TOMSP', 6, '07/05/1996', 1)
INSERT INTO Orders VALUES (10250, 'HANAR', 4, '07/08/1996', 2)
INSERT INTO Orders VALUES (10251, 'VICTE', 3, '07/08/1996', 1)
INSERT INTO Orders VALUES (10252, 'SUPRD', 4, '07/09/1996', 2)
INSERT INTO Orders VALUES (10253, 'HANAR', 3, '07/10/1996', 2)
INSERT INTO Orders VALUES (10254, 'CHOPS', 5, '07/11/1996', 2)
INSERT INTO Orders VALUES (10255, 'RICSU', 9, '07/12/1996', 3)
INSERT INTO Orders VALUES (10256, 'WELLI', 3, '07/15/1996', 2)
INSERT INTO Orders VALUES (10257, 'HILAA', 4, '07/16/1996', 3)
INSERT INTO Orders VALUES (10258, 'ERNSH', 1, '07/17/1996', 1)
INSERT INTO Orders VALUES (10259, 'CENTC', 4, '07/18/1996', 3)
INSERT INTO Orders VALUES (10260, 'OTTIK', 4, '07/19/1996', 1)
INSERT INTO Orders VALUES (10261, 'QUEDE', 4, '07/19/1996', 2)
INSERT INTO Orders VALUES (10262, 'RATTC', 8, '07/22/1996', 3)
INSERT INTO Orders VALUES (10263, 'ERNSH', 9, '07/23/1996', 3)
INSERT INTO Orders VALUES (10264, 'FOLKO', 6, '07/24/1996', 3)
INSERT INTO Orders VALUES (10265, 'BLONP', 2, '07/25/1996', 1)

GO