select count(0)
-- delete
  from zipcode
 where sido like '%강원%';

select *
  from zipcode
 where sido='서울특별시'
   and law_dong_name='양재동';

select distinct sido from zipcode;

SELECT building_manage, COUNT(0) cnt
  FROM zipcode
GROUP BY building_manage
HAVING cnt > 1;

select
  m.name, z.sido, z.sigun, z.doro_name,
  z.building_main, z.building_sub
  from member m, zipcode z
 where m.address = z.building_manage;

 select
  m.name, concat(z.sido, ' ', z.sigun, ' ', z.doro_name, ' ',
  z.building_main, '-', z.building_sub) addr
  from member m, zipcode z
 where m.address = z.building_manage;