CREATE TABLE table_name_49 (ihsaa_class VARCHAR2, location VARCHAR2)

Which IHSAA Class has a Location of columbia city?
SELECT ihsaa_class FROM table_name_49 WHERE location = "columbia city"
SELECT "ihsaa_class" FROM "table_name_49" WHERE "columbia city" = "location"