Table: alabama_ag_mech_university
Columns: school
location_s
control
type_school_types_are_based_on_the_carnegie_classification_of_institutions_of_higher_education
enrollment_fall_2010
founded
accreditation

Question: What schools are accredited by COE?
SQL: SELECT "location_s" FROM alabama_ag_mech_university WHERE "accreditation" = 'COE'

Question: Where was there a school founded in 1927?
SQL: SELECT "location_s" FROM alabama_ag_mech_university WHERE "founded" = 1927