LISTING 1: Script to Create and Populate the Sales Table CREATE TABLE Sales ( smonth CHAR(6) NOT NULL PRIMARY KEY, qty INT NOT NULL) SET NOCOUNT ON INSERT INTO Sales VALUES('199912', 100) INSERT INTO Sales VALUES('200001', 110) INSERT INTO Sales VALUES('200002', 120) INSERT INTO Sales VALUES('200003', 130) INSERT INTO Sales VALUES('200004', 140) INSERT INTO Sales VALUES('200005', 140) INSERT INTO Sales VALUES('200006', 130) INSERT INTO Sales VALUES('200007', 120) INSERT INTO Sales VALUES('200008', 110) INSERT INTO Sales VALUES('200009', 100) INSERT INTO Sales VALUES('200010', 110) INSERT INTO Sales VALUES('200011', 100) INSERT INTO Sales VALUES('200012', 120) INSERT INTO Sales VALUES('200101', 130) INSERT INTO Sales VALUES('200102', 140) INSERT INTO Sales VALUES('200103', 100) INSERT INTO Sales VALUES('200104', 100) INSERT INTO Sales VALUES('200105', 100) INSERT INTO Sales VALUES('200106', 110) INSERT INTO Sales VALUES('200107', 120) INSERT INTO Sales VALUES('200108', 110) INSERT INTO Sales VALUES('200109', 120) INSERT INTO Sales VALUES('200110', 130) INSERT INTO Sales VALUES('200111', 140) INSERT INTO Sales VALUES('200112', 100)