DROP TABLE Editor; CREATE TABLE Editor ( id INT IDENTITY(1,1) PRIMARY KEY, FirstName VARCHAR(64), LastName VARCHAR(64), Email VARCHAR(64) ); INSERT INTO Editor (FirstName, LastName, Email) VALUES ('Jonathan', 'Erickson', 'jerickson@techweb.com'); INSERT INTO Editor (FirstName, LastName, Email) VALUES ('Deirdre', 'Blake', 'dblake@techweb.com'); INSERT INTO Editor (FirstName, LastName, Email) VALUES ('Al', 'Stevens', 'astevens@techweb.com'); INSERT INTO Editor (FirstName, LastName, Email) VALUES ('Scott', 'Ambler', 'swa@ambysoft.com'); INSERT INTO Editor (FirstName, LastName, Email) VALUES ('Bruce', 'Schneier', 'schneier@counterpane.com'); INSERT INTO Editor (FirstName, LastName, Email) VALUES ('Dennis', 'Shasha', 'shasha@cs.nyu.edu'); INSERT INTO Editor (FirstName, LastName, Email) VALUES ('Jack', 'Woehr', 'jax@well.com'); INSERT INTO Editor (FirstName, LastName, Email) VALUES ('Gregory', 'Wilson', 'gvwilson@ddj.com'); INSERT INTO Editor (FirstName, LastName, Email) VALUES ('Mark', 'Nelson', 'markn@ieee.org');