CodeCharge TAIWAN

insert city (city) select city from postcode group by city order by city;

insert local (local,zip) select local,city from postcode group by city,local order by city,local;