CREATE TABLE table_2064747_1 (location_s_ VARCHAR, accreditation VARCHAR)

What schools are accredited by COE?
SELECT location_s_ FROM table_2064747_1 WHERE accreditation = "COE"
SELECT "location_s_" FROM "table_2064747_1" WHERE "COE" = "accreditation"