DROP FUNCTION INITEMPLOYEETABLE();
CREATE OR REPLACE FUNCTION INITEMPLOYEETABLE() RETURNS void AS '
DECLARE
BEGIN
	DELETE FROM EMPLOYEE;
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 1 , ''山田'' , ''太郎'' , 49 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 2 , ''山田'' , ''花子'' , 48 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 3 , ''佐藤'' , ''順平'' , 21 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 4 , ''田中'' , ''太郎'' , 56 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 5 , ''大野'' , ''浩'' , 25 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 6 , ''池田'' , ''哲也'' , 53 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 7 , ''鈴木'' , ''次郎'' , 25 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 8 , ''鈴江'' , ''誠'' , 32 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 9 , ''日野'' , ''京子'' , 51 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 10 , ''山田'' , ''太郎'' , 44 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 11 , ''山田'' , ''花子'' , 49 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 12 , ''佐藤'' , ''順平'' , 29 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 13 , ''田中'' , ''太郎'' , 22 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 14 , ''大野'' , ''浩'' , 20 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 15 , ''池田'' , ''哲也'' , 17 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 16 , ''鈴木'' , ''次郎'' , 42 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 17 , ''鈴江'' , ''誠'' , 52 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 18 , ''日野'' , ''京子'' , 45 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 19 , ''山田'' , ''太郎'' , 27 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 20 , ''山田'' , ''花子'' , 43 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 21 , ''佐藤'' , ''順平'' , 54 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 22 , ''田中'' , ''太郎'' , 49 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 23 , ''大野'' , ''浩'' , 32 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 24 , ''池田'' , ''哲也'' , 56 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 25 , ''鈴木'' , ''次郎'' , 42 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 26 , ''鈴江'' , ''誠'' , 30 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 27 , ''日野'' , ''京子'' , 23 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 28 , ''山田'' , ''太郎'' , 56 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 29 , ''山田'' , ''花子'' , 31 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 30 , ''佐藤'' , ''順平'' , 33 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 31 , ''田中'' , ''太郎'' , 37 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 32 , ''大野'' , ''浩'' , 56 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 33 , ''池田'' , ''哲也'' , 52 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 34 , ''鈴木'' , ''次郎'' , 29 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 35 , ''鈴江'' , ''誠'' , 43 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 36 , ''日野'' , ''京子'' , 33 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 37 , ''山田'' , ''太郎'' , 53 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 38 , ''山田'' , ''花子'' , 34 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 39 , ''佐藤'' , ''順平'' , 56 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 40 , ''田中'' , ''太郎'' , 24 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 41 , ''大野'' , ''浩'' , 33 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 42 , ''池田'' , ''哲也'' , 45 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 43 , ''鈴木'' , ''次郎'' , 26 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 44 , ''鈴江'' , ''誠'' , 47 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 45 , ''日野'' , ''京子'' , 19 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 46 , ''山田'' , ''太郎'' , 40 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 47 , ''山田'' , ''花子'' , 28 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 48 , ''佐藤'' , ''順平'' , 23 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 49 , ''田中'' , ''太郎'' , 39 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 50 , ''大野'' , ''浩'' , 53 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 51 , ''池田'' , ''哲也'' , 25 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 52 , ''鈴木'' , ''次郎'' , 31 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 53 , ''鈴江'' , ''誠'' , 24 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 54 , ''日野'' , ''京子'' , 20 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 55 , ''山田'' , ''太郎'' , 42 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 56 , ''山田'' , ''花子'' , 36 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 57 , ''佐藤'' , ''順平'' , 26 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 58 , ''田中'' , ''太郎'' , 17 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 59 , ''大野'' , ''浩'' , 49 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 60 , ''池田'' , ''哲也'' , 40 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 61 , ''鈴木'' , ''次郎'' , 35 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 62 , ''鈴江'' , ''誠'' , 27 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 63 , ''日野'' , ''京子'' , 42 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 64 , ''山田'' , ''太郎'' , 23 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 65 , ''山田'' , ''花子'' , 16 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 66 , ''佐藤'' , ''順平'' , 22 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 67 , ''田中'' , ''太郎'' , 35 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 68 , ''大野'' , ''浩'' , 43 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 69 , ''池田'' , ''哲也'' , 33 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 70 , ''鈴木'' , ''次郎'' , 17 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 71 , ''鈴江'' , ''誠'' , 33 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 72 , ''日野'' , ''京子'' , 39 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 73 , ''山田'' , ''太郎'' , 16 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 74 , ''山田'' , ''花子'' , 51 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 75 , ''佐藤'' , ''順平'' , 55 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 76 , ''田中'' , ''太郎'' , 53 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 77 , ''大野'' , ''浩'' , 55 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 78 , ''池田'' , ''哲也'' , 21 );
	INSERT INTO EMPLOYEE (employee_id, employee_family_name, employee_first_name, employee_age) values ( 79 , ''鈴木'' , ''次郎'' , 18 );
END;
'
LANGUAGE 'plpgsql' ;
COMMIT;