#select distinct(Field5) as "CC", Field6 as "Country" from tempDB order by CC;

insert into country (cc, country) select distinct(Field5) as "CC", Field6 as "Country" from tempDB;
insert into country values ("O1","");
insert into country values ("CC","Cocos (Keeling) Islands");
insert into country values ("CX","Christmas Islands");
insert into country values ("EH","Western Sahara");
insert into country values ("GS","South Georgia and the South Sandwich Islands (SGSSI");
insert into country values ("PM","Saint-Pierre and Miquelon");
insert into country values ("SH","Saintt Helena");
insert into country values ("SJ","Svalbard and Jan Mayen");
insert into country values ("TF","French Southern Territories");

#select * from country order by cc;
