2017. 10. Term Project, 선출직 공무원 데이터 베이스 관리 시스템 개발

< 선출직 공무원 데이터 베이스 관리 시스템 사용 화면 >

 

 

< Report >

 

 

 

<SQL Code>

 

CREATE TABLE DB066_Party (
Party varchar(40),
Propensity varchar(40),
PRIMARY KEY (Party)
);

CREATE TABLE DB066_Constituency (
Constituency varchar(40),
Region varchar(40) NOT NULL,
PRIMARY KEY (Constituency)
);

CREATE TABLE DB066_Place_of_Birth (
Place_of_Birth varchar(40),
Region varchar(40) NOT NULL,
PRIMARY KEY (Place_of_birth)
);

CREATE TABLE DB066_Elected_Officer (
ID int(5),
Job varchar(40) NOT NULL,
PRIMARY KEY (ID)
);

CREATE TABLE DB066_Congressman (
ID int(5),
Party varchar(40) NOT NULL,
Name varchar(40) NOT NULL,
Gender varchar(40) NOT NULL,
Age int(2) NOT NULL,
Place_of_Birth varchar(40),
Highest_level_of_Education varchar(40),
Property float,
Constituency varchar(40) UNIQUE,
Method_of_Election varchar(40) NOT NULL,
Number_of_Elelction int(2) NOT NULL,
PRIMARY KEY (ID),
FOREIGN KEY (ID) REFERENCES DB066_Elected_Officer (ID) ON DELETE CASCADE,
FOREIGN KEY (Party) REFERENCES DB066_Party (Party),
FOREIGN KEY (Place_of_Birth) REFERENCES DB066_Place_of_Birth (Place_of_Birth),
FOREIGN KEY (Constituency) REFERENCES DB066_Constituency (Constituency)
);

CREATE TABLE DB066_Provincial_Governor (
ID int(5),
Party varchar(40) NOT NULL,
Name varchar(40) NOT NULL,
Gender varchar(40) NOT NULL,
Age int(2) NOT NULL,
Place_of_Birth varchar(40),
Highest_level_of_Education varchar(40),
Property float,
Constituency varchar(40) UNIQUE,
Number_of_Elelction int(2) NOT NULL,
Administrative_District varchar(40) NOT NULL,
PRIMARY KEY (ID),
FOREIGN KEY (ID) REFERENCES DB066_Elected_Officer (ID) ON DELETE CASCADE,
FOREIGN KEY (Party) REFERENCES DB066_Party (Party),
FOREIGN KEY (Place_of_Birth) REFERENCES DB066_Place_of_birth (Place_of_Birth),
FOREIGN KEY (Constituency) REFERENCES DB066_Constituency (Constituency)
);

CREATE TABLE DB066_University (
ID int(5),
University varchar(40),
PRIMARY KEY (ID, University),
FOREIGN KEY (ID) REFERENCES DB066_Elected_Officer (ID) ON UPDATE CASCADE ON DELETE CASCADE
);

CREATE TABLE DB066_Major (
ID int(5),
Major varchar (40),
PRIMARY KEY (ID, Major),
FOREIGN KEY (ID) REFERENCES DB066_Elected_Officer (ID) ON UPDATE CASCADE ON DELETE CASCADE
);

CREATE INDEX Elected_Officer_index ON DB066_Elected_Officer (ID);
CREATE INDEX Congressman_index ON DB066_Congressman (ID);
CREATE INDEX Provincial_Governor_index ON DB066_Provincial_Governor (ID);
CREATE INDEX Universial_index ON DB066_University (ID);
CREATE INDEX Major_index ON DB066_Major (ID);

INSERT INTO DB066_Party VALUES ('The Minjoo Party of Korea', 'Progressivism');
INSERT INTO DB066_Party VALUES ('Liberty Korea Party', 'Conservative');
INSERT INTO DB066_Party VALUES ('The Peoples Party', 'Centrism');
INSERT INTO DB066_Party VALUES ('Progressive Justice Party', 'Progressivism');
INSERT INTO DB066_Party VALUES ('Bareun Party', 'Conservative');
INSERT INTO DB066_Party VALUES ('New Peoples Political Party', 'Progressivism');
INSERT INTO DB066_Party VALUES ('Korean Patriots Party', 'Conservative');
INSERT INTO DB066_Party VALUES ('Independent', NUll);

