CREATE TABLE table_204_148 (id NUMBER, "name" CLOB, "elected" CLOB, "term began" CLOB, "term ended" CLOB)

who was the mayor before jordan ?
SELECT "name" FROM table_204_148 WHERE "term began" < (SELECT "term began" FROM table_204_148 WHERE "name" = 'john t. jordan') ORDER BY "term began" DESC LIMIT 1
SELECT "name" FROM "table_204_148" WHERE "term began" < (SELECT "term began" FROM "table_204_148" WHERE "name" = 'john t. jordan') ORDER BY "term began" DESC FETCH FIRST 1 ROWS ONLY