use csc223;

INSERT INTO faculty VALUES
(NULL, "Arnold",    "Adelberg",
              "Myra Steele Professor of Mathematics",
              "adelbe@math.grin.edu",     4201,"Science 2405"),
(NULL, "Nathaniel", "Borenstein",
              "Noyce Visiting Professor",
              "borenste@cs.grinnell.edu", 3017, "Science 1131"),
(NULL, "Marc",      "Chamberland",
              "Assistant Professor of Mathematics",
              "chamberl@math.grin.edu",   4207, "Science 2410"),
(NULL, "Pamela",    "Ferguson",
              "Professor of Mathematics",
              "fergusoa@ac.grin.edu",     3017, "Science 1131"),
(NULL, "Eugene",    "Herman",
              "Samuel R. and Marie-Louise Rosenthal Professor of Natural Science and Mathematics", 
              "herman@math.grin.edu",     4202, "Science 2403"),
(NULL, "Chris",     "Hill",
              "Assistant Professor of Mathematics",
              "hillc@math.grin.edu",      4556, "Science 2401"),
(NULL, "Charles",   "Jepsen",
              "Professor of Mathematics",
              "jepsen@math.grin.edu",     4203, "Science 2407"),
(NULL, "Katherine", "McClelland",
              "Director of the Mathematics Laboratory and Lecturer",
              "mcclella@math.grin.edu",   3060, "Science 2012A"),
(NULL, "Karen",     "McRitchie",
              "Local Area Network Manager",
              "mcritchi@math.grin.ed",    4531, "Science 2148"),
(NULL, "Emily",     "Moore",
              "Associate Professor of Mathematics and Computer Science",
              "mooree@math.grin.edu",     4205, "Science 2416"),
(NULL, "Thomas",    "Moore",
              "Associate Professor of Mathematics",
              "mooret@ac.grin.edu",       4206, "Science 2414"),
(NULL, "Samuel",    "Rebelsky",
              "Assistant Professor of Computer Science",
              "rebelsky@math.grin.edu",   4410, "Science 2427"),
(NULL, "John",      "Stone",
              "Lecturer in Computer Science",
              "stone@math.grin.edu",      3181, "Science 2418"),
(NULL, "Henry",     "Walker",
              "Professor of Mathematics and Computer Science",
              "walker@cs.grinnell.edu",   4208, "Science 2420"),
(NULL, "Royce",     "Wolf",
              "Associate Professor of Mathematics",
              "wolf@math.grin.edu",       4209, "Science 2412");