CREATE TABLE table_78897 ("Name" CLOB, "Wins" FLOAT, "Start" CLOB, "Duration" CLOB, "Defeated by" CLOB)

Which duration was defeated by retired?
SELECT "Duration" FROM table_78897 WHERE "Defeated by" = 'retired'
SELECT "Duration" FROM "table_78897" WHERE "Defeated by" = 'retired'