CREATE TABLE table_204_11 (id NUMBER, "year" NUMBER, "fbs opponent" CLOB, "result" CLOB, "opponent's conference" CLOB, "opponent's head coach" CLOB, "charleston southern's head coach" CLOB)

who was the longest head coach ?
SELECT "charleston southern's head coach" FROM table_204_11 GROUP BY "charleston southern's head coach" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "charleston southern's head coach" FROM "table_204_11" GROUP BY "charleston southern's head coach" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY