CREATE TABLE table_name_4 (ihsaa_class VARCHAR2, school VARCHAR2)

Which IHSAA Class has a School of mitchell?
SELECT ihsaa_class FROM table_name_4 WHERE school = "mitchell"
SELECT "ihsaa_class" FROM "table_name_4" WHERE "mitchell" = "school"