CREATE TABLE table_204_47 (id NUMBER, "outcome" CLOB, "no." NUMBER, "date" CLOB, "tournament" CLOB, "surface" CLOB, "partner" CLOB, "opponents" CLOB, "score" CLOB)

what was the date of the last tournament ?
SELECT "date" FROM table_204_47 ORDER BY "date" DESC LIMIT 1
SELECT "date" FROM "table_204_47" ORDER BY "date" DESC FETCH FIRST 1 ROWS ONLY