query.md

CREATE TABLE areas ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, region VARCHAR(255) NOT NULL ); INSERT INTO areas (name, region) VALUES ('서울', '강남구'); INSERT INTO areas (name, region) VALUES ('서울', '마포구'); INSERT INTO areas (name, region) VALUES ('서울', '종로구');
INSERT INTO areas (name, region) VALUES ('서울', '용산구');
INSERT INTO areas (name, region) VALUES ('서울', '성동구');
INSERT INTO areas (name, region) VALUES ('서울', '중구');
INSERT INTO areas (name, region) VALUES ('서울', '송파구');
INSERT INTO areas (name, region) VALUES ('서울', '서대문구');
INSERT INTO areas (name, region) VALUES ('서울', '서초구');
INSERT INTO areas (name, region) VALUES ('서울', '영등포구');
INSERT INTO areas (name, region) VALUES ('서울', '광진구');
INSERT INTO areas (name, region) VALUES ('서울', '성북구');
INSERT INTO areas (name, region) VALUES ('서울', '관악구');
INSERT INTO areas (name, region) VALUES ('서울', '은평구');
INSERT INTO areas (name, region) VALUES ('서울', '동작구');
INSERT INTO areas (name, region) VALUES ('서울', '강서구');
INSERT INTO areas (name, region) VALUES ('서울', '동대문구');
INSERT INTO areas (name, region) VALUES ('서울', '강동구');
INSERT INTO areas (name, region) VALUES ('서울', '노원구');
INSERT INTO areas (name, region) VALUES ('서울', '중랑구');
INSERT INTO areas (name, region) VALUES ('서울', '강북구');
INSERT INTO areas (name, region) VALUES ('서울', '구로구');
INSERT INTO areas (name, region) VALUES ('서울', '양천구'); INSERT INTO areas (name, region) VALUES ('서울', '금천구'); INSERT INTO areas (name, region) VALUES ('서울', '동봉구');
INSERT INTO areas (name, region) VALUES ('경기도', '수원시'); INSERT INTO areas (name, region) VALUES ('경기도', '고양시'); INSERT INTO areas (name, region) VALUES ('경기도', '성남시'); INSERT INTO areas (name, region) VALUES ('경기도', '용인시'); INSERT INTO areas (name, region) VALUES ('경기도', '파주시'); INSERT INTO areas (name, region) VALUES ('경기도', '화성시'); INSERT INTO areas (name, region) VALUES ('경기도', '남양주시'); INSERT INTO areas (name, region) VALUES ('경기도', '안산시'); INSERT INTO areas (name, region) VALUES ('경기도', '양평군'); INSERT INTO areas (name, region) VALUES ('경기도', '시흥시'); INSERT INTO areas (name, region) VALUES ('경기도', '김포시'); INSERT INTO areas (name, region) VALUES ('경기도', '가평군'); INSERT INTO areas (name, region) VALUES ('경기도', '평택시'); INSERT INTO areas (name, region) VALUES ('경기도', '의왕시'); INSERT INTO areas (name, region) VALUES ('경기도', '하남시'); INSERT INTO areas (name, region) VALUES ('경기도', '안양시'); INSERT INTO areas (name, region) VALUES ('경기도', '양주시'); INSERT INTO areas (name, region) VALUES ('경기도', '부천시'); INSERT INTO areas (name, region) VALUES ('경기도', '광주시'); INSERT INTO areas (name, region) VALUES ('경기도', '안성시'); INSERT INTO areas (name, region) VALUES ('경기도', '의정부시'); INSERT INTO areas (name, region) VALUES ('경기도', '이천시'); INSERT INTO areas (name, region) VALUES ('경기도', '여주시'); INSERT INTO areas (name, region) VALUES ('경기도', '포천시'); INSERT INTO areas (name, region) VALUES ('경기도', '오산시'); INSERT INTO areas (name, region) VALUES ('경기도', '광명시'); INSERT INTO areas (name, region) VALUES ('경기도', '연천군'); INSERT INTO areas (name, region) VALUES ('경기도', '동두천시');
INSERT INTO areas (name, region) VALUES ('경기도', '구리시'); INSERT INTO areas (name, region) VALUES ('경기도', '과천시'); INSERT INTO areas (name, region) VALUES ('경기도', '군포시'); INSERT INTO areas (name, region) VALUES ('제주도', '제주시'); INSERT INTO areas (name, region) VALUES ('제주도', '서귀포시'); INSERT INTO areas (name, region) VALUES ('대전', '대덕구'); INSERT INTO areas (name, region) VALUES ('대전', '동구'); INSERT INTO areas (name, region) VALUES ('대전', '서구'); INSERT INTO areas (name, region) VALUES ('대전', '유성구'); INSERT INTO areas (name, region) VALUES ('대전', '중구'); INSERT INTO areas (name, region) VALUES ('대전', '관저2동'); INSERT INTO areas (name, region) VALUES ('부산', '부산진구'); INSERT INTO areas (name, region) VALUES ('부산', '해운대구'); INSERT INTO areas (name, region) VALUES ('부산', '수영구'); INSERT INTO areas (name, region) VALUES ('부산', '기장군'); INSERT INTO areas (name, region) VALUES ('부산', '영도구'); INSERT INTO areas (name, region) VALUES ('부산', '중구'); INSERT INTO areas (name, region) VALUES ('부산', '동래구'); INSERT INTO areas (name, region) VALUES ('부산', '남구'); INSERT INTO areas (name, region) VALUES ('부산', '동구'); INSERT INTO areas (name, region) VALUES ('부산', '북구'); INSERT INTO areas (name, region) VALUES ('부산', '강서구'); INSERT INTO areas (name, region) VALUES ('부산', '금정구'); INSERT INTO areas (name, region) VALUES ('부산', '연제구'); INSERT INTO areas (name, region) VALUES ('부산', '사하구'); INSERT INTO areas (name, region) VALUES ('부산', '서구'); INSERT INTO areas (name, region) VALUES ('부산', '사상구'); INSERT INTO areas (name, region) VALUES ('강원도', '강릉시'); INSERT INTO areas (name, region) VALUES ('강원도', '춘천시'); INSERT INTO areas (name, region) VALUES ('강원도', '속초시'); INSERT INTO areas (name, region) VALUES ('강원도', '양양군'); INSERT INTO areas (name, region) VALUES ('강원도', '고성군'); INSERT INTO areas (name, region) VALUES ('강원도', '원주시'); INSERT INTO areas (name, region) VALUES ('강원도', '동해시'); INSERT INTO areas (name, region) VALUES ('강원도', '삼척시'); INSERT INTO areas (name, region) VALUES ('강원도', '홍천군'); INSERT INTO areas (name, region) VALUES ('강원도', '평창군'); INSERT INTO areas (name, region) VALUES ('강원도', '인제군'); INSERT INTO areas (name, region) VALUES ('강원도', '정선군'); INSERT INTO areas (name, region) VALUES ('강원도', '영월군'); INSERT INTO areas (name, region) VALUES ('강원도', '횡성군'); INSERT INTO areas (name, region) VALUES ('강원도', '태백시'); INSERT INTO areas (name, region) VALUES ('강원도', '철원군'); INSERT INTO areas (name, region) VALUES ('대구', '중구'); INSERT INTO areas (name, region) VALUES ('대구', '수성구'); INSERT INTO areas (name, region) VALUES ('대구', '동구'); INSERT INTO areas (name, region) VALUES ('대구', '북구'); INSERT INTO areas (name, region) VALUES ('대구', '남구'); INSERT INTO areas (name, region) VALUES ('대구', '달서구'); INSERT INTO areas (name, region) VALUES ('대구', '달성군'); INSERT INTO areas (name, region) VALUES ('대구', '서구');
INSERT INTO areas (name, region) VALUES ('경상북도', '경주시'); INSERT INTO areas (name, region) VALUES ('경상북도', '포항시'); INSERT INTO areas (name, region) VALUES ('경상북도', '경산시'); INSERT INTO areas (name, region) VALUES ('경상북도', '울릉군'); INSERT INTO areas (name, region) VALUES ('경상북도', '안동시'); INSERT INTO areas (name, region) VALUES ('경상북도', '청도군'); INSERT INTO areas (name, region) VALUES ('경상북도', '구미시'); INSERT INTO areas (name, region) VALUES ('경상북도', '문경시'); INSERT INTO areas (name, region) VALUES ('경상북도', '영주시'); INSERT INTO areas (name, region) VALUES ('경상북도', '칠곡군'); INSERT INTO areas (name, region) VALUES ('경상북도', '상주시'); INSERT INTO areas (name, region) VALUES ('경상북도', '봉화군'); INSERT INTO areas (name, region) VALUES ('경상북도', '울진군'); INSERT INTO areas (name, region) VALUES ('경상북도', '군위군'); INSERT INTO areas (name, region) VALUES ('경상북도', '영덕군'); INSERT INTO areas (name, region) VALUES ('경상북도', '성주군'); INSERT INTO areas (name, region) VALUES ('경상북도', '예천군'); INSERT INTO areas (name, region) VALUES ('경상북도', '청송군'); INSERT INTO areas (name, region) VALUES ('경상북도', '영천시'); INSERT INTO areas (name, region) VALUES ('경상북도', '영양군'); INSERT INTO areas (name, region) VALUES ('충청남도', '천안시'); INSERT INTO areas (name, region) VALUES ('충청남도', '아산시'); INSERT INTO areas (name, region) VALUES ('충청남도', '공주시'); INSERT INTO areas (name, region) VALUES ('충청남도', '서산시'); INSERT INTO areas (name, region) VALUES ('충청남도', '예산군'); INSERT INTO areas (name, region) VALUES ('충청남도', '태안군'); INSERT INTO areas (name, region) VALUES ('충청남도', '당진시'); INSERT INTO areas (name, region) VALUES ('충청남도', '보령시'); INSERT INTO areas (name, region) VALUES ('충청남도', '논산시'); INSERT INTO areas (name, region) VALUES ('충청남도', '홍성군'); INSERT INTO areas (name, region) VALUES ('충청남도', '금산군'); INSERT INTO areas (name, region) VALUES ('충청남도', '서천군'); INSERT INTO areas (name, region) VALUES ('충청남도', '청양군'); INSERT INTO areas (name, region) VALUES ('경상남도', '창원시'); INSERT INTO areas (name, region) VALUES ('경상남도', '거제시'); INSERT INTO areas (name, region) VALUES ('경상남도', '김해시'); INSERT INTO areas (name, region) VALUES ('경상남도', '남해군'); INSERT INTO areas (name, region) VALUES ('경상남도', '진주시'); INSERT INTO areas (name, region) VALUES ('경상남도', '통영시'); INSERT INTO areas (name, region) VALUES ('경상남도', '하동군'); INSERT INTO areas (name, region) VALUES ('경상남도', '밀양시'); INSERT INTO areas (name, region) VALUES ('경상남도', '함안군'); INSERT INTO areas (name, region) VALUES ('경상남도', '양산시'); INSERT INTO areas (name, region) VALUES ('경상남도', '창녕군'); INSERT INTO areas (name, region) VALUES ('경상남도', '사천시'); INSERT INTO areas (name, region) VALUES ('경상남도', '함양군'); INSERT INTO areas (name, region) VALUES ('경상남도', '합천군'); INSERT INTO areas (name, region) VALUES ('경상남도', '고성군'); INSERT INTO areas (name, region) VALUES ('경상남도', '산청군'); INSERT INTO areas (name, region) VALUES ('경상남도', '거창군'); INSERT INTO areas (name, region) VALUES ('인천', '중구'); INSERT INTO areas (name, region) VALUES ('인천', '남동구'); INSERT INTO areas (name, region) VALUES ('인천', '연수구'); INSERT INTO areas (name, region) VALUES ('인천', '서구'); INSERT INTO areas (name, region) VALUES ('인천', '부평구'); INSERT INTO areas (name, region) VALUES ('인천', '강화군'); INSERT INTO areas (name, region) VALUES ('인천', '동구'); INSERT INTO areas (name, region) VALUES ('인천', '옹진군'); INSERT INTO areas (name, region) VALUES ('인천', '계양구'); INSERT INTO areas (name, region) VALUES ('인천', '미추홀구'); INSERT INTO areas (name, region) VALUES ('전라남도', '여수시'); INSERT INTO areas (name, region) VALUES ('전라남도', '담양군'); INSERT INTO areas (name, region) VALUES ('전라남도', '순천시'); INSERT INTO areas (name, region) VALUES ('전라남도', '목포시'); INSERT INTO areas (name, region) VALUES ('전라남도', '구례군'); INSERT INTO areas (name, region) VALUES ('전라남도', '강진군'); INSERT INTO areas (name, region) VALUES ('전라남도', '나주시'); INSERT INTO areas (name, region) VALUES ('전라남도', '신안군'); INSERT INTO areas (name, region) VALUES ('전라남도', '화순군'); INSERT INTO areas (name, region) VALUES ('전라남도', '해남군'); INSERT INTO areas (name, region) VALUES ('전라남도', '장성군'); INSERT INTO areas (name, region) VALUES ('전라남도', '광양시'); INSERT INTO areas (name, region) VALUES ('전라남도', '보성군'); INSERT INTO areas (name, region) VALUES ('전라남도', '완도군'); INSERT INTO areas (name, region) VALUES ('전라남도', '무안군'); INSERT INTO areas (name, region) VALUES ('전라남도', '고흥군'); INSERT INTO areas (name, region) VALUES ('전라남도', '곡성군'); INSERT INTO areas (name, region) VALUES ('전라남도', '진도군'); INSERT INTO areas (name, region) VALUES ('전라남도', '장흥군'); INSERT INTO areas (name, region) VALUES ('전라남도', '영광군'); INSERT INTO areas (name, region) VALUES ('광주', '동구'); INSERT INTO areas (name, region) VALUES ('광주', '북구'); INSERT INTO areas (name, region) VALUES ('광주', '광산구'); INSERT INTO areas (name, region) VALUES ('광주', '남구'); INSERT INTO areas (name, region) VALUES ('광주', '서구'); INSERT INTO areas (name, region) VALUES ('충청북도', '청주시'); INSERT INTO areas (name, region) VALUES ('충청북도', '제천시'); INSERT INTO areas (name, region) VALUES ('충청북도', '충주시'); INSERT INTO areas (name, region) VALUES ('충청북도', '진천군'); INSERT INTO areas (name, region) VALUES ('충청북도', '단양군'); INSERT INTO areas (name, region) VALUES ('충청북도', '괴산군'); INSERT INTO areas (name, region) VALUES ('충청북도', '옥천군'); INSERT INTO areas (name, region) VALUES ('충청북도', '증평군'); INSERT INTO areas (name, region) VALUES ('충청북도', '보은군'); INSERT INTO areas (name, region) VALUES ('충청북도', '영동군'); INSERT INTO areas (name, region) VALUES ('전라북도', '전주시'); INSERT INTO areas (name, region) VALUES ('전라북도', '군산시'); INSERT INTO areas (name, region) VALUES ('전라북도', '익산시'); INSERT INTO areas (name, region) VALUES ('전라북도', '무주군'); INSERT INTO areas (name, region) VALUES ('전라북도', '완주군'); INSERT INTO areas (name, region) VALUES ('전라북도', '부안군'); INSERT INTO areas (name, region) VALUES ('전라북도', '정읍시'); INSERT INTO areas (name, region) VALUES ('전라북도', '고창군'); INSERT INTO areas (name, region) VALUES ('전라북도', '남원시'); INSERT INTO areas (name, region) VALUES ('전라북도', '김제시'); INSERT INTO areas (name, region) VALUES ('전라북도', '임실군'); INSERT INTO areas (name, region) VALUES ('전라북도', '진안군');
INSERT INTO areas (name, region) VALUES ('울산', '남구'); INSERT INTO areas (name, region) VALUES ('울산', '중구'); INSERT INTO areas (name, region) VALUES ('울산', '울주군'); INSERT INTO areas (name, region) VALUES ('울산', '남구'); INSERT INTO areas (name, region) VALUES ('울산', '동구'); INSERT INTO areas (name, region) VALUES ('울산', '북구'); INSERT INTO areas (name, region) VALUES ('세종', '새롬동'); INSERT INTO areas (name, region) VALUES ('세종', '금남면'); INSERT INTO areas (name, region) VALUES ('세종', '조치원읍'); INSERT INTO areas (name, region) VALUES ('세종', '세종동'); INSERT INTO areas (name, region) VALUES ('세종', '고운동'); INSERT INTO areas (name, region) VALUES ('세종', '도담동'); INSERT INTO areas (name, region) VALUES ('세종', '반곡동'); INSERT INTO areas (name, region) VALUES ('세종', '종촌동'); INSERT INTO areas (name, region) VALUES ('세종', '장군면'); INSERT INTO areas (name, region) VALUES ('세종', '연서면'); INSERT INTO areas (name, region) VALUES ('세종', '한솔동'); INSERT INTO areas (name, region) VALUES ('세종', '보람동'); INSERT INTO areas (name, region) VALUES ('세종', '집현동'); INSERT INTO areas (name, region) VALUES ('세종', '연기면'); INSERT INTO areas (name, region) VALUES ('세종', '대평동');