CREATE TABLE table_204_684 (id NUMBER, "wrestler:" CLOB, "times:" NUMBER, "date:" CLOB, "location:" CLOB, "notes:" CLOB)

who is listed before keith walker ?
SELECT "wrestler:" FROM table_204_684 WHERE id = (SELECT id FROM table_204_684 WHERE "wrestler:" = 'keith walker') - 1
SELECT "wrestler:" FROM "table_204_684" WHERE "id" = (SELECT "id" FROM "table_204_684" WHERE "wrestler:" = 'keith walker') - 1