CREATE TABLE table_204_469 (id NUMBER, "coach" CLOB, "years" CLOB, "seasons" NUMBER, "wins" NUMBER, "losses" NUMBER, "ties" NUMBER, "pct" NUMBER)

who was the last coach to only have 1 loss ?
SELECT "coach" FROM table_204_469 WHERE "losses" = 1 ORDER BY "years" DESC LIMIT 1
SELECT "coach" FROM "table_204_469" WHERE "losses" = 1 ORDER BY "years" DESC FETCH FIRST 1 ROWS ONLY