Listing 2: Code to Populate the Employee Table

INSERT INTO Employee (FirstName, LastName, Salary, HireDate)
  VALUES ('William', 'McEvoy', 250000,'1990-01-01')
INSERT INTO Employee (FirstName, LastName, Salary, HireDate)
  VALUES ('Garret', 'Testerson', 100000, '1997-04-01')
INSERT INTO Employee (FirstName, LastName, Salary, HireDate)
  VALUES ('Raoule', 'Teteblanche', 95000, '2000-07-01')
INSERT INTO Employee (FirstName, LastName, Salary, HireDate)
  VALUES ('Garth', 'Vader', 80000, '2002-03-13')
INSERT INTO Employee (FirstName, LastName, Salary, HireDate)
  VALUES ('Bill', 'Diamond', 65000, '2005-12-15')
INSERT INTO Employee (FirstName, LastName, Salary, HireDate)
  VALUES ('Napolean', 'Lawrence', 23500, '2006-03-15')
-- ******* BEGIN CALLOUT A *******
INSERT INTO Employee (FirstName, LastName, Salary, HireDate)
  VALUES ('Michael', 'Smith', 45000, '2006-03-15')
INSERT INTO Employee (FirstName, LastName, Salary, HireDate)
  VALUES ('John', 'Smith', 66000, '2006-03-15')
-- ******* END CALLOUT A *******