/*
 System Name    :  TEST                                        
 Entity Name    :  성적표                                   
 Table  Name    :  T_GREPORT                                  
 작성자         :  노정환                     
 작성일         :  2003.12.24                             
 내용           :  그룹함수를 테스트 하기 위한 임시 테이블
 비고        :  하두 오래되서 요즘 고등학교에 과목이 무엇이 있는지 가물 가물 해서 고생했음..
*/


CREATE TABLE T_GREPORT
(
GRADE_VC NUMBER(5) NOT NULL, 
NAME_VC VARCHAR2(20) NOT NULL,
SUBJECT_VC VARCHAR2(20) NOT NULL,
POINT_NU NUMBER NOT NULL  
)
/

INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'이순신','수학',85);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'이순신','영어',70);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'이순신','국어',66);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'이순신','물리',78);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'이순신','화학',95);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'무용해','수학',46);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'무용해','영어',88);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'무용해','국어',94);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'무용해','물리',58);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'무용해','화학',87);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'마동탁','수학',68);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'마동탁','영어',59);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'마동탁','국어',87);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'마동탁','물리',95);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'마동탁','화학',94);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'임걱정','수학',46);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'임걱정','영어',88);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'임걱정','국어',94);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'임걱정','물리',58);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'임걱정','화학',87);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'홍길동','수학',68);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'홍길동','영어',59);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'홍길동','국어',87);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'홍길동','물리',95);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (1 ,'홍길동','화학',94);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'이순신','수학',66);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'이순신','영어',89);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'이순신','국어',47);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'이순신','물리',88);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'이순신','화학',85);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'무용해','수학',45);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'무용해','영어',58);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'무용해','국어',36);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'무용해','물리',46);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'무용해','화학',36);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'마동탁','수학',85);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'마동탁','영어',78);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'마동탁','국어',57);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'마동탁','물리',68);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'마동탁','화학',96);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'임걱정','수학',55);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'임걱정','영어',78);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'임걱정','국어',89);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'임걱정','물리',90);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'임걱정','화학',95);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'홍길동','수학',45);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'홍길동','영어',55);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'홍길동','국어',95);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'홍길동','물리',94);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (2 ,'홍길동','화학',88);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'이순신','수학',56);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'이순신','영어',77);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'이순신','국어',45);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'이순신','물리',87);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'이순신','화학',66);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'무용해','수학',95);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'무용해','영어',97);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'무용해','국어',95);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'무용해','물리',87);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'무용해','화학',97);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'마동탁','수학',67);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'마동탁','영어',84);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'마동탁','국어',66);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'마동탁','물리',54);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'마동탁','화학',48);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'임걱정','수학',75);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'임걱정','영어',80);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'임걱정','국어',70);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'임걱정','물리',78);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'임걱정','화학',85);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'홍길동','수학',75);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'홍길동','영어',68);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'홍길동','국어',79);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'홍길동','물리',86);
INSERT INTO T_GREPORT ( GRADE_VC , NAME_VC , SUBJECT_VC , POINT_NU) VALUES (3 ,'홍길동','화학',70);

COMMIT;