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',4);
INSERT INTO LIB VALUES('pete','physics',5);
INSERT INTO LIB VALUES('roger','physics',3);
INSERT INTO LIB VALUES('john','history',7);
INSERT INTO LIB VALUES('rich','finance',3);
INSERT INTO LIB VALUES('blue','finance',8);
INSERT INTO LIB VALUES('cheese','it',2);
INSERT INTO LIB VALUES('ray','it',0);
INSERT INTO LIB VALUES('blue','it',1);
INSERT INTO LIB VALUES('green','history',3);