CREATE TABLE teachers
(teacher_id INT AUTO_INCREMENT PRIMARY KEY,
formal_title VARCHAR(25),
name_first VARCHAR(100),
name_last VARCHAR(100),
email_address VARCHAR(255));

INSERT INTO teachers
(formal_title, name_first, name_last, email_address)
VALUES
('Mr.', 'Russell', 'Dyer', 'russell@mylocal.test'),
('Mr.', 'Richard', 'Stringer', 'richard@mylocal.test'),
('Ms.', 'Rusty', 'Osborne', 'rusty@mylocal.test'),
('Ms.', 'Lexi', 'Hollar', 'alexandra@mylocal.test');