CREATE TABLE table_203_593 (id NUMBER, "tenure" CLOB, "coach" CLOB, "years" NUMBER, "record" CLOB, "pct." NUMBER, "ncaa tournament" NUMBER)

who was coach before porter grant ?
SELECT "coach" FROM table_203_593 WHERE "tenure" < (SELECT "tenure" FROM table_203_593 WHERE "coach" = 'porter grant') ORDER BY "tenure" DESC LIMIT 1
SELECT "coach" FROM "table_203_593" WHERE "tenure" < (SELECT "tenure" FROM "table_203_593" WHERE "coach" = 'porter grant') ORDER BY "tenure" DESC FETCH FIRST 1 ROWS ONLY