Create a simple test table

CREATE TABLE lib
(
name VARCHAR(32),
dept VARCHAR(32),
OUT NUMBER
);

Fill the table with some test values

INSERT INTO LIB VALUES('ben','history',3);
INSERT INTO LIB VALUES('amy','history',3);
INSERT INTO LIB VALUES('pete','physics',3);
INSERT INTO LIB VALUES('roger','physics',3);
INSERT INTO LIB VALUES('john','history',3);
INSERT INTO LIB VALUES('rich','finance',3);
INSERT INTO LIB VALUES('blue','finance',3);
INSERT INTO LIB VALUES('cheese','it',3);
INSERT INTO LIB VALUES('ray','it',3);
INSERT INTO LIB VALUES('blue','it',3);
INSERT INTO LIB VALUES('green','history',3);