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)

lesnar beat herring in ufc 87 , in what event was his previous win ?
SELECT "event" FROM table_204_363 WHERE "res." = 'win' AND "date" < (SELECT "date" FROM table_204_363 WHERE "event" = 'ufc 87') ORDER BY "date" DESC LIMIT 1
SELECT "event" FROM "table_204_363" WHERE "date" < (SELECT "date" FROM "table_204_363" WHERE "event" = 'ufc 87') AND "res." = 'win' ORDER BY "date" DESC FETCH FIRST 1 ROWS ONLY