What schools are accredited by COE?
create table table_2064747_1 (location_s_ varchar, accreditation varchar, PRIMARY KEY (location_s_))
select location_s_ from table_2064747_1 where accreditation = "coe"