create table employees (id integer,
name varchar(50),
title varchar(100),
office varchar(20));
insert into employees values (1, 'Fred Smith', 'CEO', '1');
insert into employees values (2, 'John Doe', 'Vice President', '2 West');
insert into employees values (3, 'Jane Jones', 'CFO', '2 East');
insert into employees values (4, 'Sam Smiles', 'Intern', '99');
insert into employees values (5, 'Julie Morgan', 'Sales Associate', '5 West');
insert into employees values (6, 'Wilma Fonda', 'Executive Assistant', '23');
insert into employees values (7, 'Danielle Jamison', 'Director of Marketing', '3 East');
insert into employees values (8, 'Michele Cannon',
'Director of Customer Support', '5 East');
insert into employees values (9, 'Lance Hanniford', 'CIO', '3 West');
insert into employees values (10, 'Eliot Rinaggio', 'Sales Associate', '5 West');
|