CREATE TABLE table_204_363 (id NUMBER, "res." CLOB, "record" CLOB, "opponent" CLOB, "method" CLOB, "event" CLOB, "date" CLOB, "round" NUMBER, "time" CLOB, "location" CLOB, "notes" CLOB)

which event comes before dynamite !! usa ?
SELECT "event" FROM table_204_363 WHERE id = (SELECT id FROM table_204_363 WHERE "event" = 'dynamite!! usa') - 1
SELECT "event" FROM "table_204_363" WHERE "id" = (SELECT "id" FROM "table_204_363" WHERE "event" = 'dynamite!! usa') - 1