INSERT INTO DB066_Constituency VALUES ('서울 강남구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 강남구 병', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 강남구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 강동구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 강동구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 강북구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 강북구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 강서구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 강서구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 강서구 병', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 관악구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 관악구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 광진구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 광진구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 구로구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 구로구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 금천구', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 노원구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 노원구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 도봉구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 도봉구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 동대문구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 동대문구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 동작구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 동작구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 마포구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 마포구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 서대문구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 서대문구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 서초구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 서초구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 성북구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 성북구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 송파구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 송파구 병', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 송파구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 양천구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 양천구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 영등포구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 영등포구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 용산구', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 은평구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 은평구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 종로구', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 종구성동구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 종구성동구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 중랑구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('서울 중랑구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 계양구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 계양구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 남구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 남구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 남동구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 남동구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 부평구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 부평구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 서구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 서구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 연수구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 연수구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('인천 중구동구강화군옹진군', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 고양시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 고양시 병', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 고양시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 고양시 정', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 광명시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 광명시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 광주시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 광주시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 구리시', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 군포시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 군포시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 김포시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 김포시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 남양주시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 남양주시 병', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 남양주시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 동두천시연천군', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 부천시소사구', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 부천시오정구', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 부천시원미구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 부천시원미구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 성남시분당구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 성남시분당구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 성남시수정구', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 성남시중원구', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 수원시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 수원시 무', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 수원시 병', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 수원시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 수원시 정', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 시흥시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 시흥시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 안산시단원구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 안산시단원구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 안산시상록구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 안산시상록구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 안성시', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 안양시동안구 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 안양시동안구 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 안양시만안구', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 양주시', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 여주시양평군', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 오산시', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 용인시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 용인시 병', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 용인시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 용인시 정', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 의왕시과천시', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 의정부시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 의정부시 을 ', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 이천시', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 파주시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 파주시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 평택시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 평택시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 포천시가평군', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 하남시', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 화성시 갑', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 화성시 병', '경기도');
INSERT INTO DB066_Constituency VALUES ('경기 화성시 을', '경기도');
INSERT INTO DB066_Constituency VALUES ('충북 증평군진천군음성군', '충청도');
INSERT INTO DB066_Constituency VALUES ('충북 제천시단양군 ', '충청도');
INSERT INTO DB066_Constituency VALUES ('충북 청주시흥덕구', '충청도');
INSERT INTO DB066_Constituency VALUES ('충북 보은군옥천군영동군괴산군', '충청도');
INSERT INTO DB066_Constituency VALUES ('충북 청주시청원구', '충청도');
INSERT INTO DB066_Constituency VALUES ('충북 청주시서원구', '충청도');
INSERT INTO DB066_Constituency VALUES ('충북 충주시', '충청도');
INSERT INTO DB066_Constituency VALUES ('충북 청주시상당구', '충청도');
INSERT INTO DB066_Constituency VALUES ('충남 아산시 을', '충청도');
INSERT INTO DB066_Constituency VALUES ('충남 논산시계룡시금산군', '충청도');
INSERT INTO DB066_Constituency VALUES ('충남 보령시서천군', '충청도');
INSERT INTO DB066_Constituency VALUES ('충남 천안시 을', '충청도');
INSERT INTO DB066_Constituency VALUES ('충남 천안시 갑', '충청도');
INSERT INTO DB066_Constituency VALUES ('충남 서산시태안군', '충청도');
INSERT INTO DB066_Constituency VALUES ('충남 천안시 병', '충청도');
INSERT INTO DB066_Constituency VALUES ('충남 당진시', '충청도');
INSERT INTO DB066_Constituency VALUES ('충남 아산시 갑', '충청도');
INSERT INTO DB066_Constituency VALUES ('충남 공주시부여군청양군', '충청도');
INSERT INTO DB066_Constituency VALUES ('충남 홍성군예산군', '충청도');
INSERT INTO DB066_Constituency VALUES ('대전 대덕구', '충청도');
INSERT INTO DB066_Constituency VALUES ('대전 동구', '충청도');
INSERT INTO DB066_Constituency VALUES ('대전 서구 갑', '충청도');
INSERT INTO DB066_Constituency VALUES ('대전 서구 을', '충청도');
INSERT INTO DB066_Constituency VALUES ('대전 유성구 갑', '충청도');
INSERT INTO DB066_Constituency VALUES ('대전 유성구 을', '충청도');
INSERT INTO DB066_Constituency VALUES ('대전 중구', '충청도');
INSERT INTO DB066_Constituency VALUES ('세종 세종특별자치시', '충청도');
INSERT INTO DB066_Constituency VALUES ('부산 금정구', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 기장군', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 남구 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 남구 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 동래구', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 부산진구 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 부산진구 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 북서강서구 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 북서강서구 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 사상구', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 사하구 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 사하구 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 서구동구', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 수영구', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 연제구', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 중구영도구', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 해운대구 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('부산 해운대구 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 달서구 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 달서구 병', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 달서구 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 달성군', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 동구 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 동구 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 북구 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 북구 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 서구', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 수성구 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 수성구 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구 중구남구', '경상도');
INSERT INTO DB066_Constituency VALUES ('울산 남구 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('울산 남구 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('울산 동구', '경상도');
INSERT INTO DB066_Constituency VALUES ('울산 북구', '경상도');
INSERT INTO DB066_Constituency VALUES ('울산 울주군', '경상도');
INSERT INTO DB066_Constituency VALUES ('울산 중구', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 영양군영덕군봉화군울진군', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 안동시', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 경주시', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 상주시군위군의성군청송군', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 포항시북구', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 포항시남구울릉군', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 구미시 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 영천시청도군', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 고령군성주군칠곡군', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 김천시', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 구미시 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 경산시', '경상도');
INSERT INTO DB066_Constituency VALUES ('경북 영주시문경시예천군', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 산청군함양군거창군합천군', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 김해시 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 창원시진해구', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 진주시 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 거제시', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 창원시성산구', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 김해시 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 진주시 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 창원시의창구', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 양산시 갑', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 양산시 을', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 밀양시의령군함안군창녕군', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 사천시남해군하동군', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 창원시마산회원구', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 통영시고성군', '경상도');
INSERT INTO DB066_Constituency VALUES ('경남 창원시마산합포구', '경상도');
INSERT INTO DB066_Constituency VALUES ('광주 광산구 갑', '전라도');
INSERT INTO DB066_Constituency VALUES ('광주 광산구 을', '전라도');
INSERT INTO DB066_Constituency VALUES ('광주 동구남구 갑', '전라도');
INSERT INTO DB066_Constituency VALUES ('광주 동구남구 을', '전라도');
INSERT INTO DB066_Constituency VALUES ('광주 북구 갑', '전라도');
INSERT INTO DB066_Constituency VALUES ('광주 북구 을', '전라도');
INSERT INTO DB066_Constituency VALUES ('광주 서구 갑', '전라도');
INSERT INTO DB066_Constituency VALUES ('광주 서구 을', '전라도');
INSERT INTO DB066_Constituency VALUES ('전북 군산시', '전라도');
INSERT INTO DB066_Constituency VALUES ('전북 전주시 갑', '전라도');
INSERT INTO DB066_Constituency VALUES ('전북 김제시부안군', '전라도');
INSERT INTO DB066_Constituency VALUES ('전북 완주군진안군무주군장수군', '전라도');
INSERT INTO DB066_Constituency VALUES ('전북 정읍시고창군', '전라도');
INSERT INTO DB066_Constituency VALUES ('전북 남원시임실군순창군', '전라도');
INSERT INTO DB066_Constituency VALUES ('전북 익산시 갑', '전라도');
INSERT INTO DB066_Constituency VALUES ('전북 전주시 병', '전라도');
INSERT INTO DB066_Constituency VALUES ('전북 전주시 을', '전라도');
INSERT INTO DB066_Constituency VALUES ('전북 익산시 을', '전라도');
INSERT INTO DB066_Constituency VALUES ('전남 영암군무안군신안군', '전라도');
INSERT INTO DB066_Constituency VALUES ('전남 목포시', '전라도');
INSERT INTO DB066_Constituency VALUES ('전남 나주시화순군', '전라도');
INSERT INTO DB066_Constituency VALUES ('전남 해남군완도군진도군', '전라도');
INSERT INTO DB066_Constituency VALUES ('전남 담양군함평군영광군장성군', '전라도');
INSERT INTO DB066_Constituency VALUES ('전남 여수시 갑', '전라도');
INSERT INTO DB066_Constituency VALUES ('전남 순천시', '전라도');
INSERT INTO DB066_Constituency VALUES ('전남 광양시곡성군구례군', '전라도');
INSERT INTO DB066_Constituency VALUES ('전남 여수시 을', '전라도');
INSERT INTO DB066_Constituency VALUES ('전남 고흥군보성군장흥군강진군', '전라도');
INSERT INTO DB066_Constituency VALUES ('제주 제주시 갑', '전라도');
INSERT INTO DB066_Constituency VALUES ('제주 제주시 을', '전라도');
INSERT INTO DB066_Constituency VALUES ('제주 서귀포시', '전라도');
INSERT INTO DB066_Constituency VALUES ('강원 강릉시', '강원도');
INSERT INTO DB066_Constituency VALUES ('강원 동해시삼척시', '강원도');
INSERT INTO DB066_Constituency VALUES ('강원 속초시고성군양양군', '강원도');
INSERT INTO DB066_Constituency VALUES ('강원 원주시 갑', '강원도');
INSERT INTO DB066_Constituency VALUES ('강원 원주시 을', '강원도');
INSERT INTO DB066_Constituency VALUES ('강원 춘천시', '강원도');
INSERT INTO DB066_Constituency VALUES ('강원 태백시횡성군영월군평창군정선군', '강원도');
INSERT INTO DB066_Constituency VALUES ('강원 홍천군철원군화천군양구군인제군', '강원도');
INSERT INTO DB066_Constituency VALUES ('서울특별시', '경기도');
INSERT INTO DB066_Constituency VALUES ('부산광역시', '경상도');
INSERT INTO DB066_Constituency VALUES ('대구광역시', '경상도');
INSERT INTO DB066_Constituency VALUES ('인천광역시', '경기도');
INSERT INTO DB066_Constituency VALUES ('광주광역시', '전라도');
INSERT INTO DB066_Constituency VALUES ('대전광역시', '충청도');
INSERT INTO DB066_Constituency VALUES ('울산광역시', '경상도');
INSERT INTO DB066_Constituency VALUES ('세종특별자치시', '충청도');
INSERT INTO DB066_Constituency VALUES ('경기도', '경기도');
INSERT INTO DB066_Constituency VALUES ('강원도', '강원도');
INSERT INTO DB066_Constituency VALUES ('충청북도', '충청도');
INSERT INTO DB066_Constituency VALUES ('충청남도', '충청도');
INSERT INTO DB066_Constituency VALUES ('전라북도', '전라도');
INSERT INTO DB066_Constituency VALUES ('전라남도', '전라도');
INSERT INTO DB066_Constituency VALUES ('경상북도', '경상도');
INSERT INTO DB066_Constituency VALUES ('경상남도', '경상도');
INSERT INTO DB066_Constituency VALUES ('제주특별자치도', '전라도');

INSERT INTO DB066_Place_of_birth VALUES ('서울 강남구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 강동구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 강북구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 강서구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 관악구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 광진구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 구로구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 금천구 ', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 노원구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 도봉구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 동대문구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 동작구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 마포구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 서대문구 ', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 서초구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 성북구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 송파구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 양천구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 영등포구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 용산구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 은평구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 종로구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 종구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 성동구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울 중랑구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('서울', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('인천 계양구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('인천 남구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('인천 남동구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('인천 부평구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('인천 서구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('인천 연수구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('인천 중구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('인천 동구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('인천 강화군', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('인천 옹진군', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('인천', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 고양시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 광명시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 광주시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 구리시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 군포시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 김포시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 남양주시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 동두천시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 연천군', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 부천시소사구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 부천시오정구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 부천시원미구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 부천시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 성남시분당구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 성남시수정구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 성남시중원구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 수원시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 시흥시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 안산시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 안산시단원구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 안산시상록구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 안성시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 안양시동안구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 안양시만안구', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 양주시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 여주시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 양평군', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 오산시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 용인시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 의왕시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 과천시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 의정부시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 이천시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 파주시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 평택시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 포천시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 가평군', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 하남시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('경기 화성시', '경기도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 증평군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 진천군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 음성군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 제천시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 단양군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 흥덕구', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 보은군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 옥천군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 영동군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 괴산군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 청주시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 청원구', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 서원구', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 충주시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충북 상당구', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 논산시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 계룡시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 금산군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 보령시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 서천군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 천안시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 서산시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 태안군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 당진시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 아산시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 공주시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 부여군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 청양군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 홍성군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('충남 예산군', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('대전 대덕구', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('대전 동구', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('대전 서구', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('대전 유성구', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('대전 중구', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('대전', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('세종 세종특별자치시', '충청도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 금정구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 기장구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 남구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 동래구 ', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 부산진구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 북서강서구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 사상구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 사하구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 서구동구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 수영구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 연제구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 중구영도구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산 해운대구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('부산', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('대구 달서구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('대구 달성군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('대구 동구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('대구 북구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('대구 서구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('대구 수성구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('대구 중구남구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('대구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('울산 남구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('울산 동구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('울산 북구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('울산 울주군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('울산 중구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('울산', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 영양군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 영덕군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 봉화군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 울진군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 안동시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 경주시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 상주시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 군위군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 의성군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 청송군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 포항시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 북구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 남구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 울릉군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 구미시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 영천시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 청도군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 고령군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 성주군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 칠곡군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 김천시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 경산시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 영주시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 문경시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 예천군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경북 영일군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 산청군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 함양군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 거창군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 합천군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 창원시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 진해구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 거제시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 성산구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 김해시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 진주시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 의창구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 밀양시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 의령군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 함안군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 창녕군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 사천시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 남해군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 하동군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 양산시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 마산시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 마산회원구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 통영시', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 고성군', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('경남 마산합포구', '경상도');
INSERT INTO DB066_Place_of_birth VALUES ('광주 광산구', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('광주 동구남구', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('광주 북구', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('광주 서구', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('광주', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 군산시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 전주시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 김제시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 부안군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 완주군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 진안군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 무주군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 장수군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 정읍시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 고창군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 남원시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 임실군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 순창군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전북 익산시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 영암군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 무안군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 신안군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 목포시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 나주시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 화순군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 해남군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 완도군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 진도군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 담양군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 함평군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 영광군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 장성군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 여수시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 순천시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 광양시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 곡성군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 구례군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 고흥군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 보성군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 장흥군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('전남 강진군', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('제주 제주시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('제주 서귀포시', '전라도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 강릉시', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 동해시', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 삼척시', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 속초시', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 고성군', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 양양군', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 원주시', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 춘천시', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 태백시', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 횡성군', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 영월군', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 평창군', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 정선군', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 홍천군', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 철원군', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 화천군', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 양구군', '강원도');
INSERT INTO DB066_Place_of_birth VALUES ('강원 인제군', '강원도');

INSERT INTO DB066_Elected_Officer VALUES (1, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (2, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (3, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (4, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (5, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (6, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (7, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (8, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (9, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (10, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (11, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (12, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (13, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (14, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (15, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (16, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (17, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (18, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (19, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (20, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (21, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (22, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (23, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (24, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (25, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (26, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (27, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (28, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (29, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (30, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (31, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (32, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (33, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (34, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (35, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (36, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (37, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (38, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (39, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (40, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (41, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (42, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (43, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (44, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (45, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (46, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (47, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (48, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (49, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (50, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (51, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (52, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (53, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (54, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (55, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (56, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (57, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (58, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (59, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (60, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (61, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (62, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (63, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (64, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (65, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (66, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (67, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (68, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (69, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (70, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (71, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (72, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (73, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (74, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (75, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (76, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (77, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (78, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (79, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (80, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (81, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (82, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (83, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (84, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (85, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (86, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (87, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (88, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (89, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (90, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (91, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (92, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (93, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (94, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (95, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (96, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (97, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (98, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (99, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (100, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (101, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (102, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (103, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (104, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (105, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (106, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (107, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (108, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (109, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (110, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (111, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (112, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (113, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (114, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (115, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (116, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (117, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (118, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (119, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (120, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (121, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (122, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (123, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (124, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (125, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (126, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (127, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (128, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (129, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (130, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (131, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (132, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (133, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (134, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (135, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (136, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (137, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (138, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (139, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (140, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (141, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (142, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (143, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (144, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (145, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (146, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (147, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (148, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (149, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (150, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (151, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (152, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (153, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (154, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (155, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (156, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (157, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (158, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (159, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (160, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (161, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (162, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (163, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (164, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (165, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (166, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (167, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (168, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (169, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (170, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (171, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (172, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (173, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (174, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (175, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (176, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (177, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (178, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (179, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (180, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (181, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (182, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (183, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (184, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (185, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (186, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (187, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (188, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (189, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (190, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (191, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (192, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (193, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (194, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (195, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (196, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (197, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (198, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (199, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (200, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (201, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (202, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (203, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (204, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (205, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (206, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (207, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (208, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (209, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (210, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (211, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (212, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (213, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (214, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (215, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (216, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (217, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (218, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (219, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (220, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (221, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (222, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (223, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (224, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (225, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (226, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (227, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (228, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (229, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (230, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (231, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (232, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (233, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (234, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (235, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (236, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (237, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (238, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (239, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (240, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (241, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (242, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (243, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (244, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (245, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (246, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (247, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (248, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (249, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (250, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (251, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (252, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (253, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (254, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (255, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (256, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (257, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (258, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (259, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (260, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (261, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (262, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (263, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (264, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (265, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (266, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (267, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (268, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (269, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (270, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (271, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (272, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (273, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (274, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (275, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (276, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (277, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (278, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (279, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (280, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (281, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (282, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (283, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (284, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (285, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (286, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (287, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (288, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (289, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (290, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (291, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (292, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (293, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (294, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (295, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (296, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (297, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (298, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (299, 'Congressman');
INSERT INTO DB066_Elected_Officer VALUES (300, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (301, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (302, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (303, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (304, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (305, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (306, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (307, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (308, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (309, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (310, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (311, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (312, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (313, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (314, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (315, 'Provincial Governor');
INSERT INTO DB066_Elected_Officer VALUES (316, 'Provincial Governor');

INSERT INTO DB066_Congressman VALUES (1, 'The Minjoo Party of Korea', 'KANG BYUNGWON', 'M', '47', '전북 고창군', '학사', '7.5', '서울 은평구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (2, 'The Minjoo Party of Korea', 'KANG CHANGIL', 'M', '66', '제주 제주시', '박사', '21.1', '제주 제주시 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (3, 'The Minjoo Party of Korea', 'KANG HOONSIK', 'M', '45', '충남 아산시', '학사', '2.1', '충남 아산시 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (4, 'The Minjoo Party of Korea', 'KOH YONGJIN', 'M', '54', '서울', '석사', '8.7', '서울 노원구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (5, 'The Minjoo Party of Korea', 'KWON MIHYUK', 'W', '59', '대전', NUll, '3.0', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (6, 'The Minjoo Party of Korea', 'KWON CHILSEUNG', 'M', '53', '경북 영천시', '학사', '2.6', '경기 화성시 병', '선거', '1');
INSERT INTO DB066_Congressman VALUES (7, 'The Minjoo Party of Korea', 'KEUM TAESUP', 'M', '51', '서울', '석사', '57.5', '서울 강서구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (8, 'The Minjoo Party of Korea', 'KI DONGMIN', 'M', '52', '전남 장성군', '석사', '18.4', '서울 성북구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (9, 'The Minjoo Party of Korea', 'KIM KYOUNGSOO', 'M', '51', '경남 고성군', '학사', '3.6', '경남 김해시 을', ' 선거', '1');
INSERT INTO DB066_Congressman VALUES (10, 'The Minjoo Party of Korea', 'KIM KYUNGHYUP', 'M', '56', '전남 장흥군', '박사', NUll, '경기 부천시원미구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (11, 'The Minjoo Party of Korea', 'KIM DUKWAN', 'M', '59', '경남 남해군', '박사', '3.7', '경기 김포시 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (12, 'The Minjoo Party of Korea', 'KIM MINKI', 'M', '52', '경기 용인시', '학사', '4.3', '경기 용인시 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (13, 'The Minjoo Party of Korea', 'KIM BYOUNGGWAN', 'M', '45', NUll, '석사', '1678.8', '경기 성남시분당구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (14, 'The Minjoo Party of Korea', 'KIM BYUNGKEE', 'M', '57', NUll, '학사', '18.1', '서울 동작구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (15, 'The Minjoo Party of Korea', 'KIM BYUNGWOOK', 'M', '53', '경남 산청군', '박사', '48.3', '경기 성남시분당구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (16, 'The Minjoo Party of Korea', 'KIM BOOKYUM', 'M', '60', '경북 상주시', '석사', '10.8', '대구 수성구 갑', '선거', '4');
INSERT INTO DB066_Congressman VALUES (17, 'The Minjoo Party of Korea', 'KIM SANGHEE', 'W', '64', '충남 공주시', '학사', '10.5', '경기 부천시소사구', '선거', '3');
INSERT INTO DB066_Congressman VALUES (18, 'The Minjoo Party of Korea', 'KIM SUNGSOO', 'M', '62', NUll, '학사', '4.7', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (19, 'The Minjoo Party of Korea', 'KIM YOUNGJOO', 'W', '63', '서울', '석사', '18.8', '서울 영등포구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (20, 'The Minjoo Party of Korea', 'KIM YOUNGJIN', 'M', '51', '충남 예산군', '학사', '5.8', '경기 수원시 병', '선거', '1');
INSERT INTO DB066_Congressman VALUES (21, 'The Minjoo Party of Korea', 'KIM YOUNGCHOON', 'M', '56', '부산', '학사', '9.3', '부산 부산진구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (22, 'The Minjoo Party of Korea', 'KIM YOUNGHO', 'M', '51', '서울', '석사', '6.0', '서울 서대문구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (23, 'The Minjoo Party of Korea', 'KIM CHUNGWOO', 'M', '50', NUll, '박사', '19.2', '경기 군포시 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (24, 'The Minjoo Party of Korea', 'KIM JONGMIN', 'M', '54', '충남 논산시', '학사', '3.7', '충남 논산시계룡시금산군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (25, 'The Minjoo Party of Korea', 'KIM JINPYO', 'M', '71', '경기 수원시', '석사', '17.1', '경기 수원시 무', '선거', '4');
INSERT INTO DB066_Congressman VALUES (26, 'The Minjoo Party of Korea', 'KIM CHEOLMIN', 'M', '61', '전북 진안군', '석사', '20.9', '경기 안산시상록구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (27, 'The Minjoo Party of Korea', 'KIM TAENYEON', 'M', '53', '전남 순천시', '석사', '6.4', '경기 성남시수정구', '선거', '3');
INSERT INTO DB066_Congressman VALUES (28, 'The Minjoo Party of Korea', 'KIM HANJUNG', 'M', '55', '경남 함안군', '박사', '8.3', '경기 남양주시 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (29, 'The Minjoo Party of Korea', 'KIM HAEYOUNG', 'M', '41', '부산 부산진구', '학사', '5.8', '부산 연제구', '선거', '1');
INSERT INTO DB066_Congressman VALUES (30, 'The Minjoo Party of Korea', 'KIM HYUNKWON', 'M', '55', NUll, '석사', '5.9', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (31, 'The Minjoo Party of Korea', 'KIM HYUNMEE', 'W', '56', '전북 고창군', '학사', '8.6', '경기 고양시 정', '선거', '3');
INSERT INTO DB066_Congressman VALUES (32, 'The Minjoo Party of Korea', 'NAM INSOON', 'W', '60', NUll, '석사', '5.5', '서울 송파구 병', '선거', '2');
INSERT INTO DB066_Congressman VALUES (33, 'The Minjoo Party of Korea', 'NOH WOONGRAE', 'M', '61', NUll, '석사', '5.8', '서울 마포구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (34, 'The Minjoo Party of Korea', 'DO JONGHWAN', 'M', '63', '충북 청주시', '박사', '19.1', '충북 청주시흥덕구', '선거', '2');
INSERT INTO DB066_Congressman VALUES (35, 'The Minjoo Party of Korea', 'MOON HEESANG', 'M', '73', '경기 의정부시', '학사', '1.2', '경기 의정부시 갑', '선거', '6');
INSERT INTO DB066_Congressman VALUES (36, 'The Minjoo Party of Korea', 'MIN BYUNGDOO', 'M', '60', NUll, '학사', '10.8', '서울 동대문구 을', '선거', '3');
INSERT INTO DB066_Congressman VALUES (37, 'The Minjoo Party of Korea', 'MIN HONGCHUL', 'M', '57', '경남 김해시', '석사', '12.4', '경남 김해시 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (38, 'The Minjoo Party of Korea', 'PARK KYUNGMEE', 'W', '53', NUll, '박사', '23.3', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (39, 'The Minjoo Party of Korea', 'PARK KWANGON', 'M', '61', NUll, '석사', '14.9', '경기 수원시 정', '선거', '2');
INSERT INTO DB066_Congressman VALUES (40, 'The Minjoo Party of Korea', 'PARK NAMCHOON', 'M', '60', '인천', '석사', '19.8', '인천 남동구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (41, 'The Minjoo Party of Korea', 'PARK BEOMKYE', 'M', '55', '충북 영동군', '학사', '10.1', '대전 서구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (42, 'The Minjoo Party of Korea', 'PARK BYEONGSEUG', 'M', '66', NUll, '박사', '40.1', '대전 서구 갑', '선거', '5');
INSERT INTO DB066_Congressman VALUES (43, 'The Minjoo Party of Korea', 'PARK YOUNGSUN', 'W', '58', '경남 창녕군', '석사', '35.3', '서울 구로구 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (44, 'The Minjoo Party of Korea', 'PARK WANJOO', 'M', '52', '충남 천안시', '학사', '4.7', '충남 천안시 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (45, 'The Minjoo Party of Korea', 'PARK YONGJIN', 'M', '47', '전북 장수군 ', '석사', '5.3', '서울 강북구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (46, 'The Minjoo Party of Korea', 'PARK JAEHO', 'M', '59', NUll, '석사', '7.8', '부산 남구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (47, 'The Minjoo Party of Korea', 'PARK JEUNG', 'M', '56', '경기 파주시', '박사', '229.9', '경기 파주시 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (48, 'The Minjoo Party of Korea', 'PARK JUMIN', 'M', '45', '서울', '학사', '7.1', '서울 은평구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (49, 'The Minjoo Party of Korea', 'PARK CHANDAE', 'M', '51', '인천', '석사', '11.7', '인천 연수구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (50, 'The Minjoo Party of Korea', 'PARK HONGGEUN', 'M', '49', '전남 고흥군', '석사', '2.3', '서울 중랑구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (51, 'The Minjoo Party of Korea', 'BAEK JAEHYUN', 'M', '67', '전북 고창군', '학사', '30.0', '경기 광명시 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (52, 'The Minjoo Party of Korea', 'BACK HYERYUN', 'W', '51', '전남 장흥군', '학사', '5.4', '경기 수원시 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (53, 'The Minjoo Party of Korea', 'BYUN JAEILL', 'M', '70', '충북 청원구', '석사', '31.0', '충북 청주시청원구', '선거', '4');
INSERT INTO DB066_Congressman VALUES (54, 'The Minjoo Party of Korea', 'SEO YOUNGKYO', 'W', '54', NUll, '박사', '11.6', '서울 중랑구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (55, 'The Minjoo Party of Korea', 'SEO HYUNGSOO', 'M', '61', NUll, '학사', '3.0', '경남 양산시 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (56, 'The Minjoo Party of Korea', 'SUL HOON', 'M', '65', '경남 창원시', '학사', '4.1', '경기 부천시원미구 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (57, 'The Minjoo Party of Korea', 'SO BYUNGHOON', 'M', '64', '전북 군산시', '학사', '26.2', '경기 광주시 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (58, 'The Minjoo Party of Korea', 'SOHN HYEWON', 'W', '63', NUll, '석사', '45.8', '서울 마포구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (59, 'The Minjoo Party of Korea', 'SONG KIHUN', 'M', '55', '강원 원주시', '학사', '1.0', '강원 원주시 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (60, 'The Minjoo Party of Korea', 'SONG YOUNGGIL', 'M', '55', '전남 고흥군', '학사', '4.2', '인천 계양구 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (61, 'The Minjoo Party of Korea', 'SONG OKJOO', 'W', '53', '경기 화성시', '석사', '3.9', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (62, 'The Minjoo Party of Korea', 'SHIN KYOUNGMIN', 'M', '65', '전북 전주시', '석사', '40.5', '서울 영등포구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (63, 'The Minjoo Party of Korea', 'SHIN DONGKEUN', 'M', '57', NUll, '박사', '1.3', '인천 서구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (64, 'The Minjoo Party of Korea', 'SHIN CHANGHYUN', 'M', '65', '전북 익산시', '학사', '13.5', '경기 의왕시과천시', '선거', '1');
INSERT INTO DB066_Congressman VALUES (65, 'The Minjoo Party of Korea', 'SHIM KIJOON', 'M', '57', NUll, '학사', NUll, NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (66, 'The Minjoo Party of Korea', 'SHIM JAEKWON', 'M', '72', '전북 완주군', '박사', '11.8', '서울 강동구 을', '선거', '3');
INSERT INTO DB066_Congressman VALUES (67, 'The Minjoo Party of Korea', 'AHN GYUBACK', 'M', '57', NUll, '학사', '45.1', '서울 동대문구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (68, 'The Minjoo Party of Korea', 'AN MINSUK', 'M', '52', NUll, '박사', '7.8', '경기 오산시', '선거', '4');
INSERT INTO DB066_Congressman VALUES (69, 'The Minjoo Party of Korea', 'AN HOYOUNG', 'M', '53', '전북 진안군', '박사', '10.3', '전북 완주군진안군무주군장수군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (70, 'The Minjoo Party of Korea', 'YANG SEUNGJO', 'M', '59', '충남 천안시', '석사', '4.3', '충남 천안시 병', '선거', '4');
INSERT INTO DB066_Congressman VALUES (71, 'The Minjoo Party of Korea', 'EOH KIYKU', 'M', '55', '충남 당진시', '박사', '2.5', '충남 당진시', '선거', '1');
INSERT INTO DB066_Congressman VALUES (72, 'The Minjoo Party of Korea', 'OH YOUNGHUN', 'M', '50', NUll, '석사', '1.0', '제주 제주시 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (73, 'The Minjoo Party of Korea', 'OH JAESAE', 'M', '69', '충북 청주시', '석사', '28.3', '충북 청주시서원구', '선거', '4');
INSERT INTO DB066_Congressman VALUES (74, 'The Minjoo Party of Korea', 'WOO SANGHO', 'M', '56', '강원 철원군', '석사', '4.6', '서울 서대문구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (75, 'The Minjoo Party of Korea', 'WOO WONSHIK', 'M', '61', '서울', '석사', '16.7', '서울 노원구 을', '선거', '3');
INSERT INTO DB066_Congressman VALUES (76, 'The Minjoo Party of Korea', 'WON HYEYOUNG', 'M', '67', '경기 부천시', '학사', '8.4', '경기 부천시오정구', '선거', '5');
INSERT INTO DB066_Congressman VALUES (77, 'The Minjoo Party of Korea', 'WI SEONGGON', 'M', '50', NUll, '석사', '4.0', '제주 서귀포시', '선거', '1');
INSERT INTO DB066_Congressman VALUES (78, 'The Minjoo Party of Korea', 'YOO DONGSOO', 'M', '57', '전북 부안군', '학사', '30.6', '인천 계양구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (79, 'The Minjoo Party of Korea', 'YOU SEUNGHEE', 'W', '68', '서울', '박사', '7.0', '서울 성북구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (80, 'The Minjoo Party of Korea', 'YOO EUNHAE', 'W', '56', NUll, '석사', '2.2', '경기 고양시 병', '선거', '1');
INSERT INTO DB066_Congressman VALUES (81, 'The Minjoo Party of Korea', 'YOUN KWANSUK', 'M', '58', NUll, '학사', '10.5', '인천 남동구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (82, 'The Minjoo Party of Korea', 'YUN HOJUNG', 'M', '55', '경기 가평군', '학사', '11.8', '경기 구리시', '선거', '3');
INSERT INTO DB066_Congressman VALUES (83, 'The Minjoo Party of Korea', 'YOON HUDUK', 'M', '61', '경기 파주시', '박사', '24.7', '경기 파주시 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (84, 'The Minjoo Party of Korea', 'LEE KAIHO', 'M', '59', '전남 담양군', '학사', '20.7', '전남 담양군함평군영광군장성군', '선거', '2');
INSERT INTO DB066_Congressman VALUES (85, 'The Minjoo Party of Korea', 'LEE SANGMIN', 'M', '60', '대전', '학사', '24.5', '대전 유성구 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (86, 'The Minjoo Party of Korea', 'LEE SEOKHYUN', 'M', '67', '전북 익산시', '학사', '11.7', '경기 안양시동안구 갑', '선거', '6');
INSERT INTO DB066_Congressman VALUES (87, 'The Minjoo Party of Korea', 'LEE SOOHYUCK', 'M', '69', NUll, '석사', NUll, NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (88, 'The Minjoo Party of Korea', 'LEE YONGDEUK', 'M', '65', '경북 안동시', '학사', '28.8', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (89, 'The Minjoo Party of Korea', 'LEE WONWOOK', 'M', '55', '충남 보령시', '학사', '8.0', '경기 화성시 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (90, 'The Minjoo Party of Korea', 'LEE INYOUNG', 'M', '54', '충북 충주시', '석사', '14.9', '서울 구로구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (91, 'The Minjoo Party of Korea', 'LEE JAEJUNG', 'W', '44', NUll, '학사', '2.0', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (92, 'The Minjoo Party of Korea', 'LEE JONGKUL', 'M', '61', '서울', '학사', '21.4', '경기 안양시만안구', '선거', '5');
INSERT INTO DB066_Congressman VALUES (93, 'The Minjoo Party of Korea', 'RHEE CHEOLHEE', 'M', '52', '경북 영일군', '석사', '10.2', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (94, 'The Minjoo Party of Korea', 'LEE CHOONSUAK', 'M', '55', '전북 익산시', '박사', '5.7', '전북 익산시 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (95, 'The Minjoo Party of Korea', 'LEE HACKYOUNG', 'M', '66', '전북 순창군', '석사', '19.7', '경기 군포시 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (96, 'The Minjoo Party of Korea', 'LEE HAECHAN', 'M', '66', '충남 청양군', '학사', '11.3', '세종 세종특별자치시', '선거', '7');
INSERT INTO DB066_Congressman VALUES (97, 'The Minjoo Party of Korea', 'LEE HOON', 'M', '53', '전남 신안군', '학사', '11.9', '서울 금천구', '선거', '1');
INSERT INTO DB066_Congressman VALUES (98, 'The Minjoo Party of Korea', 'IN JAEKEUN', 'W', '65', '인천 강화군', '학사', '12.2', '서울 도봉구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (99, 'The Minjoo Party of Korea', 'LIM JONGSEONG', 'M', '53', '경기 광주시', '석사', '2.0', '경기 광주시 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (100, 'The Minjoo Party of Korea', 'CHUN JAESOO', 'M', '47', '경남 의령군', '석사', '3.4', '부산 북서강서구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (101, 'The Minjoo Party of Korea', 'JEON HAECHEOL', 'M', '56', '전남 목포시', '학사', '22.1', '경기 안산시상록구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (102, 'The Minjoo Party of Korea', 'JEON HYUNHEUI', 'W', '54', NUll, '석사', '10.9', '서울 강남구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (103, 'The Minjoo Party of Korea', 'JUN HYESOOK', 'W', '63', '경북 칠곡군', '석사', '7.7', '서울 광진구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (104, 'The Minjoo Party of Korea', 'JUNG SUNGHO', 'M', '56', NUll, '학사', '35.6', '경기 양주시', '선거', '3');
INSERT INTO DB066_Congressman VALUES (105, 'The Minjoo Party of Korea', 'JUNG JAEHO', 'M', '53', '대구 달성군', '학사', '17.2', '경기 고양시 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (106, 'The Minjoo Party of Korea', 'JUNG CHOUNSOOK', 'W', '54', NUll, '박사', NUll, NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (107, 'The Minjoo Party of Korea', 'JE YOUNKYUNG', 'W', '47', NUll, '학사', '4.2', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (108, 'The Minjoo Party of Korea', 'JO SEOUNGLAE', 'M', '50', '충남 논산시', '석사', '8.0', '대전 유성구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (109, 'The Minjoo Party of Korea', 'CHO EUNGCHEON', 'M', '56', '대구', '학사', '31.2', '경기 남양주시 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (110, 'The Minjoo Party of Korea', 'CHO JEONGSIK', 'M', '55', NUll, '석사', '7.9', '경기 시흥시 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (111, 'The Minjoo Party of Korea', 'JIN SUNMEE', 'W', '51', '전북 순창군', '학사', '-14.2', '서울 강동구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (112, 'The Minjoo Party of Korea', 'CHIN YOUNG', 'M', '68', NUll, '석사', '51.1', '서울 용산구', '선거', '4');
INSERT INTO DB066_Congressman VALUES (113, 'The Minjoo Party of Korea', 'CHOI WOONYOUL', 'M', '68', '전남 영암군', '박사', '40.5', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (114, 'The Minjoo Party of Korea', 'CHOI INHO', 'M', '52', '경남 창녕군', '박사', '7.5', '부산 사하구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (115, 'The Minjoo Party of Korea', 'CHOO MIAE', 'W', '60', '대구 달성군', '석사', '11.1', '서울 광진구 을', '선거', '5');
INSERT INTO DB066_Congressman VALUES (116, 'The Minjoo Party of Korea', 'PYO CHANGWON', 'M', '52', '경북 포항시', '박사', '5.6', '경기 용인시 정', '선거', '1');
INSERT INTO DB066_Congressman VALUES (117, 'The Minjoo Party of Korea', 'HAN JEOUNGAE', 'W', '53', '충북 단양군', '박사', '7.7', '서울 강서구 병', '선거', '2');
INSERT INTO DB066_Congressman VALUES (118, 'The Minjoo Party of Korea', 'HONG YOUNGPYO', 'M', '61', '전북 고창군', '박사', '7.8', '인천 부평구 을', '선거', '3');
INSERT INTO DB066_Congressman VALUES (119, 'The Minjoo Party of Korea', 'HONG EUIRAK', 'M', '63', '경북 봉화군', '학사', '26.1', '대구 북구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (120, 'The Minjoo Party of Korea', 'HONG IHKPYO', 'M', '51', NUll, '박사', '14.4', '서울 종구성동구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (121, 'The Minjoo Party of Korea', 'HWANG HEE', 'M', '51', '전남 목포시', '박사', '1.2', '서울 양천구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (122, 'Liberty Korea Party', 'KANG GHILBOO', 'M', '76', '울산', '박사', '34.3', '울산 울주군', '선거', '4');
INSERT INTO DB066_Congressman VALUES (123, 'Liberty Korea Party', 'KANG SEOKJIN', 'M', '59', NUll, '석사', '4.7', '경남 산청군함양군거창군합천군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (124, 'Liberty Korea Party', 'KANG SEOKHO', 'M', '63', NUll, '학사', '139.4', '경북 영양군영덕군봉화군울진군', '선거', '3');
INSERT INTO DB066_Congressman VALUES (125, 'Liberty Korea Party', 'KHANG HYOSHANG', 'M', '57', NUll, '석사', '28.4', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (126, 'Liberty Korea Party', 'KYEONG DAESOO', 'M', '60', '충북 괴산군', '석사', '9.4', '충북 증평군진천군음성군', '선거', '2');
INSERT INTO DB066_Congressman VALUES (127, 'Liberty Korea Party', 'KWAK DAEHOON', 'M', '63', '대구 달성군', '석사', '17.0', '대구 달서구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (128, 'Liberty Korea Party', 'KWAK SANGDO', 'M', '59', '대구', '석사', '33.9', '대구 중구남구', '선거', '1');
INSERT INTO DB066_Congressman VALUES (129, 'Liberty Korea Party', 'KWON SOKCHANG', 'M', '52', '충북 제천시', '석사', '13.1', '충북 제천시단양군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (130, 'Liberty Korea Party', 'KWEON SEONGDONG', 'M', '58', '강원 강릉시', '석사', '35.2', '강원 강릉시', '선거', '3');
INSERT INTO DB066_Congressman VALUES (131, 'Liberty Korea Party', 'KIM GWANGLIM', 'M', '70', '경북 안동시', '박사', '61.8', '경북 안동시', '선거', '3');
INSERT INTO DB066_Congressman VALUES (132, 'Liberty Korea Party', 'KIM GYUHWAN', 'M', '62', '강원 평창군', '박사', '21.5', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (133, 'Liberty Korea Party', 'KIM KISUN', 'M', '66', '강원 원주시', '학사', '6.5', '강원 원주시 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (134, 'Liberty Korea Party', 'KIM DOEUP', 'M', '54', '부산', '학사', '29.3', '부산 북서강서구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (135, 'Liberty Korea Party', 'KIM MYUNGYEON', 'M', '54', '경기 안산시', '석사', '17.3', '경기 안산시단원구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (136, 'Liberty Korea Party', 'KIM MOOSUNG', 'M', '67', '부산', '학사', '141.6', '부산 중구영도구', '선거', '6');
INSERT INTO DB066_Congressman VALUES (137, 'Liberty Korea Party', 'KIM SANGHOON', 'M', '55', NUll, '석사', '7.8', '대구 서구', '선거', '2');
INSERT INTO DB066_Congressman VALUES (138, 'Liberty Korea Party', 'KIM SEOKKI', 'M', '64', '경북 경주시', '석사', '9.9', '경북 경주시', '선거', '1');
INSERT INTO DB066_Congressman VALUES (139, 'Liberty Korea Party', 'KIM SEONDONG', 'M', '63', '강원 원주시', '석사', '5.4', '서울 도봉구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (140, 'Liberty Korea Party', 'KIM SUNGWON', 'M', '45', '경기 동두천시', '박사', '4.9', '경기 동두천시연천군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (141, 'Liberty Korea Party', 'KIM SUNGCHAN', 'M', '64', '경남 진해구', '박사', '16.4', '경남 창원시진해구', '선거', '2');
INSERT INTO DB066_Congressman VALUES (142, 'Liberty Korea Party', 'KIM SUNGTAE', 'M', '60', '경남 진주시', '석사', '10.6', '서울 강서구 을', '선거', '3');
INSERT INTO DB066_Congressman VALUES (143, 'Liberty Korea Party', 'KIM SEANGTAE', 'M', '64', '경남 창원시', '박사', '14.2', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (144, 'Liberty Korea Party', 'KIM SOONRYE', 'W', '63', '서울', '박사', '30.6', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (145, 'Liberty Korea Party', 'KIM SEUNGHEE', 'W', '64', NUll, '박사', '19.6', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (146, 'Liberty Korea Party', 'KIM YOUNGWOO', 'M', '51', '경기 포천시', '박사', '9.4', '경기 포천시가평군', '선거', '3');
INSERT INTO DB066_Congressman VALUES (147, 'Liberty Korea Party', 'KIM YONGTAE', 'M', '50', '대전', '학사', '9.6', '서울 양천구 을', '선거', '3');
INSERT INTO DB066_Congressman VALUES (148, 'Liberty Korea Party', 'KIM JAEKYUNG', 'M', '57', '경남 진주시', '석사', '17.1', '경남 진주시 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (149, 'Liberty Korea Party', 'KIM JAEWON', 'M', '54', '경북 의성군', '석사', '30.7', '경북 상주시군위군의성군청송군', '선거', '3');
INSERT INTO DB066_Congressman VALUES (150, 'Liberty Korea Party', 'KIM JUNGJAE', 'W', '52', '경북 포항시', '석사', '3.8', '경북 포항시북구', '선거', '1');
INSERT INTO DB066_Congressman VALUES (151, 'Liberty Korea Party', 'KIM JUNGHOON', 'M', '61', '부산', '학사', '28.9', '부산 남구 갑', '선거', '4');
INSERT INTO DB066_Congressman VALUES (152, 'Liberty Korea Party', 'KIM JONGSEOK', 'M', '63', '서울', '박사', '68.2', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (153, 'Liberty Korea Party', 'KIM JINTAE', 'M', '54', '강원 춘천시', '학사', '27.8', '강원 춘천시', '선거', '2');
INSERT INTO DB066_Congressman VALUES (154, 'Liberty Korea Party', 'KIM TAEHEUM', 'M', '55', NUll, '석사', '6.3', '충남 보령시서천군', '선거', '2');
INSERT INTO DB066_Congressman VALUES (155, 'Liberty Korea Party', 'KIM HACKYONG', 'M', '67', '경기 안성시', '학사', '19.5', '경기 안성시', '선거', '3');
INSERT INTO DB066_Congressman VALUES (156, 'Liberty Korea Party', 'KIM HANPYO', 'M', '64', '경남 거제시', '박사', '-0.4', '경남 거제시', '선거', '2');
INSERT INTO DB066_Congressman VALUES (157, 'Liberty Korea Party', 'KIM HYUNAH', 'W', '49', '서울', '박사', '18.2', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (158, 'Liberty Korea Party', 'NA KYUNGWON', 'W', '55', '서울', '박사', '36.5', '서울 동작구 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (159, 'Liberty Korea Party', 'MOON JINKOOK', 'M', '69', NUll, NUll, '10.5', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (160, 'Liberty Korea Party', 'MIN KYUNGWOOK', 'M', '55', '인천', '석사', '21.4', '인천 연수구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (161, 'Liberty Korea Party', 'PARK DAECHUL', 'M', '57', '경남 진주시', '석사', '9.5', '경남 진주시 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (162, 'Liberty Korea Party', 'PARK DUKHYUM', 'M', '65', '충북 옥천군', '박사', '507.6', '충북 보은군옥천군영동군괴산군', '선거', '2');
INSERT INTO DB066_Congressman VALUES (163, 'Liberty Korea Party', 'BAK MAENGWOO', 'M', '67', '울산', '박사', '9.9', '울산 남구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (164, 'Liberty Korea Party', 'PARK MYUNGJAE', 'M', '71', '경북 포항시', '박사', '24.4', '경북 포항시남구울릉군', '선거', '2');
INSERT INTO DB066_Congressman VALUES (165, 'Liberty Korea Party', 'PARK SUNGJOONG', 'M', '60', '경남 남해군', '박사', '50.2', '서울 서초구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (166, 'Liberty Korea Party', 'PARK SOONJA', 'M', '60', NUll, '학사', '7.3', '경기 안산시단원구 을', '선거', '3');
INSERT INTO DB066_Congressman VALUES (167, 'Liberty Korea Party', 'PARK WANSU', 'M', '63', '경남 통영시', '박사', '16.1', '경남 창원시의창구', '선거', '1');
INSERT INTO DB066_Congressman VALUES (168, 'Liberty Korea Party', 'PARK CHANWOO', 'M', '59', '충남 천안시', '박사', '13.5', '충남 천안시 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (169, 'Liberty Korea Party', 'BAE DUKKWANG', 'M', '70', '경남 창원시', '박사', '61.2', '부산 해운대구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (170, 'Liberty Korea Party', 'BAEK SEUNGJOO', 'M', '57', '경북 구미시', '박사', '17.0', '경북 구미시 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (171, 'Liberty Korea Party', 'SUH CHUNGWON', 'M', '75', '충남 천안시', '학사', '4.9', '경기 화성시 갑', '선거', '8');
INSERT INTO DB066_Congressman VALUES (172, 'Liberty Korea Party', 'SUNG ILJONG', 'M', '55', '충남 서산시', '박사', '215.4', '충남 서산시태안군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (173, 'Liberty Korea Party', 'SONG SEOGJUN', 'M', '54', NUll, '박사', '7.8', '경기 이천시', '선거', '1');
INSERT INTO DB066_Congressman VALUES (174, 'Liberty Korea Party', 'SONG HEEKGYOUNG', 'W', '54', '부산', '석사', '28.5', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (175, 'Liberty Korea Party', 'SHIN BORA', 'W', '35', '광주', '학사', '1.4', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (176, 'Liberty Korea Party', 'SHIN SANGJIN', 'M', '62', '서울', '학사', '4.9', '경기 성남시중원구', '선거', '4');
INSERT INTO DB066_Congressman VALUES (177, 'Liberty Korea Party', 'SHIM JAECHEOL', 'M', '60', NUll, '박사', ' 57.5', '경기 안양시동안구 을', '선거', '5');
INSERT INTO DB066_Congressman VALUES (178, 'Liberty Korea Party', 'AHN SANGSOO', 'M', '72', '충남 태안군', '석사', '1.5', '인천 중구동구강화군옹진군', '선거', '3');
INSERT INTO DB066_Congressman VALUES (179, 'Liberty Korea Party', 'UM YONGSOO', 'M', '53', '경남 밀양시', '학사', '3.9', '경남 밀양시의령군함안군창녕군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (180, 'Liberty Korea Party', 'YEO SANGKYOO', 'M', '70', '경남 하동군', '학사', '61.9', '경남 사천시남해군하동군', '선거', '3');
INSERT INTO DB066_Congressman VALUES (181, 'Liberty Korea Party', 'YEOM DONGYEOL', 'M', '57', '강원 평창군', '박사', '17.1', '강원 태백시횡성군영월군평창군정선군', '선거', '2');
INSERT INTO DB066_Congressman VALUES (182, 'Liberty Korea Party', 'WON YOOCHUL', 'M', '56', '경기 평택시', '학사', '7.1', '경기 평택시 갑', '선거', '5');
INSERT INTO DB066_Congressman VALUES (183, 'Liberty Korea Party', 'YOO KIJUNE', 'M', '59', NUll, '석사', '35.0', '부산 서구동구', '선거', '4');
INSERT INTO DB066_Congressman VALUES (184, 'Liberty Korea Party', 'YOU MINBONG', 'M', '60', '대전', '박사', '9.8', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (185, 'Liberty Korea Party', 'YOO JAEJUNG', 'M', '62', NUll, '박사', '21.0', '부산 수영구', '선거', '3');
INSERT INTO DB066_Congressman VALUES (186, 'Liberty Korea Party', 'YOON SANGJICK', 'M', '62', '경북 경산시', '박사', '21.1', '부산 기장군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (187, 'Liberty Korea Party', 'YOON SANGHYUN', 'M', '56', '충남 청양군', '박사', '167.9', '인천 남구 을', '선거', '3');
INSERT INTO DB066_Congressman VALUES (188, 'Liberty Korea Party', 'YOON YOUNGSEOK', 'M', '54', '경남 양산시', '석사', '4.8', '경남 양산시 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (189, 'Liberty Korea Party', 'YUN JAEOK', 'M', '57', '경남 합천군', '박사', '16.4', '대구 달서구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (190, 'Liberty Korea Party', 'YOON JONGPIL', 'M', '65', NUll, '석사', '15.1', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (191, 'Liberty Korea Party', 'YOON HANHONG', 'M', '56', '경남 창원시', '박사', '15.5', '경남 창원시마산회원구', '선거', '1');
INSERT INTO DB066_Congressman VALUES (192, 'Liberty Korea Party', 'LEE KOONHYON', 'M', '66', '경남 통영시', '박사', '14.7', '경남 통영시고성군', '선거', '4');
INSERT INTO DB066_Congressman VALUES (193, 'Liberty Korea Party', 'LEE MANHEE', 'M', '55', '경북 영천시', '석사', '17.8', '경북 영천시청도군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (194, 'Liberty Korea Party', 'LEE MYOUNGSU', 'M', '63', '충남 아산시', '박사', '3.6', '충남 아산시 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (195, 'Liberty Korea Party', 'LEE YANGSOO', 'M', '51', NUll, '학사', '9.8', '강원 속초시고성군양양군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (196, 'Liberty Korea Party', 'YI WANYOUNG', 'M', '61', '경북 성주군', '박사', '55.7', '경북 고령군성주군칠곡군', '선거', '2');
INSERT INTO DB066_Congressman VALUES (197, 'Liberty Korea Party', 'LEE WOOHYUN', 'M', '61', '경기 용인시', '석사', '10.2', '경기 용인시 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (198, 'Liberty Korea Party', 'LEE EUNKWON', 'M', '61', NUll, '석사', '4.8', '대전 중구', '선거', '1');
INSERT INTO DB066_Congressman VALUES (199, 'Liberty Korea Party', 'LEE EUNJAE', 'W', '66', NUll, '박사', '84.7', '서울 강남구 병', '선거', '2');
INSERT INTO DB066_Congressman VALUES (200, 'Liberty Korea Party', 'LEE JANGWOO', 'M', '53', '충남 청양군', '박사', '10.4', '대전 동구', '선거', '2');
INSERT INTO DB066_Congressman VALUES (201, 'Liberty Korea Party', 'LEE JONGKOO', 'M', '68', NUll, '석사', '16.5', '서울 강남구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (202, 'Liberty Korea Party', 'LEE JONGMYEONG', 'M', '59', '경북 청도군', '석사', '10.6', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (203, 'Liberty Korea Party', 'LEE JONGBAE', 'M', '61', '충북 충주시', '석사', '15.5', '충북 충주시', '선거', '2');
INSERT INTO DB066_Congressman VALUES (204, 'Liberty Korea Party', 'LEE JUYOUNG', 'M', '67', '경남 마산시', '석사', '17.2', '경남 창원시마산합포구', '선거', '5');
INSERT INTO DB066_Congressman VALUES (205, 'Liberty Korea Party', 'LEE JINBOK', 'M', '61', '부산', '석사', '10.6', '부산 동래구', '선거', '3');
INSERT INTO DB066_Congressman VALUES (206, 'Liberty Korea Party', 'LEE CHEIK', 'M', '63', NUll, '박사', '10.3', '울산 남구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (207, 'Liberty Korea Party', 'LEE CHULGYU', 'M', '61', '강원 동해시', '석사', '21.2', '강원 동해시삼척시', '선거', '1');
INSERT INTO DB066_Congressman VALUES (208, 'Liberty Korea Party', 'LEE CHEOLWOO', 'M', '63', '경북 김천시', '석사', '17.3', '경북 김천시', '선거', '3');
INSERT INTO DB066_Congressman VALUES (209, 'Liberty Korea Party', 'LEE HUNSEUNG', 'M', '55', '부산', '박사', '15.9', '부산 부산진구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (210, 'Liberty Korea Party', 'LEE HYUNJAE', 'M', '69', '충북 보은군', '박사', '9.1', '경기 하남시', '선거', '2');
INSERT INTO DB066_Congressman VALUES (211, 'Liberty Korea Party', 'LIM LEEJA', 'W', '54', '경북 예천군', '석사', '5.1', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (212, 'Liberty Korea Party', 'JANG SEOKCHUN', 'M', '61', NUll, '고졸', '11.1', '경북 구미시 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (213, 'Liberty Korea Party', 'CHANG JEWON', 'M', '51', '부산', '석사', '17.8', '부산 사상구', '선거', '2');
INSERT INTO DB066_Congressman VALUES (214, 'Liberty Korea Party', 'JUN HEEKYUNG', 'W', '43', NUll, '학사', '2.1', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (215, 'Liberty Korea Party', 'JEONG KABYOON', 'M', '68', '울산', '박사', '9.1', '울산 중구', '선거', '5');
INSERT INTO DB066_Congressman VALUES (216, 'Liberty Korea Party', 'CHEONG YANGSEOG', 'M', '60', '전남 보성군', '석사', '13.2', '서울 강북구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (217, 'Liberty Korea Party', 'JEONG YONGKI', 'M', '56', '충북 옥천군', '석사', '23.8', '대전 대덕구', '선거', '2');
INSERT INTO DB066_Congressman VALUES (218, 'Liberty Korea Party', 'CHUNG WOOTAIK', 'M', '65', '부산', '박사', '67.4', '충북 청주시상당구', '선거', '4');
INSERT INTO DB066_Congressman VALUES (219, 'Liberty Korea Party', 'JUNG YOUSUB', 'M', '64', '인천', '석사', '56.8', '인천 부평구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (220, 'Liberty Korea Party', 'CHONG JONGSUP', 'M', '61', '경북 경주시', '박사', '27.7', '대구 동구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (221, 'Liberty Korea Party', 'CHUNG JINSUK', 'M', '58', NUll, '학사', '59.8', '충남 공주시부여군청양군', '선거', '4');
INSERT INTO DB066_Congressman VALUES (222, 'Liberty Korea Party', 'CHOUNG TAEOK', 'M', '57', NUll, '박사', '11.9', '대구 북구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (223, 'Liberty Korea Party', 'CHO KYOUNGTAE', 'M', '50', NUll, '박사', '8.3', '부산 사하구 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (224, 'Liberty Korea Party', 'CHO HOONHYUN', 'M', '65', '전남 목포시', '박사', '24.9', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (225, 'Liberty Korea Party', 'JOO KWANGDEOK', 'M', '58', NUll, '학사', '14.3', '경기 남양주시 병', '선거', '2');
INSERT INTO DB066_Congressman VALUES (226, 'Liberty Korea Party', 'JOO HOYOUNG', 'M', '58', '경북 울진군', '박사', '24.6', '대구 수성구 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (227, 'Liberty Korea Party', 'CHOI KYUNGHWAN', 'M', '63', '경북 경산시', '박사', '50.3', '경북 경산시', '선거', '4');
INSERT INTO DB066_Congressman VALUES (228, 'Liberty Korea Party', 'CHOI GYOIL', 'M', '56', '경북 영주시', '학사', '201.3', '경북 영주시문경시예천군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (229, 'Liberty Korea Party', 'CHOI YEONHYE', 'M', '62', '충북 영동군', '박사', '23.2', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (230, 'Liberty Korea Party', 'CHOO KYUNGHO', 'M', '58', '대구 달성군', '석사', '20.1', '대구 달성군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (231, 'Liberty Korea Party', 'HAN SUNKYO', 'M', '59', '서울', '석사', '14.9', '경기 용인시 병', '선거', '4');
INSERT INTO DB066_Congressman VALUES (232, 'Liberty Korea Party', 'HAM JINGYU', 'M', '59', '경기 시흥시', '박사', '4.2', '경기 시흥시 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (233, 'Liberty Korea Party', 'HONG MOONJONG', 'M', '63', '경기 양주시', '박사', '75.2', '경기 의정부시 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (234, 'Liberty Korea Party', 'HONG MOONPYO', 'M', '71', '충남 홍성군', '석사', '11.3', '충남 홍성군예산군', '선거', '3');
INSERT INTO DB066_Congressman VALUES (235, 'Liberty Korea Party', 'HONG ILPYO', 'M', '62', '충남 홍성군', '석사', '46.3', '인천 남구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (236, 'Liberty Korea Party', 'HONG CHULHO', 'M', '60', '경기 김포시', NUll, '58.6', '경기 김포시 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (237, 'Liberty Korea Party', 'HWANG YOUNGCHEUL', 'M', '53', '강원 홍천군', '학사', '6.6', '강원 홍천군철원군화천군양구군인제군', '선거', '3');
INSERT INTO DB066_Congressman VALUES (238, 'The Peoples Party', 'KWON EUNHEE', 'W', '44', '광주', '석사', '8.3', '광주 광산구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (239, 'The Peoples Party', 'KIM KYUNGJIN', 'M', '52', NUll, '석사', '7.7', '광주 북구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (240, 'The Peoples Party', 'KIM KWANYOUNG', 'M', '49', '전북 군산시', '석사', '16.5', '전북 군산시', '선거', '2');
INSERT INTO DB066_Congressman VALUES (241, 'The Peoples Party', 'KIM KWANGSOO', 'M', '60', NUll, '석사', '2.6', '전북 전주시 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (242, 'The Peoples Party', 'KIM DONGCHEOL', 'M', '63', '광주', '학사', '23.4', '광주 광산구 갑', '선거', '4');
INSERT INTO DB066_Congressman VALUES (243, 'The Peoples Party', 'KIM SAMHWA', 'W', '56', '충남 보령시', '석사', '85.7', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (244, 'The Peoples Party', 'KIM SONGSIK', 'M', '60', '부산', '학사', '2.9', '서울 관악구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (245, 'The Peoples Party', 'KIM SUMIN', 'W', '32', NUll, '학사', '0.3', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (246, 'The Peoples Party', 'KIM JONGHOE', 'M', '53', '전북 김제시', '박사', '6.5', '전북 김제시부안군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (247, 'The Peoples Party', 'KIM JOONGRO', 'M', '68', NUll, '석사', '0.5', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (248, 'The Peoples Party', 'PARK SUNSOOK', 'W', '58', '경기 포천시', '석사', '8.4', NUll, '비례대표', '2');
INSERT INTO DB066_Congressman VALUES (249, 'The Peoples Party', 'PARK JOOSUN', 'M', '69', '전남 보성군', '석사', '17.6', '광주 동구남구 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (250, 'The Peoples Party', 'PARK JOOHYUN', 'W', '55', '전북 군산시', '학사', '43.5', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (251, 'The Peoples Party', 'PARK JOONYUNG', 'M', '72', '전남 영암군', '박사', '10.2', '전남 영암군무안군신안군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (252, 'The Peoples Party', 'PARK JIEWON', 'M', '76', '전남 진도군', '박사', '11.7', '전남 목포시', '선거', '4');
INSERT INTO DB066_Congressman VALUES (253, 'The Peoples Party', 'SON KUMJU', 'M', '47', NUll, '석사', '8.1', '전남 나주시화순군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (254, 'The Peoples Party', 'SONG KISEOK', 'M', '55', '전남 고흥군', '학사', '6.6', '광주 서구 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (255, 'The Peoples Party', 'SHIN YONGHYEON', 'W', '57', NUll, '박사', '58.9', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (256, 'The Peoples Party', 'OH SEJUNG', 'M', '65', '서울', '박사', '41.6', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (257, 'The Peoples Party', 'YOU SUNGYOP', 'M', '58', '전북 정읍시', '학사', '8.8', '전북 정읍시고창군', '선거', '3');
INSERT INTO DB066_Congressman VALUES (258, 'The Peoples Party', 'YOON YOUNGIL', 'M', '61', '전남 해남군', '박사', '16.8', '전남 해남군완도군진도군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (259, 'The Peoples Party', 'LEE DONGSUP', 'M', '62', '전남 고흥군', '박사', '12.7', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (260, 'The Peoples Party', 'LEE SANGDON', 'M', '67', '부산', '박사', '19.5', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (261, 'The Peoples Party', 'LEE UNJU', 'W', '46', '부산', '석사', '25.3', '경기 광명시 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (262, 'The Peoples Party', 'LEE YONGJU', 'M', '50', NUll, '석사', '16.2', '전남 여수시 갑', '선거', '1');
INSERT INTO DB066_Congressman VALUES (263, 'The Peoples Party', 'LEE YONGHO', 'M', '58', '전북 남원시', '학사', '15.1', '전북 남원시임실군순창군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (264, 'The Peoples Party', 'LEE CHANYEOL', 'M', '59', '경기 화성시', '석사', '9.4', '경기 수원시 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (265, 'The Peoples Party', 'LEE TAEKYU', 'M', '54', '경기 양평군', '석사', '6.4', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (266, 'The Peoples Party', 'CHANG BYOUNGWAN', 'M', '66', '전남 나주시', '박사', '76.4', '광주 동구남구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (267, 'The Peoples Party', 'CHANG JUNGSOOK', 'W', '66', NUll, '석사', '1.4', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (268, 'The Peoples Party', 'CHUNG DONGYOUNG', 'M', '65', '전북 순창군', '석사', '11.4', '전북 전주시 병', '선거', '4');
INSERT INTO DB066_Congressman VALUES (269, 'The Peoples Party', 'JEONG INHWA', 'M', '61', '전남 광양시', '석사', '15.8', '전남 광양시곡성군구례군', '선거', '1');
INSERT INTO DB066_Congressman VALUES (270, 'The Peoples Party', 'CHO BAESOOK', 'W', '62', '전북 익산시', '석사', '17.6', '전북 익산시 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (271, 'The Peoples Party', 'JOO SEUNGYONG', 'M', '66', '전남 고흥군', '박사', '50.8', '전남 여수시 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (272, 'The Peoples Party', 'CHAE YIBAI', 'M', '43', '전북 군산시', '석사', '5.3', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (273, 'The Peoples Party', 'CHUN JUNGBAE', 'M', '64', '전남 신안군', '석사', '7.7', '광주 서구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (274, 'The Peoples Party', 'CHOI GYUNGHWAN', 'M', '59', '전남 장성군', '학사', '2.3', '광주 북구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (275, 'The Peoples Party', 'CHOI DOJA', 'W', '63', NUll, '석사', '6.3', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (276, 'The Peoples Party', 'CHOI MYUNGGHIL', 'M', '57', '대전', '석사', '14.6', '서울 송파구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (277, 'The Peoples Party', 'HWANG JUHONG', 'M', '66', '전남 강진군', '박사', '27.8', '전남 고흥군보성군장흥군강진군', '선거', '2');
INSERT INTO DB066_Congressman VALUES (278, 'Bareun Party', 'KIM SEYEON', 'M', '46', NUll, '학사', '1558.8', '부산 금정구', '선거', '3');
INSERT INTO DB066_Congressman VALUES (279, 'Bareun Party', 'PARK INSOOK', 'W', '70', NUll, '학사', '18.2', '서울 송파구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (280, 'Bareun Party', 'OH SHINHWAN', 'M', '47', NUll, '석사', '32.6', '서울 관악구 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (281, 'Bareun Party', 'YOO SEONGMIN', 'M', '60', '대구', '박사', '48.3', '대구 동구 을', '선거', '4');
INSERT INTO DB066_Congressman VALUES (282, 'Bareun Party', 'YU EUIDONG', 'M', '47', '경기 평택시', '석사', '6.2', '경기 평택시 을', '선거', '2');
INSERT INTO DB066_Congressman VALUES (283, 'Bareun Party', 'LEE HAGJAE', 'M', '54', NUll, '박사', '43.6', '인천 서구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (284, 'Bareun Party', 'LEE HYEHOON', 'W', '54', NUll, '박사', '65.9', '서울 서초구 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (285, 'Bareun Party', 'CHOUNG BYOUNGGUG', 'M', '60', NUll, '박사', '6.5', '경기 여주시양평군', '선거', '5');
INSERT INTO DB066_Congressman VALUES (286, 'Bareun Party', 'JEONG WOON CHUN', 'M', '64', '전북 고창군', '박사', '21.3', '전북 전주시 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (287, 'Bareun Party', 'JI SANGWUK', 'M', '53', '서울', '박사', '55.8', '서울 종구성동구 을', '선거', '1');
INSERT INTO DB066_Congressman VALUES (288, 'Bareun Party', 'HA TAEKEUNG', 'M', '50', '부산', '박사', '8.2', '부산 해운대구 갑', '선거', '2');
INSERT INTO DB066_Congressman VALUES (289, 'Progressive Justice Party', 'KIM JONGDAE', 'M', '52', '충북 제천시', '학사', '6.0', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (290, 'Progressive Justice Party', 'ROH HOECHAN', 'M', '62', '부산', '학사', '10.1', '경남 창원시성산구', '선거', '3');
INSERT INTO DB066_Congressman VALUES (291, 'Progressive Justice Party', 'SIM SANGJEUNG', 'W', '59', '경기 파주시', '학사', '3.5', '경기 고양시 갑', '선거', '3');
INSERT INTO DB066_Congressman VALUES (292, 'Progressive Justice Party', 'YOUN SOHA', 'M', '57', '전남 해남군', '학사', '3.1', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (293, 'Progressive Justice Party', 'LEE JEONGMI', 'W', '52', '부산', NUll, '2.8', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (294, 'Progressive Justice Party', 'CHU HYESEON', 'W', '47', NUll, NUll, '1.9', NUll, '비례대표', '1');
INSERT INTO DB066_Congressman VALUES (295, 'New Peoples Political Party', 'KIM JONGHOON', 'M', '54', '경북 경주시', '학사', '1.6', '울산 동구', '선거', '1');
INSERT INTO DB066_Congressman VALUES (296, 'New Peoples Political Party', 'YOON JONGO', 'M', '55', '경남 합천군', '석사', '3.2', '울산 북구', '선거', '1');
INSERT INTO DB066_Congressman VALUES (297, 'Korean Patriots Party', 'CHO WONJIN', 'M', '59', '대구', '석사', '5.6', '대구 달서구 병', '선거', '3');
INSERT INTO DB066_Congressman VALUES (298, 'Independent', 'LEE JUNGHYUN', 'M', '60', '전남 곡성군', '학사', '6.1', '전남 순천시', '선거', '3');
INSERT INTO DB066_Congressman VALUES (299, 'Independent', 'CHUNG SYEKYUN', 'M', '68', '전북 진안군', '박사', '40.4', '서울 종로구', '선거', '6');
INSERT INTO DB066_Provincial_Governor VALUES (300, 'The Minjoo Party of Korea', 'PARK WONSOON', 'M', '62', '경남 창녕군', '학사', '-5.5', '서울특별시', '2', '특별시');
INSERT INTO DB066_Provincial_Governor VALUES (301, 'Liberty Korea Party', 'SEO BYUNGSOO', 'M', '66', '울산', '박사', '44.0', '부산광역시', '4', '광역시');
INSERT INTO DB066_Provincial_Governor VALUES (302, 'Liberty Korea Party', 'KWON YOUNGJIN', 'M', '56', '경북 안동시', '박사', '16.7', '대구광역시', '2', '광역시');
INSERT INTO DB066_Provincial_Governor VALUES (303, 'Liberty Korea Party', 'YOO JUNGBOK', 'M', '61', '인천', '박사', '8.8', '인천광역시', '6', '광역시');
INSERT INTO DB066_Provincial_Governor VALUES (304, 'The Minjoo Party of Korea', 'YOON JANGHYUN', 'M', '69', '광주', '박사', '8.2', '광주광역시', '1', '광역시');
INSERT INTO DB066_Provincial_Governor VALUES (305, 'The Minjoo Party of Korea', 'KWON SUNTAEK', 'M', '63', '대전', '박사', '36.1', '대전광역시', '3', '광역시');
INSERT INTO DB066_Provincial_Governor VALUES (306, 'Liberty Korea Party', 'KIM KIHYUN', 'M', '59', '울산', '석사', '71.8', '울산광역시', '4', '광역시');
INSERT INTO DB066_Provincial_Governor VALUES (307, 'The Minjoo Party of Korea', 'LEE CHUNHEE', 'M', '63', '전북 고창군', '박사', '37.2', '세종특별자치시', '1', '특별자치시');
INSERT INTO DB066_Provincial_Governor VALUES (308, 'Bareun Party', 'NAM KYUNGPIL', 'M', '53', '경기 용인시', '석사', '40.7', '경기도', '5', '도');
INSERT INTO DB066_Provincial_Governor VALUES (309, 'The Minjoo Party of Korea', 'CHOI MOONSOON', 'M', '62', '강원 춘천시', '석사', '14.4', '강원도', '3', '도');
INSERT INTO DB066_Provincial_Governor VALUES (310, 'The Minjoo Party of Korea', 'LEE SIJONG', 'M', '71', '충북 충주시', '학사', '14.1', '충청북도', '6', '도');
INSERT INTO DB066_Provincial_Governor VALUES (311, 'The Minjoo Party of Korea', 'AHN HEEJUNG', 'M', '53', '충남 논산시', '학사', '9.8', '충청남도', '2', '도');
INSERT INTO DB066_Provincial_Governor VALUES (312, 'The Minjoo Party of Korea', 'SONG HAJIN', 'M', '66', '전북 김제시', '박사', '13.8', '전라북도', '3', '도');
INSERT INTO DB066_Provincial_Governor VALUES (313, 'The Minjoo Party of Korea', 'LEE NAKYEON', 'M', '66', '전남 영광군', '학사', '15.2', '전라남도', '5', '도');
INSERT INTO DB066_Provincial_Governor VALUES (314, 'Liberty Korea Party', 'KIM KWANYONG', 'M', '76', '경북 구미시', '석사', '15.3', '경상북도', '6', '도');
INSERT INTO DB066_Provincial_Governor VALUES (315, 'Liberty Korea Party', 'HONG JUNPYO', 'M', '64', '경남 창녕군', '학사', '25.5', '경상남도', '6', '도');
INSERT INTO DB066_Provincial_Governor VALUES (316, 'Bareun Party', 'WON HEERYONG', 'M', '54', '제주 서귀포시', '석사', '16.2', '제주특별자치도', '4', '특별자치도');

INSERT INTO DB066_University VALUES (1, '서울대학교');
INSERT INTO DB066_University VALUES (2, '서울대학교');
INSERT INTO DB066_University VALUES (2, '도쿄대학교');
INSERT INTO DB066_University VALUES (3, '건국대학교');
INSERT INTO DB066_University VALUES (4, '서울대학교');
INSERT INTO DB066_University VALUES (6, '고려대학교');
INSERT INTO DB066_University VALUES (7, '서울대학교');
INSERT INTO DB066_University VALUES (7, '코넬대학교');
INSERT INTO DB066_University VALUES (8, '성균관대학교');
INSERT INTO DB066_University VALUES (9, '서울대학교');
INSERT INTO DB066_University VALUES (10, '성균관대학교');
INSERT INTO DB066_University VALUES (10, '고려대학교');
INSERT INTO DB066_University VALUES (10, '한국기술교육대학교');
INSERT INTO DB066_University VALUES (11, '동아대학교');
INSERT INTO DB066_University VALUES (12, '고려대학교');
INSERT INTO DB066_University VALUES (13, '서울대학교');
INSERT INTO DB066_University VALUES (13, '카이스트');
INSERT INTO DB066_University VALUES (14, '경희대학교');
INSERT INTO DB066_University VALUES (15, '한양대학교');
INSERT INTO DB066_University VALUES (15, '고려대학교');
INSERT INTO DB066_University VALUES (15, '국민대학교');
INSERT INTO DB066_University VALUES (16, '서울대학교');
INSERT INTO DB066_University VALUES (16, '연세대학교');
INSERT INTO DB066_University VALUES (17, '이화여자대학교');
INSERT INTO DB066_University VALUES (18, '서울대학교');
INSERT INTO DB066_University VALUES (19, '한국방송통신대학교');
INSERT INTO DB066_University VALUES (19, '서강대학교');
INSERT INTO DB066_University VALUES (20, '중앙대학교');
INSERT INTO DB066_University VALUES (21, '고려대학교');
INSERT INTO DB066_University VALUES (22, '베이징대학교');
INSERT INTO DB066_University VALUES (22, '서강대학교');
INSERT INTO DB066_University VALUES (23, '서울대학교');
INSERT INTO DB066_University VALUES (23, '한국방송통신대학교');
INSERT INTO DB066_University VALUES (23, '브리스톨대학교');
INSERT INTO DB066_University VALUES (24, '서울대학교');
INSERT INTO DB066_University VALUES (25, '서울대학교');
INSERT INTO DB066_University VALUES (25, '위스콘신대학교');
INSERT INTO DB066_University VALUES (26, '한양대학교');
INSERT INTO DB066_University VALUES (26, '한밭대학교');
INSERT INTO DB066_University VALUES (27, '경희대학교');
INSERT INTO DB066_University VALUES (28, '서울대학교');
INSERT INTO DB066_University VALUES (28, '럿커스대학교');
INSERT INTO DB066_University VALUES (29, '부산대학교');
INSERT INTO DB066_University VALUES (30, '서울대학교');
INSERT INTO DB066_University VALUES (30, '경북대학교');
INSERT INTO DB066_University VALUES (31, '연세대학교');
INSERT INTO DB066_University VALUES (32, '세종대학교');
INSERT INTO DB066_University VALUES (32, '성공회대학교');
INSERT INTO DB066_University VALUES (33, '중앙대학교');
INSERT INTO DB066_University VALUES (33, '동국대학교');
INSERT INTO DB066_University VALUES (33, '한국방송통신대학교');
INSERT INTO DB066_University VALUES (34, '충북대학교');
INSERT INTO DB066_University VALUES (34, '충남대학교');
INSERT INTO DB066_University VALUES (35, '서울대학교');
INSERT INTO DB066_University VALUES (36, '성균관대학교');
INSERT INTO DB066_University VALUES (37, '부산대학교');
INSERT INTO DB066_University VALUES (38, '서울대학교');
INSERT INTO DB066_University VALUES (38, '일리노이대학교');
INSERT INTO DB066_University VALUES (39, '고려대학교');
INSERT INTO DB066_University VALUES (39, '동국대학교');
INSERT INTO DB066_University VALUES (40, '고려대학교');
INSERT INTO DB066_University VALUES (40, '웨일즈대학교');
INSERT INTO DB066_University VALUES (41, '한밭대학교');
INSERT INTO DB066_University VALUES (41, '연세대학교');
INSERT INTO DB066_University VALUES (42, '성균관대학교');
INSERT INTO DB066_University VALUES (42, '한양대학교');
INSERT INTO DB066_University VALUES (42, '충남대학교');
INSERT INTO DB066_University VALUES (43, '경희대학교');
INSERT INTO DB066_University VALUES (43, '서강대학교');
INSERT INTO DB066_University VALUES (44, '성균관대학교');
INSERT INTO DB066_University VALUES (45, '성균관대학교');
INSERT INTO DB066_University VALUES (46, '부산외국어대학교');
INSERT INTO DB066_University VALUES (46, '중앙대학교');
INSERT INTO DB066_University VALUES (47, '서울대학교');
INSERT INTO DB066_University VALUES (47, '중국우한대학교');
INSERT INTO DB066_University VALUES (48, '서울대학교');
INSERT INTO DB066_University VALUES (49, '서울대학교');
INSERT INTO DB066_University VALUES (49, '인하대학교');
INSERT INTO DB066_University VALUES (50, '경희대학교');
INSERT INTO DB066_University VALUES (51, '경기대학교');
INSERT INTO DB066_University VALUES (52, '고려대학교');
INSERT INTO DB066_University VALUES (53, '연세대학교');
INSERT INTO DB066_University VALUES (53, '펜실베이니아대학교');
INSERT INTO DB066_University VALUES (54, '이화여자대학교');
INSERT INTO DB066_University VALUES (55, '서울대학교');
INSERT INTO DB066_University VALUES (56, '고려대학교');
INSERT INTO DB066_University VALUES (57, '성균관대학교');
INSERT INTO DB066_University VALUES (58, '홍익대학교');
INSERT INTO DB066_University VALUES (59, '서울대학교');
INSERT INTO DB066_University VALUES (60, '한국방송통신대학교');
INSERT INTO DB066_University VALUES (61, '연세대학교');
INSERT INTO DB066_University VALUES (62, '서울대학교');
INSERT INTO DB066_University VALUES (62, '고려대학교');
INSERT INTO DB066_University VALUES (63, '경희대학교');
INSERT INTO DB066_University VALUES (63, '서울대학교');
INSERT INTO DB066_University VALUES (64, '고려대학교');
INSERT INTO DB066_University VALUES (65, '상지대학교');
INSERT INTO DB066_University VALUES (66, '서울대학교');
INSERT INTO DB066_University VALUES (66, '모나쉬대학교');
INSERT INTO DB066_University VALUES (67, '성균관대학교');
INSERT INTO DB066_University VALUES (68, '서울대학교');
INSERT INTO DB066_University VALUES (68, '북콜로라도주립대학교');
INSERT INTO DB066_University VALUES (69, '연세대학교');
INSERT INTO DB066_University VALUES (69, '전북대학교');
INSERT INTO DB066_University VALUES (70, '성균관대학교');
INSERT INTO DB066_University VALUES (70, '단국대학교');
INSERT INTO DB066_University VALUES (71, '빈대학교'  );
INSERT INTO DB066_University VALUES (72, '제주대학교');
INSERT INTO DB066_University VALUES (73, '서울대학교');
INSERT INTO DB066_University VALUES (74, '연세대학교');
INSERT INTO DB066_University VALUES (75, '연세대학교');
INSERT INTO DB066_University VALUES (76, '서울대학교');
INSERT INTO DB066_University VALUES (77, '제주대학교');
INSERT INTO DB066_University VALUES (78, '연세대학교');
INSERT INTO DB066_University VALUES (79, '이화여자대학교');
INSERT INTO DB066_University VALUES (79, '숭실대학교');
INSERT INTO DB066_University VALUES (79, '한양대학교');
INSERT INTO DB066_University VALUES (80, '성균관대학교');
INSERT INTO DB066_University VALUES (80, '이화여자대학교');
INSERT INTO DB066_University VALUES (81, '한양대학교');
INSERT INTO DB066_University VALUES (82, '서울대학교');
INSERT INTO DB066_University VALUES (83, '연세대학교');
INSERT INTO DB066_University VALUES (83, '경기대학교');
INSERT INTO DB066_University VALUES (84, '전남대학교');
INSERT INTO DB066_University VALUES (85, '충남대학교');
INSERT INTO DB066_University VALUES (86, '서울대학교');
INSERT INTO DB066_University VALUES (87, '서울대학교');
INSERT INTO DB066_University VALUES (87, '연세대학교');
INSERT INTO DB066_University VALUES (88, '성균관대학교');
INSERT INTO DB066_University VALUES (89, '고려대학교');
INSERT INTO DB066_University VALUES (90, '고려대학교');
INSERT INTO DB066_University VALUES (91, '경북대학교');
INSERT INTO DB066_University VALUES (91, '연세대학교');
INSERT INTO DB066_University VALUES (92, '서울대학교');
INSERT INTO DB066_University VALUES (93, '고려대학교');
INSERT INTO DB066_University VALUES (94, '한양대학교');
INSERT INTO DB066_University VALUES (94, '원광대학교');
INSERT INTO DB066_University VALUES (95, '전남대학교');
INSERT INTO DB066_University VALUES (96, '서울대학교');
INSERT INTO DB066_University VALUES (97, '서강대학교');
INSERT INTO DB066_University VALUES (98, '이화여자대학교');
INSERT INTO DB066_University VALUES (99, '한양대학교');
INSERT INTO DB066_University VALUES (100, '동국대학교');
INSERT INTO DB066_University VALUES (101, '고려대학교');
INSERT INTO DB066_University VALUES (102, '서울대학교');
INSERT INTO DB066_University VALUES (102, '고려대학교');
INSERT INTO DB066_University VALUES (103, '영남대학교');
INSERT INTO DB066_University VALUES (103, '성균관대학교');
INSERT INTO DB066_University VALUES (104, '서울대학교');
INSERT INTO DB066_University VALUES (105, '고려대학교');
INSERT INTO DB066_University VALUES (106, '중앙대학교');
INSERT INTO DB066_University VALUES (106, '강남대학교');
INSERT INTO DB066_University VALUES (107, '덕성여자대학교');
INSERT INTO DB066_University VALUES (108, '충남대학교');
INSERT INTO DB066_University VALUES (109, '서울대학교');
INSERT INTO DB066_University VALUES (110, '연세대학교');
INSERT INTO DB066_University VALUES (111, '성균관대학교');
INSERT INTO DB066_University VALUES (112, '서울대학교');
INSERT INTO DB066_University VALUES (112, '워싱턴주립대학교');
INSERT INTO DB066_University VALUES (113, '서울대학교');
INSERT INTO DB066_University VALUES (113, '조지아대학교');
INSERT INTO DB066_University VALUES (114, '부산대학교');
INSERT INTO DB066_University VALUES (115, '한양대학교');
INSERT INTO DB066_University VALUES (115, '연세대학교');
INSERT INTO DB066_University VALUES (116, '경찰대학교');
INSERT INTO DB066_University VALUES (116, '엑시터대학교');
INSERT INTO DB066_University VALUES (117, '부산대학교');
INSERT INTO DB066_University VALUES (117, '노팅엄대학교');
INSERT INTO DB066_University VALUES (118, '동국대학교');
INSERT INTO DB066_University VALUES (119, '고려대학교');
INSERT INTO DB066_University VALUES (120, '한양대학교');
INSERT INTO DB066_University VALUES (121, '숭실대학교');
INSERT INTO DB066_University VALUES (121, '연세대학교');
INSERT INTO DB066_University VALUES (122, '서울대학교');
INSERT INTO DB066_University VALUES (122, '성균관대학교');
INSERT INTO DB066_University VALUES (122, '경원대학교');
INSERT INTO DB066_University VALUES (123, '연세대학교');
INSERT INTO DB066_University VALUES (124, '한국외국어대학교');
INSERT INTO DB066_University VALUES (125, '서울대학교');
INSERT INTO DB066_University VALUES (125, '아메리칸대학교');
INSERT INTO DB066_University VALUES (126, '서울대학교');
INSERT INTO DB066_University VALUES (127, '고려대학교');
INSERT INTO DB066_University VALUES (127, '서울대학교');
INSERT INTO DB066_University VALUES (128, '성균관대학교');
INSERT INTO DB066_University VALUES (129, '서울대학교');
INSERT INTO DB066_University VALUES (129, '일리노이주립대학교');
INSERT INTO DB066_University VALUES (129, '중앙대학교');
INSERT INTO DB066_University VALUES (130, '중앙대학교');
INSERT INTO DB066_University VALUES (131, '영남대학교');
INSERT INTO DB066_University VALUES (131, '서울대학교');
INSERT INTO DB066_University VALUES (131, '하버드대학교');
INSERT INTO DB066_University VALUES (131, '경희대학교');
INSERT INTO DB066_University VALUES (132, '인제대학교');
INSERT INTO DB066_University VALUES (133, '경희대학교');
INSERT INTO DB066_University VALUES (134, '동아대학교');
INSERT INTO DB066_University VALUES (135, '건국대학교');
INSERT INTO DB066_University VALUES (135, '한양대학교');
INSERT INTO DB066_University VALUES (136, '한양대학교');
INSERT INTO DB066_University VALUES (136, '부경대학교');
INSERT INTO DB066_University VALUES (136, '건국대학교');
INSERT INTO DB066_University VALUES (137, '서울대학교');
INSERT INTO DB066_University VALUES (137, '오리건대학교');
INSERT INTO DB066_University VALUES (138, '영남대학교');
INSERT INTO DB066_University VALUES (138, '동국대학교');
INSERT INTO DB066_University VALUES (138, '용인대학교');
INSERT INTO DB066_University VALUES (139, '고려대학교');
INSERT INTO DB066_University VALUES (140, '고려대학교');
INSERT INTO DB066_University VALUES (141, '해군사관학교');
INSERT INTO DB066_University VALUES (141, '영국왕립학교');
INSERT INTO DB066_University VALUES (141, '경기대학교');
INSERT INTO DB066_University VALUES (141, '한남대학교');
INSERT INTO DB066_University VALUES (142, '강남대학교');
INSERT INTO DB066_University VALUES (142, '한양대학교');
INSERT INTO DB066_University VALUES (143, '서울대학교');
INSERT INTO DB066_University VALUES (143, '조지아대학교');
INSERT INTO DB066_University VALUES (143, '위스콘신매디슨대학교');
INSERT INTO DB066_University VALUES (144, '숙명여자대학교');
INSERT INTO DB066_University VALUES (145, '서울대학교');
INSERT INTO DB066_University VALUES (145, '노트르담대학교');
INSERT INTO DB066_University VALUES (146, '고려대학교');
INSERT INTO DB066_University VALUES (146, '성균관대학교');
INSERT INTO DB066_University VALUES (147, '서울대학교');
INSERT INTO DB066_University VALUES (148, '경상대학교');
INSERT INTO DB066_University VALUES (148, '서울대학교');
INSERT INTO DB066_University VALUES (149, '서울대학교');
INSERT INTO DB066_University VALUES (150, '이화여자대학교');
INSERT INTO DB066_University VALUES (150, '프랭클린피어스법과대학교');
INSERT INTO DB066_University VALUES (151, '한양대학교');
INSERT INTO DB066_University VALUES (151, '부경대학교');
INSERT INTO DB066_University VALUES (152, '서울대학교');
INSERT INTO DB066_University VALUES (152, '프린스턴대학교');
INSERT INTO DB066_University VALUES (153, '서울대학교');
INSERT INTO DB066_University VALUES (154, '건국대학교');
INSERT INTO DB066_University VALUES (154, '서강대학교');
INSERT INTO DB066_University VALUES (155, '중앙대학교');
INSERT INTO DB066_University VALUES (156, '한국외국어대학교');
INSERT INTO DB066_University VALUES (156, '연세대학교');
INSERT INTO DB066_University VALUES (157, '경원대학교');
INSERT INTO DB066_University VALUES (158, '서울대학교');
INSERT INTO DB066_University VALUES (160, '연세대학교');
INSERT INTO DB066_University VALUES (161, '연세대학교');
INSERT INTO DB066_University VALUES (162, '연세대학교');
INSERT INTO DB066_University VALUES (162, '게르첸국립사범대학교');
INSERT INTO DB066_University VALUES (162, '서울산업대학교');
INSERT INTO DB066_University VALUES (162, '한양대학교');
INSERT INTO DB066_University VALUES (163, '국민대학교');
INSERT INTO DB066_University VALUES (163, '동의대학교');
INSERT INTO DB066_University VALUES (163, '경남대학교');
INSERT INTO DB066_University VALUES (164, '연세대학교');
INSERT INTO DB066_University VALUES (164, '국립사회과학대학교');
INSERT INTO DB066_University VALUES (164, '용인대학교');
INSERT INTO DB066_University VALUES (164, '경북대학교');
INSERT INTO DB066_University VALUES (165, '성균관대학교');
INSERT INTO DB066_University VALUES (165, '서울대학교');
INSERT INTO DB066_University VALUES (165, '와세다대학교');
INSERT INTO DB066_University VALUES (166, '고려대학교');
INSERT INTO DB066_University VALUES (167, '한국방송통신대학교');
INSERT INTO DB066_University VALUES (167, '경남대학교');
INSERT INTO DB066_University VALUES (167, '창원대학교');
INSERT INTO DB066_University VALUES (168, '서울대학교');
INSERT INTO DB066_University VALUES (168, '인디애나대학교');
INSERT INTO DB066_University VALUES (168, '성균관대학교');
INSERT INTO DB066_University VALUES (169, '동아대학교');
INSERT INTO DB066_University VALUES (169, '부산대학교');
INSERT INTO DB066_University VALUES (169, '경성대학교');
INSERT INTO DB066_University VALUES (170, '부산대학교');
INSERT INTO DB066_University VALUES (170, '경북대학교');
INSERT INTO DB066_University VALUES (171, '중앙대학교');
INSERT INTO DB066_University VALUES (172, '고려대학교');
INSERT INTO DB066_University VALUES (172, '광운대학교');
INSERT INTO DB066_University VALUES (173, '서울대학교');
INSERT INTO DB066_University VALUES (173, '미주리대학교');
INSERT INTO DB066_University VALUES (174, '이화여자대학교');
INSERT INTO DB066_University VALUES (174, '아주대학교');
INSERT INTO DB066_University VALUES (174, '카이스트');
INSERT INTO DB066_University VALUES (175, '전북대학교');
INSERT INTO DB066_University VALUES (175, '연세대학교');
INSERT INTO DB066_University VALUES (176, '서울대학교');
INSERT INTO DB066_University VALUES (177, '서울대학교');
INSERT INTO DB066_University VALUES (177, '중앙대학교');
INSERT INTO DB066_University VALUES (178, '서울대학교');
INSERT INTO DB066_University VALUES (178, '트로이대학교');
INSERT INTO DB066_University VALUES (178, '한국방송통신대학교');
INSERT INTO DB066_University VALUES (178, '연세대학교');
INSERT INTO DB066_University VALUES (179, '연세대학교');
INSERT INTO DB066_University VALUES (180, '서울대학교');
INSERT INTO DB066_University VALUES (181, '국민대학교');
INSERT INTO DB066_University VALUES (182, '고려대학교');
INSERT INTO DB066_University VALUES (183, '서울대학교');
INSERT INTO DB066_University VALUES (183, '뉴욕대학교');
INSERT INTO DB066_University VALUES (184, '성균관대학교');
INSERT INTO DB066_University VALUES (184, '텍사스대학교');
INSERT INTO DB066_University VALUES (184, '오하이오주립대학교');
INSERT INTO DB066_University VALUES (185, '부산대학교');
INSERT INTO DB066_University VALUES (186, '서울대학교');
INSERT INTO DB066_University VALUES (186, '고려대학교');
INSERT INTO DB066_University VALUES (186, '위스콘신대학교');
INSERT INTO DB066_University VALUES (187, '서울대학교');
INSERT INTO DB066_University VALUES (187, '조지타운대학교');
INSERT INTO DB066_University VALUES (187, '조지워싱턴대학교');
INSERT INTO DB066_University VALUES (188, '성균관대학교');
INSERT INTO DB066_University VALUES (188, '듀크대학교');
INSERT INTO DB066_University VALUES (189, '경찰대학교');
INSERT INTO DB066_University VALUES (189, '연세대학교');
INSERT INTO DB066_University VALUES (189, '동국대학교');
INSERT INTO DB066_University VALUES (190, '국군간호사관학교');
INSERT INTO DB066_University VALUES (190, '성균관대학교');
INSERT INTO DB066_University VALUES (190, '동국대학교');
INSERT INTO DB066_University VALUES (191, '서울대학교');
INSERT INTO DB066_University VALUES (191, '듀크대학교');
INSERT INTO DB066_University VALUES (192, '고려대학교');
INSERT INTO DB066_University VALUES (193, '고려대학교');
INSERT INTO DB066_University VALUES (194, '성균관대학교');
INSERT INTO DB066_University VALUES (195, '고려대학교');
INSERT INTO DB066_University VALUES (196, '서울대학교');
INSERT INTO DB066_University VALUES (196, '영남대학교');
INSERT INTO DB066_University VALUES (196, '한국항공대학교');
INSERT INTO DB066_University VALUES (197, '용인대학교');
INSERT INTO DB066_University VALUES (198, '단국대학교');
INSERT INTO DB066_University VALUES (199, '서울교육대학교');
INSERT INTO DB066_University VALUES (199, '클레어몬트대학교');
INSERT INTO DB066_University VALUES (199, '건국대학교');
INSERT INTO DB066_University VALUES (200, '대전대학교');
INSERT INTO DB066_University VALUES (201, '고려대학교');
INSERT INTO DB066_University VALUES (202, '육군사관학교');
INSERT INTO DB066_University VALUES (202, '충남대학교');
INSERT INTO DB066_University VALUES (203, '서울대학교');
INSERT INTO DB066_University VALUES (203, '노스웨스턴대학교');
INSERT INTO DB066_University VALUES (204, '서울대학교');
INSERT INTO DB066_University VALUES (204, '경남대학교');
INSERT INTO DB066_University VALUES (205, '한국방송통신대학교');
INSERT INTO DB066_University VALUES (205, '동아대학교');
INSERT INTO DB066_University VALUES (206, '울산대학교');
INSERT INTO DB066_University VALUES (206, '동국대학교');
INSERT INTO DB066_University VALUES (207, '한국방송통신대학교');
INSERT INTO DB066_University VALUES (207, '한양대학교');
INSERT INTO DB066_University VALUES (208, '경북대학교');
INSERT INTO DB066_University VALUES (208, '연세대학교');
INSERT INTO DB066_University VALUES (208, '대구대학교');
INSERT INTO DB066_University VALUES (209, '고려대학교');
INSERT INTO DB066_University VALUES (209, '노스웨스턴대학교');
INSERT INTO DB066_University VALUES (209, '조지워싱턴대학교');
INSERT INTO DB066_University VALUES (209, '한국해양대학교');
INSERT INTO DB066_University VALUES (210, '연세대학교');
INSERT INTO DB066_University VALUES (210, '서울대학교');
INSERT INTO DB066_University VALUES (210, '서던캘리포니아대학교');
INSERT INTO DB066_University VALUES (210, '건국대학교');
INSERT INTO DB066_University VALUES (211, '고려대학교');
INSERT INTO DB066_University VALUES (213, '중앙대학교');
INSERT INTO DB066_University VALUES (214, '이화여자대학교');
INSERT INTO DB066_University VALUES (215, '울산대학교');
INSERT INTO DB066_University VALUES (215, '조선대학교');
INSERT INTO DB066_University VALUES (216, '전남대학교');
INSERT INTO DB066_University VALUES (216, '서강대학교');
INSERT INTO DB066_University VALUES (217, '경찰대학교');
INSERT INTO DB066_University VALUES (217, '연세대학교');
INSERT INTO DB066_University VALUES (218, '성균관대학교');
INSERT INTO DB066_University VALUES (218, '하와이대학교');
INSERT INTO DB066_University VALUES (218, '서울대학교');
INSERT INTO DB066_University VALUES (219, '고려대학교');
INSERT INTO DB066_University VALUES (219, '세계해사대학교');
INSERT INTO DB066_University VALUES (220, '경희대학교');
INSERT INTO DB066_University VALUES (220, '서울대학교');
INSERT INTO DB066_University VALUES (220, '연세대학교');
INSERT INTO DB066_University VALUES (221, '고려대학교');
INSERT INTO DB066_University VALUES (221, '공주대학교');
INSERT INTO DB066_University VALUES (222, '고려대학교');
INSERT INTO DB066_University VALUES (222, '서울대학교');
INSERT INTO DB066_University VALUES (222, '가톨릭대학교');
INSERT INTO DB066_University VALUES (222, '경북대학교');
INSERT INTO DB066_University VALUES (223, '부산대학교');
INSERT INTO DB066_University VALUES (224, '목포대학교');
INSERT INTO DB066_University VALUES (225, '고려대학교');
INSERT INTO DB066_University VALUES (226, '영남대학교');
INSERT INTO DB066_University VALUES (227, '연세대학교');
INSERT INTO DB066_University VALUES (227, '위스콘신대학교');
INSERT INTO DB066_University VALUES (227, '대구한의대학교');
INSERT INTO DB066_University VALUES (228, '고려대학교');
INSERT INTO DB066_University VALUES (229, '서울대학교');
INSERT INTO DB066_University VALUES (229, '만하임대학교');
INSERT INTO DB066_University VALUES (230, '고려대학교');
INSERT INTO DB066_University VALUES (230, '오리건대학교');
INSERT INTO DB066_University VALUES (231, '성균관대학교');
INSERT INTO DB066_University VALUES (232, '고려대학교');
INSERT INTO DB066_University VALUES (233, '고려대학교');
INSERT INTO DB066_University VALUES (233, '스탠퍼드대학교');
INSERT INTO DB066_University VALUES (233, '하버드대학교');
INSERT INTO DB066_University VALUES (234, '건국대학교');
INSERT INTO DB066_University VALUES (234, '한양대학교');
INSERT INTO DB066_University VALUES (235, '건국대학교');
INSERT INTO DB066_University VALUES (236, '예산농업전문대학교');
INSERT INTO DB066_University VALUES (237, '서울대학교');
INSERT INTO DB066_University VALUES (238, '전남대학교');
INSERT INTO DB066_University VALUES (238, '연세대학교');
INSERT INTO DB066_University VALUES (239, '고려대학교');
INSERT INTO DB066_University VALUES (240, '성균관대학교');
INSERT INTO DB066_University VALUES (240, '서울대학교');
INSERT INTO DB066_University VALUES (241, '전북대학교');
INSERT INTO DB066_University VALUES (242, '서울대학교');
INSERT INTO DB066_University VALUES (243, '서울시립대학교');
INSERT INTO DB066_University VALUES (244, '서울대학교');
INSERT INTO DB066_University VALUES (245, '숙명여자대학교');
INSERT INTO DB066_University VALUES (246, '원광대학교');
INSERT INTO DB066_University VALUES (246, '성균관대학교');
INSERT INTO DB066_University VALUES (247, '연세대학교');
INSERT INTO DB066_University VALUES (248, '세종대학교');
INSERT INTO DB066_University VALUES (248, '서강대학교');
INSERT INTO DB066_University VALUES (249, '서울대학교');
INSERT INTO DB066_University VALUES (249, '케임브리지대학교');
INSERT INTO DB066_University VALUES (250, '서울대학교');
INSERT INTO DB066_University VALUES (250, '탐페레대학교');
INSERT INTO DB066_University VALUES (251, '성균관대학교');
INSERT INTO DB066_University VALUES (251, '오하이오주립대학교');
INSERT INTO DB066_University VALUES (252, '광주교육대학교');
INSERT INTO DB066_University VALUES (252, '단국대학교');
INSERT INTO DB066_University VALUES (252, '목포대학교');
INSERT INTO DB066_University VALUES (252, '조선대학교');
INSERT INTO DB066_University VALUES (253, '서울대학교');
INSERT INTO DB066_University VALUES (254, '건국대학교');
INSERT INTO DB066_University VALUES (255, '연세대학교');
INSERT INTO DB066_University VALUES (255, '충남대학교');
INSERT INTO DB066_University VALUES (256, '서울대학교');
INSERT INTO DB066_University VALUES (256, '스탠퍼드대학교');
INSERT INTO DB066_University VALUES (257, '서울대학교');
INSERT INTO DB066_University VALUES (258, '성균관대학교');
INSERT INTO DB066_University VALUES (258, '서울대학교');
INSERT INTO DB066_University VALUES (258, '시라큐스대학교');
INSERT INTO DB066_University VALUES (259, '용인대학교');
INSERT INTO DB066_University VALUES (259, '명지대학교');
INSERT INTO DB066_University VALUES (259, '고려대학교');
INSERT INTO DB066_University VALUES (259, '국민대학교');
INSERT INTO DB066_University VALUES (260, '서울대학교');
INSERT INTO DB066_University VALUES (260, '툴레인대학교');
INSERT INTO DB066_University VALUES (260, '마이애미대학교');
INSERT INTO DB066_University VALUES (261, '서울대학교');
INSERT INTO DB066_University VALUES (261, '노스웨스턴대학교');
INSERT INTO DB066_University VALUES (261, '연세대학교');
INSERT INTO DB066_University VALUES (262, '서울대학교');
INSERT INTO DB066_University VALUES (263, '서울대학교');
INSERT INTO DB066_University VALUES (264, '인하대학교');
INSERT INTO DB066_University VALUES (264, '연세대학교');
INSERT INTO DB066_University VALUES (265, '한국항공대학교');
INSERT INTO DB066_University VALUES (265, '연세대학교');
INSERT INTO DB066_University VALUES (266, '서울대학교');
INSERT INTO DB066_University VALUES (266, '중앙대학교');
INSERT INTO DB066_University VALUES (266, '위스콘신대학교');
INSERT INTO DB066_University VALUES (267, '서울대학교');
INSERT INTO DB066_University VALUES (267, '연세대학교');
INSERT INTO DB066_University VALUES (268, '서울대학교');
INSERT INTO DB066_University VALUES (268, '웨일즈대학교');
INSERT INTO DB066_University VALUES (269, '전남대학교');
INSERT INTO DB066_University VALUES (269, '한양대학교');
INSERT INTO DB066_University VALUES (270, '서울대학교');
INSERT INTO DB066_University VALUES (271, '성균관대학교');
INSERT INTO DB066_University VALUES (271, '고려대학교');
INSERT INTO DB066_University VALUES (271, '전남대학교');
INSERT INTO DB066_University VALUES (272, '고려대학교');
INSERT INTO DB066_University VALUES (273, '서울대학교');
INSERT INTO DB066_University VALUES (273, '한국방송통신대학교');
INSERT INTO DB066_University VALUES (274, '연세대학교');
INSERT INTO DB066_University VALUES (274, '위스콘신대학교');
INSERT INTO DB066_University VALUES (274, '대구한의대학교');
INSERT INTO DB066_University VALUES (275, '전남대학교');
INSERT INTO DB066_University VALUES (276, '서울대학교');
INSERT INTO DB066_University VALUES (277, '연세대학교');
INSERT INTO DB066_University VALUES (277, '미주리대학교');
INSERT INTO DB066_University VALUES (278, '서울대학교');
INSERT INTO DB066_University VALUES (279, '서울대학교');
INSERT INTO DB066_University VALUES (280, '한국예술종합학교');
INSERT INTO DB066_University VALUES (280, '고려대학교');
INSERT INTO DB066_University VALUES (281, '서울대학교');
INSERT INTO DB066_University VALUES (281, '위스콘신대학교');
INSERT INTO DB066_University VALUES (282, '한국외국어대학교');
INSERT INTO DB066_University VALUES (282, '산디아고대학교');
INSERT INTO DB066_University VALUES (283, '서울대학교');
INSERT INTO DB066_University VALUES (283, '중앙대학교');
INSERT INTO DB066_University VALUES (284, '서울대학교');
INSERT INTO DB066_University VALUES (284, 'UCLA대학교');
INSERT INTO DB066_University VALUES (285, '성균관대학교');
INSERT INTO DB066_University VALUES (285, '연세대학교');
INSERT INTO DB066_University VALUES (286, '고려대학교');
INSERT INTO DB066_University VALUES (286, '원광대학교');
INSERT INTO DB066_University VALUES (286, '군산대학교');
INSERT INTO DB066_University VALUES (287, '연세대학교');
INSERT INTO DB066_University VALUES (287, '스탠퍼드대학교');
INSERT INTO DB066_University VALUES (287, '도쿄대학교');
INSERT INTO DB066_University VALUES (288, '서울대학교');
INSERT INTO DB066_University VALUES (288, '고려대학교');
INSERT INTO DB066_University VALUES (288, '지린대학교');
INSERT INTO DB066_University VALUES (289, '연세대학교');
INSERT INTO DB066_University VALUES (290, '고려대학교');
INSERT INTO DB066_University VALUES (291, '서울대학교');
INSERT INTO DB066_University VALUES (292, '목포대학교');
INSERT INTO DB066_University VALUES (295, '울산대학교');
INSERT INTO DB066_University VALUES (296, '울산대학교');
INSERT INTO DB066_University VALUES (296, '부산대학교');
INSERT INTO DB066_University VALUES (297, '한국외국어대학교');
INSERT INTO DB066_University VALUES (297, '영남대학교');
INSERT INTO DB066_University VALUES (298, '동국대학교');
INSERT INTO DB066_University VALUES (299, '고려대학교');
INSERT INTO DB066_University VALUES (299, '페퍼다인대학교');
INSERT INTO DB066_University VALUES (299, '경희대학교');
INSERT INTO DB066_University VALUES (299, '전북대학교');
INSERT INTO DB066_University VALUES (300, '서울대학교');
INSERT INTO DB066_University VALUES (300, '단국대학교');
INSERT INTO DB066_University VALUES (301, '서강대학교');
INSERT INTO DB066_University VALUES (301, '노던일리노이대학교');
INSERT INTO DB066_University VALUES (302, '고려대학교');
INSERT INTO DB066_University VALUES (303, '연세대학교');
INSERT INTO DB066_University VALUES (303, '서울대학교');
INSERT INTO DB066_University VALUES (304, '조선대학교');
INSERT INTO DB066_University VALUES (305, '성균관대학교' );
INSERT INTO DB066_University VALUES (305, '한남대학교');
INSERT INTO DB066_University VALUES (305, '대전대학교');
INSERT INTO DB066_University VALUES (306, '서울대학교');
INSERT INTO DB066_University VALUES (307, '서울대학교');
INSERT INTO DB066_University VALUES (307, '한양대학교');
INSERT INTO DB066_University VALUES (308, '연세대학교');
INSERT INTO DB066_University VALUES (308, '예일대학교');
INSERT INTO DB066_University VALUES (309, '강원대학교');
INSERT INTO DB066_University VALUES (309, '서울대학교');
INSERT INTO DB066_University VALUES (310, '서울대학교');
INSERT INTO DB066_University VALUES (311, '고려대학교');
INSERT INTO DB066_University VALUES (312, '고려대학교');
INSERT INTO DB066_University VALUES (312, '서울대학교');
INSERT INTO DB066_University VALUES (313, '서울대학교');
INSERT INTO DB066_University VALUES (314, '영남대학교');
INSERT INTO DB066_University VALUES (314, '금오공과대학교');
INSERT INTO DB066_University VALUES (314, '몽골대학교');
INSERT INTO DB066_University VALUES (314, '계명대학교');
INSERT INTO DB066_University VALUES (315, '고려대학교');
INSERT INTO DB066_University VALUES (315, '신라대학교');
INSERT INTO DB066_University VALUES (316, '서울대학교');
INSERT INTO DB066_University VALUES (316, '경남대학교');
INSERT INTO DB066_University VALUES (316, '한양대학교');
INSERT INTO DB066_University VALUES (316, '제주대학교');

INSERT INTO DB066_Major VALUES (1, '농경제학');
INSERT INTO DB066_Major VALUES (2, '동양사학');
INSERT INTO DB066_Major VALUES (2, '국사학');
INSERT INTO DB066_Major VALUES (3, '경영학');
INSERT INTO DB066_Major VALUES (4, '언론정보학');
INSERT INTO DB066_Major VALUES (6, '경제학');
INSERT INTO DB066_Major VALUES (7, '법학');
INSERT INTO DB066_Major VALUES (7, '공법학');
INSERT INTO DB066_Major VALUES (8, '커뮤니케이션학');
INSERT INTO DB066_Major VALUES (8, '신문방송학');
INSERT INTO DB066_Major VALUES (9, '인류학');
INSERT INTO DB066_Major VALUES (10, '고용정책학');
INSERT INTO DB066_Major VALUES (10, '사회학');
INSERT INTO DB066_Major VALUES (10, '경제학');
INSERT INTO DB066_Major VALUES (11, '정치학');
INSERT INTO DB066_Major VALUES (11, '정치외교학');
INSERT INTO DB066_Major VALUES (12, '농업경제학');
INSERT INTO DB066_Major VALUES (13, '경영공학');
INSERT INTO DB066_Major VALUES (13, '경영학');
INSERT INTO DB066_Major VALUES (14, '국민윤리학');
INSERT INTO DB066_Major VALUES (15, '경영학');
INSERT INTO DB066_Major VALUES (15, '법학');
INSERT INTO DB066_Major VALUES (16, '행정학');
INSERT INTO DB066_Major VALUES (16, '정치학');
INSERT INTO DB066_Major VALUES (17, '제약학');
INSERT INTO DB066_Major VALUES (18, '독어독문학');
INSERT INTO DB066_Major VALUES (19, '경제학');
INSERT INTO DB066_Major VALUES (19, '국어국문학');
INSERT INTO DB066_Major VALUES (20, '경영학');
INSERT INTO DB066_Major VALUES (21, '정치외교학');
INSERT INTO DB066_Major VALUES (22, '중국학');
INSERT INTO DB066_Major VALUES (22, '국제정치학');
INSERT INTO DB066_Major VALUES (23, '정책학');
INSERT INTO DB066_Major VALUES (23, '법학');
INSERT INTO DB066_Major VALUES (23, '행정학');
INSERT INTO DB066_Major VALUES (23, '국제경제학');
INSERT INTO DB066_Major VALUES (24, '국문학');
INSERT INTO DB066_Major VALUES (25, '공공정책학');
INSERT INTO DB066_Major VALUES (25, '행정학');
INSERT INTO DB066_Major VALUES (25, '법학');
INSERT INTO DB066_Major VALUES (26, '경영학');
INSERT INTO DB066_Major VALUES (26, '건축공학');
INSERT INTO DB066_Major VALUES (27, '행정학');
INSERT INTO DB066_Major VALUES (28, '국제정치학');
INSERT INTO DB066_Major VALUES (28, '국제경제학');
INSERT INTO DB066_Major VALUES (29, '법학');
INSERT INTO DB066_Major VALUES (30, '행정학');
INSERT INTO DB066_Major VALUES (30, '천문학');
INSERT INTO DB066_Major VALUES (31, '정치외교학');
INSERT INTO DB066_Major VALUES (32, '사회복지학');
INSERT INTO DB066_Major VALUES (32, '국어국문학');
INSERT INTO DB066_Major VALUES (33, '중어중문학');
INSERT INTO DB066_Major VALUES (33, '언론정보학');
INSERT INTO DB066_Major VALUES (33, '철학');
INSERT INTO DB066_Major VALUES (34, '문학');
INSERT INTO DB066_Major VALUES (34, '국어교육학');
INSERT INTO DB066_Major VALUES (35, '법학');
INSERT INTO DB066_Major VALUES (36, '무역학');
INSERT INTO DB066_Major VALUES (37, '법학');
INSERT INTO DB066_Major VALUES (38, '수학교육학');
INSERT INTO DB066_Major VALUES (39, '언론정보학');
INSERT INTO DB066_Major VALUES (40, '교통경제학');
INSERT INTO DB066_Major VALUES (40, '행정학');
INSERT INTO DB066_Major VALUES (41, '법학');
INSERT INTO DB066_Major VALUES (41, '경제학');
INSERT INTO DB066_Major VALUES (42, '자치행정학');
INSERT INTO DB066_Major VALUES (42, '언론정보학');
INSERT INTO DB066_Major VALUES (42, '중어중문학');
INSERT INTO DB066_Major VALUES (42, '법률학');
INSERT INTO DB066_Major VALUES (42, '신문방송학');
INSERT INTO DB066_Major VALUES (43, '언론학');
INSERT INTO DB066_Major VALUES (43, '지리학');
INSERT INTO DB066_Major VALUES (44, '한국철학');
INSERT INTO DB066_Major VALUES (45, '행정학');
INSERT INTO DB066_Major VALUES (45, '사회학');
INSERT INTO DB066_Major VALUES (46, '행정학');
INSERT INTO DB066_Major VALUES (46, '불어학');
INSERT INTO DB066_Major VALUES (47, '이학');
INSERT INTO DB066_Major VALUES (48, '법학');
INSERT INTO DB066_Major VALUES (49, '경영학');
INSERT INTO DB066_Major VALUES (50, '행정학');
INSERT INTO DB066_Major VALUES (50, '국어국문학');
INSERT INTO DB066_Major VALUES (51, '무역학');
INSERT INTO DB066_Major VALUES (52, '사회학');
INSERT INTO DB066_Major VALUES (53, '국제정치학');
INSERT INTO DB066_Major VALUES (53, '정치외교학');
INSERT INTO DB066_Major VALUES (54, '동아시아학');
INSERT INTO DB066_Major VALUES (54, '공공정책학');
INSERT INTO DB066_Major VALUES (54, '정치외교학');
INSERT INTO DB066_Major VALUES (55, '법학');
INSERT INTO DB066_Major VALUES (56, '사학');
INSERT INTO DB066_Major VALUES (57, '철학');
INSERT INTO DB066_Major VALUES (58, '시각디자인학' );
INSERT INTO DB066_Major VALUES (58, '응용미술학');
INSERT INTO DB066_Major VALUES (59, '법학');
INSERT INTO DB066_Major VALUES (60, '일본학');
INSERT INTO DB066_Major VALUES (61, '지방자치도시행정학');
INSERT INTO DB066_Major VALUES (61, '신문방송학');
INSERT INTO DB066_Major VALUES (62, '언론학');
INSERT INTO DB066_Major VALUES (62, '사회학');
INSERT INTO DB066_Major VALUES (63, '치의학');
INSERT INTO DB066_Major VALUES (64, '행정학');
INSERT INTO DB066_Major VALUES (65, '자원학');
INSERT INTO DB066_Major VALUES (66, '국제정치학');
INSERT INTO DB066_Major VALUES (67, '철학');
INSERT INTO DB066_Major VALUES (67, '무역학');
INSERT INTO DB066_Major VALUES (68, '교육학');
INSERT INTO DB066_Major VALUES (69, '법학');
INSERT INTO DB066_Major VALUES (70, '법학');
INSERT INTO DB066_Major VALUES (70, '특수법무학');
INSERT INTO DB066_Major VALUES (71, '경제학');
INSERT INTO DB066_Major VALUES (72, '경영학');
INSERT INTO DB066_Major VALUES (73, '행정학');
INSERT INTO DB066_Major VALUES (73, '도시학');
INSERT INTO DB066_Major VALUES (74, '국어국문학');
INSERT INTO DB066_Major VALUES (74, '공공정책학');
INSERT INTO DB066_Major VALUES (75, '토목공학');
INSERT INTO DB066_Major VALUES (75, '환경공학');
INSERT INTO DB066_Major VALUES (76, '역사교육학');
INSERT INTO DB066_Major VALUES (77, '원예학');
INSERT INTO DB066_Major VALUES (78, '경영학');
INSERT INTO DB066_Major VALUES (79, '행정학');
INSERT INTO DB066_Major VALUES (80, '동양철학');
INSERT INTO DB066_Major VALUES (80, '공공정책학');
INSERT INTO DB066_Major VALUES (81, '신문방송학');
INSERT INTO DB066_Major VALUES (82, '철학');
INSERT INTO DB066_Major VALUES (83, '사회학');
INSERT INTO DB066_Major VALUES (83, '경제학');
INSERT INTO DB066_Major VALUES (83, '정치학');
INSERT INTO DB066_Major VALUES (84, '경영학');
INSERT INTO DB066_Major VALUES (85, '법학');
INSERT INTO DB066_Major VALUES (86, '법학');
INSERT INTO DB066_Major VALUES (87, '외교학');
INSERT INTO DB066_Major VALUES (87, '국제관계학');
INSERT INTO DB066_Major VALUES (88, '경영학');
INSERT INTO DB066_Major VALUES (89, '법학');
INSERT INTO DB066_Major VALUES (90, '국어국문학');
INSERT INTO DB066_Major VALUES (90, '정보통신학');
INSERT INTO DB066_Major VALUES (91, '사법학');
INSERT INTO DB066_Major VALUES (91, '언론홍보학');
INSERT INTO DB066_Major VALUES (92, '공법학');
INSERT INTO DB066_Major VALUES (93, '정치외교학');
INSERT INTO DB066_Major VALUES (94, '법학');
INSERT INTO DB066_Major VALUES (95, '국어국문학');
INSERT INTO DB066_Major VALUES (95, 'NGO학');
INSERT INTO DB066_Major VALUES (96, '사회학');
INSERT INTO DB066_Major VALUES (97, '사학');
INSERT INTO DB066_Major VALUES (98, '사회학');
INSERT INTO DB066_Major VALUES (99, '행정자치학');
INSERT INTO DB066_Major VALUES (100, '역사교육학');
INSERT INTO DB066_Major VALUES (100, '정치학');
INSERT INTO DB066_Major VALUES (101, '법학');
INSERT INTO DB066_Major VALUES (102, '치의학');
INSERT INTO DB066_Major VALUES (102, '의료법학');
INSERT INTO DB066_Major VALUES (103, '약학');
INSERT INTO DB066_Major VALUES (103, '임상약학');
INSERT INTO DB066_Major VALUES (104, '법학');
INSERT INTO DB066_Major VALUES (105, '행정학');
INSERT INTO DB066_Major VALUES (106, '사회복지학');
INSERT INTO DB066_Major VALUES (107, '심리학');
INSERT INTO DB066_Major VALUES (108, '사회학');
INSERT INTO DB066_Major VALUES (108, '평화안보학');
INSERT INTO DB066_Major VALUES (109, '법학');
INSERT INTO DB066_Major VALUES (110, '건축공학');
INSERT INTO DB066_Major VALUES (110, '행정학');
INSERT INTO DB066_Major VALUES (111, '법학');
INSERT INTO DB066_Major VALUES (112, '법학');
INSERT INTO DB066_Major VALUES (113, '경영학');
INSERT INTO DB066_Major VALUES (114, '정치외교학');
INSERT INTO DB066_Major VALUES (115, '법학');
INSERT INTO DB066_Major VALUES (115, '경제학');
INSERT INTO DB066_Major VALUES (116, '행정학');
INSERT INTO DB066_Major VALUES (117, '환경공학');
INSERT INTO DB066_Major VALUES (117, '산업공학');
INSERT INTO DB066_Major VALUES (118, '철학');
INSERT INTO DB066_Major VALUES (118, '행정학');
INSERT INTO DB066_Major VALUES (119, '농업경제학');
INSERT INTO DB066_Major VALUES (120, '정치학');
INSERT INTO DB066_Major VALUES (120, '정치외교학');
INSERT INTO DB066_Major VALUES (121, '경제학');
INSERT INTO DB066_Major VALUES (121, '도시공학');
INSERT INTO DB066_Major VALUES (122, '행정학');
INSERT INTO DB066_Major VALUES (122, '도시계획학');
INSERT INTO DB066_Major VALUES (122, '도시공학');
INSERT INTO DB066_Major VALUES (123, '정치학');
INSERT INTO DB066_Major VALUES (123, '행정학');
INSERT INTO DB066_Major VALUES (124, '스페인어학');
INSERT INTO DB066_Major VALUES (125, '법학');
INSERT INTO DB066_Major VALUES (125, '국제법학');
INSERT INTO DB066_Major VALUES (126, '법학');
INSERT INTO DB066_Major VALUES (127, '행정학');
INSERT INTO DB066_Major VALUES (128, '법학');
INSERT INTO DB066_Major VALUES (129, '신문학');
INSERT INTO DB066_Major VALUES (129, '행정학');
INSERT INTO DB066_Major VALUES (129, '경영학');
INSERT INTO DB066_Major VALUES (129, '회계학');
INSERT INTO DB066_Major VALUES (130, '법학');
INSERT INTO DB066_Major VALUES (131, '행정학');
INSERT INTO DB066_Major VALUES (132, '공학');
INSERT INTO DB066_Major VALUES (133, '행정학');
INSERT INTO DB066_Major VALUES (134, '법학');
INSERT INTO DB066_Major VALUES (135, '축산학');
INSERT INTO DB066_Major VALUES (135, '지방자치학');
INSERT INTO DB066_Major VALUES (136, '경영학');
INSERT INTO DB066_Major VALUES (136, '정치학');
INSERT INTO DB066_Major VALUES (137, '행정학');
INSERT INTO DB066_Major VALUES (138, '정치학');
INSERT INTO DB066_Major VALUES (138, '행정학');
INSERT INTO DB066_Major VALUES (138, '경찰행정학');
INSERT INTO DB066_Major VALUES (139, '정치외교학');
INSERT INTO DB066_Major VALUES (139, '국제정치학');
INSERT INTO DB066_Major VALUES (140, '토목환경공학' );
INSERT INTO DB066_Major VALUES (141, '국제정치학');
INSERT INTO DB066_Major VALUES (141, '정치및지역발전학');
INSERT INTO DB066_Major VALUES (142, '법학');
INSERT INTO DB066_Major VALUES (142, '사회복지학');
INSERT INTO DB066_Major VALUES (143, '영어학');
INSERT INTO DB066_Major VALUES (143, '정치학');
INSERT INTO DB066_Major VALUES (143, '행정학');
INSERT INTO DB066_Major VALUES (144, '약학');
INSERT INTO DB066_Major VALUES (144, '제약학');
INSERT INTO DB066_Major VALUES (145, '약학');
INSERT INTO DB066_Major VALUES (145, '이학');
INSERT INTO DB066_Major VALUES (146, '정치외교학');
INSERT INTO DB066_Major VALUES (146, '국정관리학');
INSERT INTO DB066_Major VALUES (147, '정치학');
INSERT INTO DB066_Major VALUES (148, '법학');
INSERT INTO DB066_Major VALUES (149, '공법학');
INSERT INTO DB066_Major VALUES (149, '행정학');
INSERT INTO DB066_Major VALUES (150, '정치외교학');
INSERT INTO DB066_Major VALUES (151, '법학');
INSERT INTO DB066_Major VALUES (151, '정치학');
INSERT INTO DB066_Major VALUES (152, '경제학');
INSERT INTO DB066_Major VALUES (153, '법학');
INSERT INTO DB066_Major VALUES (154, '행정학');
INSERT INTO DB066_Major VALUES (154, '무역학');
INSERT INTO DB066_Major VALUES (155, '경제학');
INSERT INTO DB066_Major VALUES (156, '행정학');
INSERT INTO DB066_Major VALUES (157, '도시계획학');
INSERT INTO DB066_Major VALUES (158, '법학');
INSERT INTO DB066_Major VALUES (158, '국제법학');
INSERT INTO DB066_Major VALUES (160, '행정학');
INSERT INTO DB066_Major VALUES (161, '정치외교학');
INSERT INTO DB066_Major VALUES (161, '외교안보학');
INSERT INTO DB066_Major VALUES (162, '토목공학');
INSERT INTO DB066_Major VALUES (162, '경영학');
INSERT INTO DB066_Major VALUES (162, '철도건설공학' );
INSERT INTO DB066_Major VALUES (163, '행정학');
INSERT INTO DB066_Major VALUES (164, '행정학');
INSERT INTO DB066_Major VALUES (164, '정치학');
INSERT INTO DB066_Major VALUES (165, '행정학');
INSERT INTO DB066_Major VALUES (165, '도시행정학');
INSERT INTO DB066_Major VALUES (165, '정치학');
INSERT INTO DB066_Major VALUES (166, '경제학');
INSERT INTO DB066_Major VALUES (167, '행정학');
INSERT INTO DB066_Major VALUES (167, '경영학');
INSERT INTO DB066_Major VALUES (168, '행정학');
INSERT INTO DB066_Major VALUES (169, '국제학');
INSERT INTO DB066_Major VALUES (169, '경영학');
INSERT INTO DB066_Major VALUES (169, '행정학');
INSERT INTO DB066_Major VALUES (170, '정치외교학');
INSERT INTO DB066_Major VALUES (170, '정치학');
INSERT INTO DB066_Major VALUES (171, '정치외교학');
INSERT INTO DB066_Major VALUES (172, '경영학');
INSERT INTO DB066_Major VALUES (172, '행정학');
INSERT INTO DB066_Major VALUES (172, '환경공학');
INSERT INTO DB066_Major VALUES (173, '경제학');
INSERT INTO DB066_Major VALUES (173, '행정학');
INSERT INTO DB066_Major VALUES (173, '국제경제학');
INSERT INTO DB066_Major VALUES (174, '전자계산학');
INSERT INTO DB066_Major VALUES (174, '전자상거래학' );
INSERT INTO DB066_Major VALUES (174, '경영학');
INSERT INTO DB066_Major VALUES (175, '교육학');
INSERT INTO DB066_Major VALUES (175, '공공정책학');
INSERT INTO DB066_Major VALUES (176, '의학');
INSERT INTO DB066_Major VALUES (177, '영어교육학');
INSERT INTO DB066_Major VALUES (177, '사회복지학');
INSERT INTO DB066_Major VALUES (178, '경영학');
INSERT INTO DB066_Major VALUES (178, '중어중문학');
INSERT INTO DB066_Major VALUES (178, '행정학');
INSERT INTO DB066_Major VALUES (179, '경영학');
INSERT INTO DB066_Major VALUES (180, '법학');
INSERT INTO DB066_Major VALUES (181, '행정학');
INSERT INTO DB066_Major VALUES (182, '철학');
INSERT INTO DB066_Major VALUES (182, '정치외교학');
INSERT INTO DB066_Major VALUES (183, '법학');
INSERT INTO DB066_Major VALUES (184, '행정학');
INSERT INTO DB066_Major VALUES (185, '행정학');
INSERT INTO DB066_Major VALUES (185, '법학');
INSERT INTO DB066_Major VALUES (186, '무역학');
INSERT INTO DB066_Major VALUES (186, '법학');
INSERT INTO DB066_Major VALUES (187, '경제학');
INSERT INTO DB066_Major VALUES (187, '외교학');
INSERT INTO DB066_Major VALUES (187, '국제정치학');
INSERT INTO DB066_Major VALUES (188, '정치외교학');
INSERT INTO DB066_Major VALUES (188, '공공정책학');
INSERT INTO DB066_Major VALUES (189, '법학');
INSERT INTO DB066_Major VALUES (190, '경영학');
INSERT INTO DB066_Major VALUES (190, '행정학');
INSERT INTO DB066_Major VALUES (191, '행정학');
INSERT INTO DB066_Major VALUES (191, '독어독문학');
INSERT INTO DB066_Major VALUES (191, '공공정책학');
INSERT INTO DB066_Major VALUES (192, '교육행정학');
INSERT INTO DB066_Major VALUES (192, '영어교육학');
INSERT INTO DB066_Major VALUES (193, '행정학');
INSERT INTO DB066_Major VALUES (193, '법학');
INSERT INTO DB066_Major VALUES (194, '행정학');
INSERT INTO DB066_Major VALUES (195, '불어불문학');
INSERT INTO DB066_Major VALUES (196, '행정학');
INSERT INTO DB066_Major VALUES (196, '도시계획학');
INSERT INTO DB066_Major VALUES (196, '경영학');
INSERT INTO DB066_Major VALUES (197, '경영학');
INSERT INTO DB066_Major VALUES (198, '토목공학');
INSERT INTO DB066_Major VALUES (198, '일반행정학');
INSERT INTO DB066_Major VALUES (199, '교육학');
INSERT INTO DB066_Major VALUES (199, '행정학');
INSERT INTO DB066_Major VALUES (200, '행정학');
INSERT INTO DB066_Major VALUES (201, '경제학');
INSERT INTO DB066_Major VALUES (201, '경영학');
INSERT INTO DB066_Major VALUES (202, '환경학');
INSERT INTO DB066_Major VALUES (202, '군사학');
INSERT INTO DB066_Major VALUES (203, '행정학');
INSERT INTO DB066_Major VALUES (204, '법학');
INSERT INTO DB066_Major VALUES (204, '정치학');
INSERT INTO DB066_Major VALUES (205, '행정학');
INSERT INTO DB066_Major VALUES (205, '지방자치행정학');
INSERT INTO DB066_Major VALUES (206, '경영학');
INSERT INTO DB066_Major VALUES (206, '행정학');
INSERT INTO DB066_Major VALUES (207, '행정학');
INSERT INTO DB066_Major VALUES (208, '경영학');
INSERT INTO DB066_Major VALUES (208, '정치학');
INSERT INTO DB066_Major VALUES (208, '수학교육학');
INSERT INTO DB066_Major VALUES (209, '사회학');
INSERT INTO DB066_Major VALUES (209, '경영학');
INSERT INTO DB066_Major VALUES (209, '정치관리학');
INSERT INTO DB066_Major VALUES (209, '무역학');
INSERT INTO DB066_Major VALUES (210, '전자공학');
INSERT INTO DB066_Major VALUES (210, '행정학');
INSERT INTO DB066_Major VALUES (210, '경영학');
INSERT INTO DB066_Major VALUES (211, '노동학');
INSERT INTO DB066_Major VALUES (213, '신문방송학');
INSERT INTO DB066_Major VALUES (214, '행정학');
INSERT INTO DB066_Major VALUES (215, '화학공학');
INSERT INTO DB066_Major VALUES (215, '법학');
INSERT INTO DB066_Major VALUES (215, '산업관리공학' );
INSERT INTO DB066_Major VALUES (216, '정치학');
INSERT INTO DB066_Major VALUES (216, '물리학');
INSERT INTO DB066_Major VALUES (217, '정치외교학');
INSERT INTO DB066_Major VALUES (218, '법학');
INSERT INTO DB066_Major VALUES (218, '행정학');
INSERT INTO DB066_Major VALUES (218, '경제학');
INSERT INTO DB066_Major VALUES (219, '행정학');
INSERT INTO DB066_Major VALUES (220, '법학');
INSERT INTO DB066_Major VALUES (221, '행정학');
INSERT INTO DB066_Major VALUES (221, '정치외교학');
INSERT INTO DB066_Major VALUES (222, '법학');
INSERT INTO DB066_Major VALUES (222, '행정학');
INSERT INTO DB066_Major VALUES (223, '토목공학');
INSERT INTO DB066_Major VALUES (224, '체육학');
INSERT INTO DB066_Major VALUES (225, '법학');
INSERT INTO DB066_Major VALUES (226, '법학');
INSERT INTO DB066_Major VALUES (227, '경제학');
INSERT INTO DB066_Major VALUES (227, '정치학');
INSERT INTO DB066_Major VALUES (228, '법학');
INSERT INTO DB066_Major VALUES (229, '독어독문학');
INSERT INTO DB066_Major VALUES (229, '독문학');
INSERT INTO DB066_Major VALUES (229, '경영학');
INSERT INTO DB066_Major VALUES (230, '경제학');
INSERT INTO DB066_Major VALUES (230, '경영학');
INSERT INTO DB066_Major VALUES (231, '물리학');
INSERT INTO DB066_Major VALUES (231, '정치학');
INSERT INTO DB066_Major VALUES (231, '문학');
INSERT INTO DB066_Major VALUES (232, '정치학');
INSERT INTO DB066_Major VALUES (232, '법학');
INSERT INTO DB066_Major VALUES (233, '교육학');
INSERT INTO DB066_Major VALUES (233, '문학');
INSERT INTO DB066_Major VALUES (233, '행정학');
INSERT INTO DB066_Major VALUES (234, '농화학');
INSERT INTO DB066_Major VALUES (234, '사회복지학');
INSERT INTO DB066_Major VALUES (235, '법학');
INSERT INTO DB066_Major VALUES (236, '축산학');
INSERT INTO DB066_Major VALUES (237, '정치학');
INSERT INTO DB066_Major VALUES (238, '사법학');
INSERT INTO DB066_Major VALUES (238, '법학');
INSERT INTO DB066_Major VALUES (239, '법학');
INSERT INTO DB066_Major VALUES (240, '경영학');
INSERT INTO DB066_Major VALUES (240, '행정학');
INSERT INTO DB066_Major VALUES (241, '불어불문학');
INSERT INTO DB066_Major VALUES (241, '행정학');
INSERT INTO DB066_Major VALUES (242, '법학');
INSERT INTO DB066_Major VALUES (243, '행정학');
INSERT INTO DB066_Major VALUES (243, '세무관리학');
INSERT INTO DB066_Major VALUES (244, '경제학');
INSERT INTO DB066_Major VALUES (245, '시각영상디자인학');
INSERT INTO DB066_Major VALUES (246, '법학');
INSERT INTO DB066_Major VALUES (246, '문학');
INSERT INTO DB066_Major VALUES (246, '한의학');
INSERT INTO DB066_Major VALUES (247, '행정학');
INSERT INTO DB066_Major VALUES (248, '역사학');
INSERT INTO DB066_Major VALUES (248, '공공정책학');
INSERT INTO DB066_Major VALUES (249, '법학');
INSERT INTO DB066_Major VALUES (250, '법학');
INSERT INTO DB066_Major VALUES (250, '교육학');
INSERT INTO DB066_Major VALUES (251, '정치학');
INSERT INTO DB066_Major VALUES (251, '신문학');
INSERT INTO DB066_Major VALUES (252, '교육학');
INSERT INTO DB066_Major VALUES (252, '상학');
INSERT INTO DB066_Major VALUES (252, '법학');
INSERT INTO DB066_Major VALUES (252, '경제학');
INSERT INTO DB066_Major VALUES (253, '국어국문학');
INSERT INTO DB066_Major VALUES (253, '법학');
INSERT INTO DB066_Major VALUES (254, '법학');
INSERT INTO DB066_Major VALUES (255, '물리학');
INSERT INTO DB066_Major VALUES (255, '고체물리학');
INSERT INTO DB066_Major VALUES (256, '물리학');
INSERT INTO DB066_Major VALUES (257, '외교학');
INSERT INTO DB066_Major VALUES (258, '법학');
INSERT INTO DB066_Major VALUES (258, '행정학');
INSERT INTO DB066_Major VALUES (259, '체육학');
INSERT INTO DB066_Major VALUES (259, '정치외교학');
INSERT INTO DB066_Major VALUES (259, '정치학');
INSERT INTO DB066_Major VALUES (259, '법학');
INSERT INTO DB066_Major VALUES (260, '법학');
INSERT INTO DB066_Major VALUES (261, '불어불문학');
INSERT INTO DB066_Major VALUES (261, '법학');
INSERT INTO DB066_Major VALUES (261, '경제법무학');
INSERT INTO DB066_Major VALUES (262, '법학');
INSERT INTO DB066_Major VALUES (263, '산업공학');
INSERT INTO DB066_Major VALUES (264, '기계공학');
INSERT INTO DB066_Major VALUES (264, '경제학');
INSERT INTO DB066_Major VALUES (265, '항공경영학');
INSERT INTO DB066_Major VALUES (265, '행정학');
INSERT INTO DB066_Major VALUES (266, '무역학');
INSERT INTO DB066_Major VALUES (266, '행정학');
INSERT INTO DB066_Major VALUES (266, '공공정책학');
INSERT INTO DB066_Major VALUES (267, '성악과');
INSERT INTO DB066_Major VALUES (268, '국사학');
INSERT INTO DB066_Major VALUES (268, '저널리즘학');
INSERT INTO DB066_Major VALUES (269, '행정학');
INSERT INTO DB066_Major VALUES (269, '국제관광학');
INSERT INTO DB066_Major VALUES (270, '법학');
INSERT INTO DB066_Major VALUES (271, '전자공학');
INSERT INTO DB066_Major VALUES (271, '경영학');
INSERT INTO DB066_Major VALUES (271, '수산과학');
INSERT INTO DB066_Major VALUES (272, '법학');
INSERT INTO DB066_Major VALUES (273, '법학');
INSERT INTO DB066_Major VALUES (273, '조세법학');
INSERT INTO DB066_Major VALUES (273, '교육학');
INSERT INTO DB066_Major VALUES (274, '경제학');
INSERT INTO DB066_Major VALUES (274, '정치학');
INSERT INTO DB066_Major VALUES (275, '교육학');
INSERT INTO DB066_Major VALUES (276, '외교학');
INSERT INTO DB066_Major VALUES (276, '정치학');
INSERT INTO DB066_Major VALUES (277, '정치외교학');
INSERT INTO DB066_Major VALUES (277, '정치학');
INSERT INTO DB066_Major VALUES (278, '국제경제학');
INSERT INTO DB066_Major VALUES (279, '의학');
INSERT INTO DB066_Major VALUES (280, '정책학');
INSERT INTO DB066_Major VALUES (281, '경제학');
INSERT INTO DB066_Major VALUES (282, '태평양지역국제관계학');
INSERT INTO DB066_Major VALUES (283, '경제학');
INSERT INTO DB066_Major VALUES (284, '경제학');
INSERT INTO DB066_Major VALUES (285, '사회학');
INSERT INTO DB066_Major VALUES (285, '행정학');
INSERT INTO DB066_Major VALUES (285, '정치학');
INSERT INTO DB066_Major VALUES (286, '농업경제학');
INSERT INTO DB066_Major VALUES (286, '행정학');
INSERT INTO DB066_Major VALUES (286, '경영학');
INSERT INTO DB066_Major VALUES (287, '토목공학');
INSERT INTO DB066_Major VALUES (287, '건축공학');
INSERT INTO DB066_Major VALUES (288, '물리학');
INSERT INTO DB066_Major VALUES (288, '국제협력학');
INSERT INTO DB066_Major VALUES (288, '세계경제학');
INSERT INTO DB066_Major VALUES (289, '경제학');
INSERT INTO DB066_Major VALUES (290, '정치외교학');
INSERT INTO DB066_Major VALUES (291, '사회교육학');
INSERT INTO DB066_Major VALUES (292, '경영학');
INSERT INTO DB066_Major VALUES (295, '국어국문학');
INSERT INTO DB066_Major VALUES (296, '지역개발학');
INSERT INTO DB066_Major VALUES (296, '행정학');
INSERT INTO DB066_Major VALUES (297, '정치외교학');
INSERT INTO DB066_Major VALUES (297, '정책분석학');
INSERT INTO DB066_Major VALUES (298, '정치외교학');
INSERT INTO DB066_Major VALUES (299, '법학');
INSERT INTO DB066_Major VALUES (299, '경영학');
INSERT INTO DB066_Major VALUES (299, '정치학');
INSERT INTO DB066_Major VALUES (300, '사학');
INSERT INTO DB066_Major VALUES (301, '경제학');
INSERT INTO DB066_Major VALUES (302, '영어영문학');
INSERT INTO DB066_Major VALUES (302, '정치학');
INSERT INTO DB066_Major VALUES (303, '정치학');
INSERT INTO DB066_Major VALUES (303, '행정학');
INSERT INTO DB066_Major VALUES (304, '의학');
INSERT INTO DB066_Major VALUES (305, '경영학');
INSERT INTO DB066_Major VALUES (305, '도시계획학');
INSERT INTO DB066_Major VALUES (305, '행정학');
INSERT INTO DB066_Major VALUES (306, '법학');
INSERT INTO DB066_Major VALUES (307, '행정학');
INSERT INTO DB066_Major VALUES (307, '도시학');
INSERT INTO DB066_Major VALUES (308, '사회사업학');
INSERT INTO DB066_Major VALUES (308, '경영학');
INSERT INTO DB066_Major VALUES (309, '영어교육학');
INSERT INTO DB066_Major VALUES (309, '영문학');
INSERT INTO DB066_Major VALUES (310, '정치학');
INSERT INTO DB066_Major VALUES (311, '철학');
INSERT INTO DB066_Major VALUES (312, '법학');
INSERT INTO DB066_Major VALUES (312, '행정학');
INSERT INTO DB066_Major VALUES (313, '법학');
INSERT INTO DB066_Major VALUES (314, '경제학');
INSERT INTO DB066_Major VALUES (314, '행정학');
INSERT INTO DB066_Major VALUES (314, '교육학');
INSERT INTO DB066_Major VALUES (314, '사회과학');
INSERT INTO DB066_Major VALUES (315, '행정학');
INSERT INTO DB066_Major VALUES (315, '법학');
INSERT INTO DB066_Major VALUES (316, '공법학');
INSERT INTO DB066_Major VALUES (316, '언론정보학');
INSERT INTO DB066_Major VALUES (316, '정치학');

CREATE VIEW DB066_Congressman_Edu AS (SELECT Party, Name, University, Major
                                      FROM (SELECT ID, Party, Name, University
                                            FROM DB066_Congressman NATURAL LEFT OUTER JOIN DB066_University) AS a, DB066_Major
                                            WHERE a.ID = DB066_Major.ID);

CREATE VIEW DB066_Provincial_Governor_Edu AS (SELECT Party, Name, University, Major
                                              FROM (SELECT ID, Party, Name, University
                                                    FROM DB066_Provincial_Governor NATURAL LEFT OUTER JOIN DB066_University) AS a, DB066_Major
                                                    WHERE a.ID = DB066_Major.ID);

CREATE VIEW DB066_Congressman_Reg AS (SELECT Party, Name, Constituency, Constituency_Region, Place_of_Birth, Region AS Place_of_Birth_Region
                                      FROM (SELECT ID, Party, Name, Constituency, Region AS Constituency_Region, Place_of_Birth
                                            FROM DB066_Congressman NATURAL LEFT OUTER JOIN DB066_Constituency) AS a NATURAL LEFT OUTER JOIN DB066_Place_of_Birth);

CREATE VIEW DB066_Provincial_Governor_Reg AS (SELECT Party, Name, Constituency, Constituency_Region, Place_of_Birth, Region AS Place_of_Birth_Region
                                              FROM (SELECT ID, Party, Name, Constituency, Region AS Constituency_Region, Place_of_Birth
                                                    FROM DB066_Provincial_Governor NATURAL LEFT OUTER JOIN DB066_Constituency) AS a NATURAL LEFT OUTER JOIN DB066_Place_of_Birth);

CREATE VIEW DB066_Congressman_Prop AS (SELECT Party, Name, Propensity
                                       FROM DB066_Congressman NATURAL JOIN DB066_Party);

CREATE VIEW DB066_Provincial_Governor_Prop AS (SELECT Party, Name, Propensity
                                               FROM DB066_Provincial_Governor NATURAL JOIN DB066_Party);

CREATE VIEW DB066_Congressman_Total AS (SELECT *
                                        FROM DB066_Congressman_Edu NATURAL JOIN DB066_Congressman_Reg NATURAL JOIN DB066_Congressman_Prop);

CREATE VIEW DB066_Provincial_Governor_Total AS (SELECT *
                                                FROM DB066_Provincial_Governor_Edu NATURAL JOIN DB066_Provincial_Governor_Reg NATURAL JOIN DB066_Provincial_Governor_Prop);

CREATE VIEW DB066_Elected_Officer_Total AS SELECT ID, Party, Name, Gender, Age, Place_of_Birth, Highest_level_of_Education, Property, Constituency, Number_of_Elelction 
                                           FROM DB066_Congressman
                                           UNION 
                                           SELECT ID, Party, Name, Gender, Age, Place_of_Birth, Highest_level_of_Education, Property, Constituency, Number_of_Elelction
                                           FROM DB066_Provincial_Governor;

CREATE VIEW DB066_Percent_Constituency AS SELECT Party, Region, COUNT(Region) AS Count
                                          FROM DB066_Elected_Officer_Total NATURAL JOIN DB066_Constituency
                                          GROUP BY Party, Region
                                          ORDER BY Party, COUNT(Region) DESC;

CREATE VIEW DB066_Percent_C_Region AS SELECT Party, COUNT(Region) AS Total
                                      FROM DB066_Elected_Officer_Total NATURAL JOIN DB066_Constituency
                                      GROUP BY Party
                                      ORDER BY Party;

CREATE VIEW DB066_Percent_Place_of_Birth AS SELECT Party, Region, COUNT(Region) AS Count
                                            FROM DB066_Elected_Officer_Total NATURAL JOIN DB066_Place_of_Birth
                                            GROUP BY Party, Region
                                            ORDER BY Party, COUNT(Region) DESC;

CREATE VIEW DB066_Percent_P_Region AS SELECT Party, COUNT(Region) AS Total
                                      FROM DB066_Elected_Officer_Total NATURAL JOIN DB066_Place_of_Birth
                                      GROUP BY Party
                                      ORDER BY Party;

 

<Java Code>

 

import java.util.Scanner;
import java.sql.*;
import com.mysql.*;
import java.text.DecimalFormat;

public class DB066Team06_SKY {
	
	public static void go_back(Connection conn, int selection, boolean success) throws ClassNotFoundException, SQLException { // 예외가 발생한 경우, 또는 작업이 성공적으로 끝난 경우 처음으로 또는 작업을 다시 수행할 수 있도록 해준다.
		
		Scanner input = new Scanner(System.in);
		
		if (success == true) {
			
			System.out.println();
			System.out.println("작업이 완료되었습니다.");
			
		}
		
		else {
			
			System.out.println();
			System.out.println("해당하는 값이 없거나, 예외인 경우가 발생하였습니다. 다시 수행할 기능을 입력하시오.");
		}
		
		System.out.println();
		System.out.println("1)다시 진행하기");
		System.out.println("2)처음으로 화면으로 가기");
		
		int choice = input.nextInt();
		
		if(choice == 1) {
			
			switch (selection) {
				
			case 1:

				function_inquiry(conn);
				
			case 2:
				
				function_update(conn);
				
			case 3:

				function_addition(conn);
				
			case 4:

				function_deletion(conn);
				
			case 5:

				function_analysis(conn);
			}
			
		}
		
		else main(null);
	}
	
	public static String job(Connection conn, int id) throws ClassNotFoundException, SQLException { // id를 매개변수로 받고, 이를 통하여 Elected_Officer 테이블을 이용하여, Job를 알려준다.
		
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery("SELECT Job FROM DB066_Elected_Officer WHERE ID = " + id);
		
		rs.next();
		
		String job = rs.getString(1);
		
		stmt.close();
		rs.close();

		return job;
	}
	
	public static void show_info(Connection conn, int id) throws ClassNotFoundException, SQLException { // id를  매개변수로 받고, 이를 통하여 국회의원&시도지사의 정보를 보여줄 수 있다.
		
		Statement stmt_1 = conn.createStatement();
		Statement stmt_2 = conn.createStatement();
		Statement stmt_3 = conn.createStatement();
		Statement stmt_4 = conn.createStatement();
		
		ResultSet rs_1 = stmt_1.executeQuery("SELECT * FROM DB066_Elected_Officer_Total WHERE ID = " + id);
		ResultSet rs_2 = stmt_2.executeQuery("SELECT University FROM DB066_University WHERE ID = " + id);
		ResultSet rs_3 = stmt_3.executeQuery("SELECT Major FROM DB066_Major WHERE ID = " + id);
		ResultSet rs_4 = stmt_4.executeQuery("SELECT Propensity FROM DB066_Elected_Officer_Total NATURAL JOIN DB066_Party WHERE ID = " + id);
		
		rs_1.next();
		rs_2.next();
		rs_3.next();
		rs_4.next();
		
		String job = job(conn, id);
		String party = rs_1.getString(2);
		String name = rs_1.getString(3);
		String gender = rs_1.getString(4);
		String age = rs_1.getString(5);
		String place_of_birth  = rs_1.getString(6);
		String highest_level_of_education = rs_1.getString(7);
		String property = rs_1.getString(8);
		String constituency = rs_1.getString(9);
		String number_of_elelction = rs_1.getString(10);
		String propensity = rs_4.getString(1);
		
		System.out.println();
		System.out.println("직업: " + job);
		System.out.println("정당: " + party);
		System.out.println("정치성향 : " + propensity);
		System.out.println("이름: " + name);
		System.out.println("성별: " + gender);
		System.out.println("나이: " + age + "세");
		System.out.println("출생지: " + place_of_birth);
		System.out.println("최종학력: " + highest_level_of_education);
		System.out.print("출신대학교: " + rs_2.getString(1));
		
		if (rs_2.getString(1) != null) {
		
			while (rs_2.next()) {

				System.out.print(", " + rs_2.getString(1));
			}
			
		}
	
		
		System.out.println();
		System.out.print("전공: " + rs_3.getString(1));
		
		if (rs_3.getString(1) != null) {
			
			while (rs_3.next()) {
				
				System.out.print(", " + rs_3.getString(1));
			}
			
		}
		
		System.out.println();
		System.out.println("재산: " + rs_1.getFloat(8) + "억");
		System.out.println("당선지역: " + rs_1.getString(9));
		
		
		if (job.equals("Congressman")) {
			
			rs_1 = stmt_1.executeQuery("SELECT Method_of_Election FROM DB066_Congressman WHERE ID = " + id);
			
			rs_1.next();
			
			System.out.println("선출방법: " + rs_1.getString(1));
		} 
		
		else {
			
			rs_1 = stmt_1.executeQuery("SELECT Administrative_District FROM DB066_Provincial_Governor WHERE ID = " + id);
			
			rs_1.next();
			
			System.out.println("행정구역: " + rs_1.getString(1));
		}
		
		System.out.println("당선횟수: " + number_of_elelction + "번");
		
		stmt_1.close();
		stmt_2.close();
		stmt_3.close();
		stmt_4.close();
		
		rs_1.close();
		rs_2.close();
		rs_3.close();
		rs_4.close();
	}
	
	public static String[] data_list(ResultSet rs, int length) throws ClassNotFoundException, SQLException { // mySQL의 결과값을 배열 형태의 하나의 변수에 담아서 리턴해준다.
		
		int i = 0;
		String[] data = new String[length];
		
		while (rs.next()) {
			
			data[i] = rs.getString(1);
			
			i++;
		}
		
		return data;
	}
	
	public static String[] insert_data_list(int number, String statement) throws ClassNotFoundException, SQLException { // 길이를 입력하면, 배열에 길이만큼의 값을 입력받고, 이를 리턴해준다.
		
		Scanner input = new Scanner(System.in);
		
		String[] data = new String[number];
		
		for (int i = 0 ; i < number ; i++) {
			
			System.out.println();
			System.out.println(statement);
			
			data[i] = input.next();
		}
		
		return data;
	}
	
	public static void function_inquiry(Connection conn) { // 지역을 입력받고, 대상의 정보를 알려준다.
		
		Statement stmt = null;
		ResultSet rs = null;
		
		try {
			
			stmt = conn.createStatement();
			
			Scanner input1 = new Scanner(System.in);
			Scanner input2 = new Scanner(System.in);
		      
			System.out.println();
			System.out.println("지역을 입력하십시오.");
		      
			String input_data = input2.nextLine();
		      
			rs = stmt.executeQuery("SELECT COUNT(*), ID FROM DB066_Elected_Officer_Total WHERE Constituency LIKE '%" + input_data + "%'");
		      
			rs.next();
		      
			int length = rs.getInt(1);
		      
			if (length == 1) {
		         
				show_info(conn, rs.getInt(2));
			} 
			
			else if (length > 1) {
				
				rs = stmt.executeQuery("SELECT Constituency FROM DB066_Elected_Officer_Total WHERE Constituency LIKE '%" + input_data + "%'");
				
				String[] constituency = data_list(rs, length);
				
				System.out.println();
				System.out.println(" <정보>");
				
				for ( int i = 0; i < length; i++) {
					
					System.out.println(i + 1 +")" + constituency[i]);
				}
		         
				System.out.println();
				System.out.println("해당하는 지역의 번호를 입력하시오.");
		         
				int select = input1.nextInt();
		         
				rs = stmt.executeQuery("SELECT ID FROM DB066_Elected_Officer_Total WHERE Constituency = '" + constituency[select - 1] + "'");
		         
				rs.next();
		         
				show_info(conn, rs.getInt(1));
			}
		      
			else if (length == 0) {
		         
				stmt.close();
				rs.close();
		         
				go_back(conn, 1, false);
			}
		      
			stmt.close();
			rs.close();
		      
			go_back(conn, 1, true); 
		}
		
		catch (Exception e) {
			
			System.out.println();
			e.printStackTrace();
		}
		
		finally {
			
			try {
				
				if (stmt != null) {
				
					stmt.close();
				}
				
				if (rs != null) {
					
					rs.close();
				}
				
				go_back(conn, 1, false);
			} 
			
			catch (SQLException se) {
				
				se.printStackTrace();
			}
			
			catch (Exception e) {
				
				e.printStackTrace();
			}
			
		}
				
	}

	public static void function_update(Connection conn) { // 정당과 이름을 입력받고 이를 통하여, 대상의 정당, 재산, 나이에 대한 정보를 수정하도록 한다.
		
		Statement stmt = null;
		ResultSet rs = null;
		
		try {
			
			conn.setAutoCommit(false);
		      
			stmt = conn.createStatement();
		      
			Scanner input1 = new Scanner(System.in);
			Scanner input2 = new Scanner(System.in);
		      
			System.out.println();
			System.out.println("갱신할 정보의 번호를 입력하십시오.");
			System.out.println();
			System.out.println("1)정당");
			System.out.println("2)재산");
			System.out.println("3)나이");
		      
			int select = input1.nextInt();
		      
			rs = stmt.executeQuery("SELECT COUNT(*) FROM (SELECT DISTINCT Party FROM DB066_Elected_Officer_Total) AS a");
		      
			rs.next();
		      
			int party_length = rs.getInt(1);
		      
			rs = stmt.executeQuery("SELECT DISTINCT Party FROM DB066_Elected_Officer_Total");
		      
			String[] party_list = data_list(rs, party_length);
		      
			System.out.println();
			System.out.println("정보를 수정할 국회의원&시도지사의 정당 번호를 입력하시오.");
			System.out.println();
			System.out.println(" <정당>");
		      
			for (int i = 0; i < party_length; i++) {
		         
				System.out.println(i + 1 + ")" + party_list[i]);
			}
		      
			int new_part = input1.nextInt();
			String party = party_list[new_part - 1];
		      
			System.out.println();
			System.out.println("국회의원&시도지사의 이름을 입력하시오.");
		      
			String name = input2.nextLine();
		      
			rs = stmt.executeQuery("SELECT COUNT(*) FROM DB066_Elected_Officer_Total WHERE Party = '" + party + "' AND Name = '" + name + "'");
		      
			rs.next();
		      
			int length = rs.getInt(1);
		      
			int id = 0;
		      
			if (length == 1) {
		         
				rs = stmt.executeQuery("SELECT ID FROM DB066_Elected_Officer_Total WHERE Party = '" + party + "' AND Name = '" + name + "'");
		         
				rs.next();
		         
				id = rs.getInt(1);
			}
		      
			else if (length > 1) {
		         
				rs = stmt.executeQuery("SELECT ID FROM DB066_Elected_Officer_Total WHERE Party = '" + party + "' AND Name = '" + name + "'");
		         
				String[] id_list = data_list(rs, length);
		          
				for (int i = 0; i < length; i++) {
		            
					System.out.println();
		            System.out.println(i + 1 + ")");
		            
		            show_info(conn, Integer.parseInt(id_list[i]));
				}
		         
				System.out.println();
				System.out.println("해당 국회의원&시도지사의 번호를 입력하시오.");
				
				select = input1.nextInt();
		         
				id = Integer.parseInt(id_list[select - 1]);
			}
			
			String job = job(conn, id);
		      
			switch (select) {
		      
			case 1:
		         
				System.out.println();
				System.out.println("이동할 정당의 번호를 입력하시오.");
				System.out.println();
				System.out.println(" <정당>");
		         
				for (int i = 0; i < party_length; i++) {
		            
					System.out.println(i + 1 + ")" + party_list[i]);
				}
		         
				select = input1.nextInt();
				String update_party = party_list[select - 1];
				
				if (job.equals("Congressman")) {

					stmt.executeUpdate("UPDATE DB066_Congressman SET Party = '" + update_party + "' WHERE ID = " + id);
					  
					conn.commit();
				}
		         
				else {
		            
					stmt.executeUpdate("UPDATE DB066_Provincial_Governor SET Party = '" + update_party + "' WHERE ID = '" + id);
					
					conn.commit();
				}
				
				break;
		         
			case 2:
		         
				System.out.println();
				System.out.println("수정할 재산의 액수를 입력하시오. (단위: 1억)");
		         
				int update_property = input1.nextInt();
		         
				if (job.equals("Congressman")) {

					stmt.executeUpdate("UPDATE DB066_Congressman SET Property = " + update_property + " WHERE ID = " + id);
					
					conn.commit();
				}
		         
				else {
		            
					stmt.executeUpdate("UPDATE DB066_Provincial_Governor SET Property = " + update_property + " WHERE ID = " + id);
					
					conn.commit();
		         }
				
				break;
		         
			case 3:
		         
				System.out.println();
				System.out.println("수정할 나이를 입력하시오.");
		         
				int update_age = input1.nextInt();
		         
				if (job.equals("Congressman")) {

					stmt.executeUpdate("UPDATE DB066_Congressman SET Age = " + update_age + " WHERE ID = " + id);
					  
					conn.commit();
				}
		         
				else {
		            
					stmt.executeUpdate("UPDATE DB066_Provincial_Governor SET Age = " + update_age + " WHERE ID = " + id);
					
					conn.commit();
				}
				
				break;
			}
		      
			stmt.close();
			rs.close();
		      
			go_back(conn, 2, true);
		}
		
		catch (SQLException se) {
			
			se.printStackTrace();
		}
		
		catch (Exception e) {
			
			e.printStackTrace();
		}
		
		finally {
			
			try {
				
				if (stmt != null) {

					stmt.close();
				}
				
				if (rs != null) {
				
					rs.close();
				}

				conn.rollback();
				
				go_back(conn, 2, false);
			} 
			
			catch (SQLException se) {
				
				se.printStackTrace();
			}
			
			catch (Exception e2) {
				
				e2.printStackTrace();
			}
			
		}
		
}
	
	public static void function_addition(Connection conn) { // 새로운 시도지사&국회의원을 추가할 수 있도록 한다.
		
		Statement stmt = null;
		ResultSet rs = null;
		
		try {
			
			conn.setAutoCommit(false);
			
			stmt = conn.createStatement();
			
			Scanner input1 = new Scanner(System.in);
			Scanner input2 = new Scanner(System.in);
			
			System.out.println();
			System.out.println("새로 추가할 선출직 공무원의 직업의 번호를 선택하여 주시오.");
			System.out.println();
			System.out.println("1)국회의원");
			System.out.println("2)시도지사");
			
			int select = input1.nextInt();
			
			String job = null;
			
			if (select == 1) {
				
				job = "Congressman";
				
			}
			
			else if (select == 2) {
				
				job = "Provincial Governor";
			}
			
			else if (select > 2 || select < 1) {
				
				stmt.close();
				rs.close();
				
				go_back(conn, 3, false);
			}
			
			rs = stmt.executeQuery("SELECT COUNT(*) FROM (SELECT DISTINCT Party FROM DB066_Elected_Officer_Total) AS a");
			
			rs.next();
			
			int length = rs.getInt(1);
			
			rs = stmt.executeQuery("SELECT DISTINCT Party FROM DB066_Elected_Officer_Total");
			
			String[] party_list = data_list(rs, length);
			
			System.out.println();
			System.out.println("정당 번호를 입력하시오.");
			System.out.println();
			System.out.println(" <정당>");
			
			String party = null;
			
			for (int i = 0; i < length; i++) {
				
				System.out.println(i + 1 + ")" + party_list[i]);
			}
			
			System.out.println(length + 1 + ")직접입력");
			
			select = input1.nextInt();
			
			if (0 < select && select <= length) {
				
				party = party_list[select - 1]; 
			}
			
			else if (select == length + 1) {
				
				System.out.println();
				System.out.println("정당의 이름을 입력하십시오.");
				
				party = input2.nextLine();
			}
			
			else if (select <= 0 || select > length) {
				
				stmt.close();
				rs.close();
				
				go_back(conn, 3, false);
			}
			
			System.out.println();
			System.out.println("이름을 입력하시오.");
			
			String name = input2.nextLine();
			
			System.out.println();
			System.out.println("성별을 입력하시오.");
			
			String gender = input2.nextLine();
			
			System.out.println();
			System.out.println("나이을 입력하시오.");
			
			int age = input1.nextInt();
			
			System.out.println();
			System.out.println("최종학력을 입력하시오.");
			
			String highest_level_of_education = input1.next();
			
			System.out.println();
			System.out.println("재산 액수를 입력하시오. (단위: 1억)");
			
			String property = input1.next();
			
			System.out.println();
			System.out.println("당선횟수를 입력하시오.");
			
			int number_of_election = input1.nextInt();
			
			System.out.println();
			System.out.println("출생지를 입력하시오.");
			
			String input_data = input2.nextLine();
			String place_of_birth = null;
			
			rs = stmt.executeQuery("SELECT COUNT(*) FROM DB066_Place_of_Birth WHERE Place_of_Birth LIKE '%" + input_data + "%'");
			
			rs.next();
			
			length = rs.getInt(1);
			
			if (length == 1) {
				
				rs = stmt.executeQuery("SELECT Place_of_Birth FROM DB066_Place_of_Birth WHERE Place_of_Birth LIKE '%" + input_data + "%'");
				
				rs.next();
				
				place_of_birth = rs.getString(1);
				
			} 
			
			else if (length > 1) {
				
				rs = stmt.executeQuery("SELECT Place_of_Birth FROM DB066_Place_of_Birth WHERE Place_of_Birth LIKE '%" + input_data + "%'");
				
				String[] place_of_birth_list = data_list(rs, length);
				
				System.out.println();
				System.out.println(" <출생지>");
				
				for ( int i = 0; i < length; i++) {
					
					System.out.println(i + 1 +")" + place_of_birth_list[i]);
				}
				
				System.out.println();
				System.out.println("해당 지역의 번호를 입력하시오.");
				
				select = input1.nextInt();
				
				place_of_birth = place_of_birth_list[select - 1];
			}
			
			else if (length == 0) {
				
				stmt.close();
				rs.close();
				
				go_back(conn, 3, false);
			}
			
			rs = stmt.executeQuery("SELECT COUNT(Constituency) FROM DB066_Constituency WHERE Constituency NOT IN (SELECT Constituency FROM DB066_Elected_Officer_Total WHERE Constituency IS NOT NULL)");
			
			rs.next();
			
			length = rs.getInt(1);
			
			String constituency = null;
			
			if (length == 0) {
				
				stmt.close();
				rs.close();
				
				go_back(conn, 3, false);
			}
			
			else {
				
				rs = stmt.executeQuery("SELECT Constituency FROM DB066_Constituency WHERE Constituency NOT IN (SELECT Constituency FROM DB066_Elected_Officer_Total WHERE Constituency IS NOT NULL)");
			
				String[] constituency_list = data_list(rs, length);
				
				System.out.println();
				System.out.println(" <지역구>");
			
				for (int i = 0; i < length; i++) {
				
					System.out.println(i + 1 + ")" + constituency_list[i]);
				}
				

				System.out.println();
				System.out.println("해당 지역구의 번호를 입력하시오.");
				
				select = input1.nextInt();
				
				constituency = constituency_list[select - 1];
			}
			
			String method_of_election = null;
			String administrative_district = null;
			
			if (job.equals("Congressman")) {
				
				method_of_election = "선거";
			}
			
			else {
				
				String[] administrative_district_list = {"특별시", "광역시", "특별자치시", "도", "특별자치도"};
				
				System.out.println();
				System.out.println(" <행정구역>");
				System.out.println("1)특별시");
				System.out.println("2)광역시");
				System.out.println("3)특별자치시");
				System.out.println("4)도");
				System.out.println("5)특별자치도");
				System.out.println();
				System.out.println("행정구역의 번호를 입력하시오.");
				
				select = input1.nextInt();
				
				administrative_district = administrative_district_list[select - 1];
			}
			
			
			System.out.println();
			System.out.println("출신대학교의 갯수를 입력하시오.");
			
			int number_univ = input1.nextInt();
			String[] university_list = new String[number_univ];
			String university = null;
			
			if (number_univ != 0) {
			
			String statement = "출신대학교의 이름을 입력하시오.";
			university_list = insert_data_list(number_univ, statement);
			}
			
			System.out.println();
			System.out.println("전공의 갯수를 입력하시오.");
			
			int number_major = input1.nextInt();
			String[] major_list = new String[number_major];
			String major = null;
			
			if (number_major != 0) {
			
			String statement = "전공의 이름을 입력하시오.";
			major_list = insert_data_list(number_major, statement);
			}
			
			rs = stmt.executeQuery("SELECT MAX(ID) FROM DB066_Elected_Officer");
			
			rs.next();
			
			int id = rs.getInt(1) + 1;
			
			PreparedStatement pre_stmt = conn.prepareStatement("INSERT INTO DB066_Elected_Officer VALUES (?, ?)");
			
			pre_stmt.setInt(1, id);
			pre_stmt.setString(2, job);
			
			pre_stmt.executeUpdate();
			
			if (job.equals("Congressman")) {
				
				pre_stmt = conn.prepareStatement("INSERT INTO DB066_Congressman VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
				
				pre_stmt.setInt(1, id);
				pre_stmt.setString(2, party);
				pre_stmt.setString(3, name);
				pre_stmt.setString(4, gender);
				pre_stmt.setInt(5, age);
				pre_stmt.setString(6, place_of_birth);
				pre_stmt.setString(7, highest_level_of_education);
				pre_stmt.setString(8, property);
				pre_stmt.setString(9, constituency);
				pre_stmt.setString(10, method_of_election);
				pre_stmt.setInt(11, number_of_election);
				
				pre_stmt.execute();
			}
			
			else {
				
				pre_stmt = conn.prepareStatement("INSERT INTO DB066_Provincial_Governor VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
				
				pre_stmt.setInt(1, id);
				pre_stmt.setString(2, party);
				pre_stmt.setString(3, name);
				pre_stmt.setString(4, gender);
				pre_stmt.setInt(5, age);
				pre_stmt.setString(6, place_of_birth);
				pre_stmt.setString(7, highest_level_of_education);
				pre_stmt.setString(8, property);
				pre_stmt.setString(9, constituency);
				pre_stmt.setInt(10, number_of_election);
				pre_stmt.setString(11, administrative_district);
				
				pre_stmt.execute();
			}
			
			System.out.println(number_univ);
			
			if (number_univ != 0) {
			for (int i = 0; i < number_univ; i++) {
				
				stmt.executeUpdate("INSERT INTO DB066_University VALUES (" + id + ",  '" + university_list[i] + "')");
			}
			}
			
			else if (number_univ == 0) {
			
				stmt.executeUpdate("INSERT INTO DB066_University VALUES (" + id + ",  '" + university + "')");
			}
			if (number_univ != 0) {
			for (int i = 0; i < number_major; i++) {
				
				stmt.executeUpdate("INSERT INTO DB066_Major VALUES (" + id + ",  '" + major_list[i] + "')");
			}
			}
			
			else if (number_univ == 0) {
				
				stmt.executeUpdate("INSERT INTO DB066_Major VALUES (" + id + ",  '" + major + "')");
			}
			
			stmt.close();
			rs.close();
			pre_stmt.close();
			
			conn.commit();
			
			go_back(conn, 3, true);	
		}
		
		catch (SQLException se) {
			
			se.printStackTrace();
		}
		
		catch (Exception e) {
			
			e.printStackTrace();
		}
		
		finally {

			try {
				
				if (stmt != null) {

					stmt.close();
				}
				
				if (rs != null) {
				
					rs.close();
				}

				conn.rollback();
				
				go_back(conn, 3, false);
			} 
			
			catch (SQLException se) {
				
				se.printStackTrace();
			}
			
			catch (Exception e2) {
				
				e2.printStackTrace();
			}
			
		}
	}

	public static void function_deletion(Connection conn) { // 기존의 시도시자&국회의원을 제거할 수 있도록 한다.
		
		Statement stmt = null;
		ResultSet rs = null;
		
		try {

			conn.setAutoCommit(false);
			
			stmt = conn.createStatement();
		
			Scanner input1 = new Scanner(System.in);
			Scanner input2 = new Scanner(System.in);

			rs = stmt.executeQuery("SELECT COUNT(*) FROM (SELECT DISTINCT Party FROM DB066_Elected_Officer_Total) AS a");
			
			rs.next();
			
			int length = rs.getInt(1);
			
			rs = stmt.executeQuery("SELECT DISTINCT Party FROM DB066_Elected_Officer_Total");
			
			String[] party_list = data_list(rs, length);
			
			System.out.println();
			System.out.println("제명할 국회의원&시도지사의 정당 번호를 입력하시오.");
			System.out.println();
			System.out.println(" <정당>");
			
			for (int i = 0; i < length; i++) {
				
				System.out.println(i + 1 + ")" + party_list[i]);
			}
			
			int select = input1.nextInt();
			String party = party_list[select - 1];
			
			System.out.println();
			System.out.println("국회의원&시도지사의 이름을 입력하시오.");
			
			String name = input2.nextLine();
			
			rs = stmt.executeQuery("SELECT COUNT(*) FROM DB066_Elected_Officer_Total WHERE Party = '" + party + "' AND Name = '" + name + "'");
			
			rs.next();
			
			length = rs.getInt(1);
			
			if (length == 0) {
				
				stmt.close();
				rs.close();
				
				go_back(conn, 4, false);
			}
			
			else if (length == 1) {
				
				rs = stmt.executeQuery("SELECT ID FROM DB066_Elected_Officer_Total WHERE Party = '" + party + "' AND Name = '" + name + "'");
				
				rs.next();
				
				int id = rs.getInt(1);
				
				String job = job(conn, id);
				
				stmt.executeUpdate("DELETE FROM DB066_Elected_Officer WHERE ID = " + id);
				
				conn.commit();
			}
			
			else if (length > 1) {
				
				rs = stmt.executeQuery("SELECT ID FROM DB066_Elected_Officer_Total WHERE Party = '" + party + "' AND Name = '" + name + "'");
				
				String[] id_list = data_list(rs, length);
				
				System.out.println();
				
				for (int i = 0; i < length; i++) {
					
					System.out.println();
					System.out.println(i + 1 + ")");
					
					show_info(conn, Integer.parseInt(id_list[i]));
				}
				
				System.out.println();
				System.out.println("해당 국회의원&시도지사의 번호를 입력하시오.");
				
				select = input1.nextInt();
				
				int id = Integer.parseInt(id_list[select - 1]);
				
				stmt.executeUpdate("DELETE FROM DB066_Elected_Officer WHERE ID = " +  id);
				
				conn.commit();
			}
			
			stmt.close();
			rs.close();
			
			go_back(conn, 4, true);
		}
		
		catch (SQLException se) {
			
			se.printStackTrace();
		}
		
		catch (Exception e) {
			
			e.printStackTrace();
		}
		
		finally {

			try {
				
				if (stmt != null) {

					stmt.close();
				}
				
				if (rs != null) {
				
					rs.close();
				}

				conn.rollback();
				
				go_back(conn, 4, false);
			} 
			
			catch (SQLException se) {
				
				se.printStackTrace();
			}
			
			catch (Exception e2) {
				
				e2.printStackTrace();
			}
			
		}
		
	}

	public static void function_analysis(Connection conn) { // 데이터베이스에 있는 데이터를 결과값과 분류기준을 입력받아서 분석하여 보여준다.
		
		Statement stmt = null;
		ResultSet rs = null;
		
		try {
			
			Scanner input = new Scanner(System.in);
			
			stmt = conn.createStatement();
			
			String pattern = ".##";
			
			DecimalFormat dformat = new DecimalFormat(pattern);
			
			System.out.println();
			System.out.println("원하는 결과의 번호를 입력하십시오.");
			System.out.println();
			System.out.println("1)재산");
			System.out.println("2)나이");
			System.out.println("3)퍼센트");
			
			int select = input.nextInt();
			
			switch (select) {
			
			case 1:
				
				System.out.println();
				System.out.println("분류할 기준의 번호를 입력하십시오.");
				System.out.println();
				System.out.println("1)최종학력");
				System.out.println("2)대학");
				System.out.println("3)전공");
				
				select = input.nextInt();
				
				if (select == 1) {
					
					System.out.println();
					System.out.println("<최종학력> / <인원수> / <재산평균>");
					System.out.println();
					
					rs = stmt.executeQuery("SELECT Highest_level_of_Education, COUNT(*), AVG(Property) FROM DB066_Elected_Officer_Total GROUP BY Highest_level_of_Education ORDER BY AVG(Property) DESC");
					
					while(rs.next()){
						
						System.out.println(rs.getString(1) + " / "+ rs.getInt(2) + "명 / " + dformat.format(rs.getFloat(3)) + "억");
					}
					
				}
				
				else if (select == 2) {
					
					System.out.println();
					System.out.println("<출신대학교> / <인원수> /<재산평균>");
					System.out.println();
					
					rs = stmt.executeQuery("SELECT University, COUNT(*), AVG(Property) FROM DB066_Elected_Officer_Total NATURAL JOIN DB066_University GROUP BY University ORDER BY AVG(Property) DESC");
					
					while(rs.next()){
						
						System.out.println(rs.getString(1) + " / " + rs.getInt(2) + "명 / " + dformat.format(rs.getFloat(3)) + "억");
					}
					
				}
				
				else if (select == 3) {
					
					System.out.println();
					System.out.println("<전공> / <인원수> /<재산평균>");
					System.out.println();
					
					rs = stmt.executeQuery("SELECT Major, COUNT(*), AVG(Property) FROM DB066_Elected_Officer_Total NATURAL JOIN DB066_Major GROUP BY Major ORDER BY AVG(Property) DESC");
					
					while(rs.next()){
						
						System.out.println(rs.getString(1) + " / " + rs.getInt(2) + "명 / " + dformat.format(rs.getFloat(3)) + "억");
					}
					
				}
				
				else if (select > 3 || select < 1) {
					
					stmt.close();
					rs.close();
					
					go_back(conn, 5, false);
				}
				
				break;
				
			case 2:
				
				System.out.println();
				System.out.println("분류할 기준의 번호를 입력하십시오.");
				System.out.println();
				System.out.println("1)정당");
				System.out.println("2)성향");
				System.out.println("3)성별");
				
				select = input.nextInt();
				
				if (select == 1) {
					
					System.out.println();
					System.out.println("<정당> / <나이>");
					System.out.println();
					
					rs = stmt.executeQuery("SELECT Party, AVG(Age) FROM DB066_Elected_Officer_Total GROUP BY Party ORDER BY AVG(Age) DESC");
					
					while(rs.next()){
						
						System.out.println(rs.getString(1) + " / " + dformat.format(rs.getFloat(2)) + "세");
					}
					
				}
				
				else if (select == 2) {
					
					System.out.println();
					System.out.println("<성향> / <나이>");
					System.out.println();
					
					rs = stmt.executeQuery("SELECT Propensity, AVG(Age) FROM DB066_Elected_Officer_Total NATURAL JOIN DB066_Party GROUP BY Propensity ORDER BY AVG(Age) DESC");
					
					while(rs.next()){
						
						System.out.println(rs.getString(1) + " / " + dformat.format(rs.getFloat(2)) + "세");
					}
					
				}
				
				else if (select == 3) {
					
					System.out.println();
					System.out.println("<성별> / <나이>");
					System.out.println();
					
					rs = stmt.executeQuery("SELECT Gender, AVG(Age) FROM DB066_Elected_Officer_Total GROUP BY Gender ORDER BY AVG(Age) DESC");
					
					while(rs.next()){
						
						System.out.println(rs.getString(1) + " / " + dformat.format(rs.getFloat(2)) + "세");
					}
					
				}
				
				else if (select < 1 || select > 3) {
					
					stmt.close();
					rs.close();
					
					go_back(conn, 5, false);
				}
				
				break;
				
			case 3:
				
				System.out.println();
				System.out.println("분류할 기준의 번호를 입력하여 주시기 바랍니다.");
				System.out.println();
				System.out.println("1)정당");
				System.out.println("2)정당&당선지역");
				System.out.println("3)정당&출생지역");
				System.out.println("4)출생지역");
				
				select = input.nextInt();
				
				if (select == 1) {
					
					System.out.println();
					System.out.println("<정당> / <퍼센트>");
					System.out.println();
					
					rs = stmt.executeQuery("SELECT Party, COUNT(Party) / (SELECT COUNT(*) FROM DB066_Elected_Officer_Total) * 100 FROM DB066_Elected_Officer_Total GROUP BY Party ORDER BY COUNT(Party) DESC");
					
					while(rs.next()){
						
						System.out.println(rs.getString(1) + " / " + dformat.format(rs.getFloat(2)) + "%");
					}
					
				}
				
				else if (select == 2) {
					
					System.out.println();
					System.out.println("<정당> / <당선지역> / <퍼센트>");
					System.out.println();
					
					rs = stmt.executeQuery("SELECT Party, Region, Count / Total * 100 FROM DB066_Percent_Constituency NATURAL JOIN DB066_Percent_C_Region");
					
					while(rs.next()){
						
						System.out.println(rs.getString(1) + " / " + rs.getString(2)  + " / " + dformat.format(rs.getFloat(3)) + "%");
					}
					
				}
				
				else if (select == 3) {

					System.out.println();
					System.out.println("<정당> / <출생지역> / <퍼센트>");
					System.out.println();
					
					rs = stmt.executeQuery("SELECT Party, Region, Count / Total * 100 FROM DB066_Percent_Constituency NATURAL JOIN DB066_Percent_C_Region");
					
					while(rs.next()){
						
						System.out.println(rs.getString(1) + " / " + rs.getString(2)  + " / " + dformat.format(rs.getFloat(3)) + "%");
					}
					
					
				}
				
				else if (select == 4) {
					
					System.out.println();
					System.out.println("<출생지역> / <퍼센트>");
					System.out.println();
					
					rs = stmt.executeQuery("SELECT Region, COUNT(Region) / (SELECT COUNT(*) FROM DB066_Elected_Officer_Total) * 100 FROM DB066_Elected_Officer_Total NATURAL JOIN DB066_Place_of_Birth GROUP BY Region ORDER BY COUNT(Region) DESC");
					
					while(rs.next()){
						
						System.out.println(rs.getString(1) + " / " + dformat.format(rs.getFloat(2)) + "%");
					}
					
				}
				
				else if (select > 4 || select < 1){
					
					stmt.close();
					rs.close();
					
					go_back(conn, 5, false);
				}
				
				break;
			}
			
			stmt.close();
			rs.close();
			
			go_back(conn, 5, true);
			
		}
		
		catch (SQLException se) {
			
			se.printStackTrace();
		}
		
		catch (Exception e) {
			
			e.printStackTrace();
		}
		
		finally {

			try {
				
				if (stmt != null) {

					stmt.close();
				}
				
				if (rs != null) {
				
					rs.close();
				}

				conn.rollback();
				
				go_back(conn, 5, false);
			} 
			
			catch (SQLException se) {
				
				se.printStackTrace();
			}
			
			catch (Exception e2) {
				
				e2.printStackTrace();
			}
			
		}
	}
	
	public static Connection getConnection() throws ClassNotFoundException, SQLException { // Java와 mySQL을 연동시켜준다.
		
		String url = "jdbc:mysql://localhost:3306/DB066Team06?useSSL=false";
		String user = "root";
		String password = "database";
		
		Connection conn = null;
		
		conn = DriverManager.getConnection(url, user, password);
		
		return conn;
	}

	public static void main(String[] args) throws ClassNotFoundException, SQLException { // 모든 기능이 실행되는 메인이다.
	
		Scanner input = new Scanner(System.in);
	
		Connection conn = getConnection();
	
		System.out.println();
		System.out.println("선출직 공무원 데이터 베이스 관리시스템입니다. 무엇을 도와드릴까요?");
		System.out.println();
		System.out.println("1)우리동네 국회의원&시도지사 알아보기");
		System.out.println("2)국회의원&시도지사 정보 수정하기");
		System.out.println("3)새로운 국회의원&시도지사 추가하기");
		System.out.println("4)국회의원&시도지사 제명하기");
		System.out.println("5)데이터 분석하기");
	
		int select = input.nextInt();
	
		if (select == 1) {
		
			function_inquiry(conn);
		}
	
		else if (select == 2) {
		
			function_update(conn);
		} 
	
		else if (select == 3) {
		
			function_addition(conn);
		} 
	
		else if (select == 4) {
		
			function_deletion(conn);
		}
	
		else if (select == 5) {
		
			function_analysis(conn);
		}
	
		else {
		
			System.out.println();
			System.out.println("번호를 잘못 입력하셨습니다.");
			
			main(null);
		}
	
	}

}