CREATE TABLE table_204_952 (id NUMBER, "rank" NUMBER, "player" CLOB, "county" CLOB, "tally" CLOB, "total" NUMBER, "opposition" CLOB)

who ranked above mark corrigan ?
SELECT "player" FROM table_204_952 WHERE "rank" = (SELECT "rank" FROM table_204_952 WHERE "player" = 'mark corrigan') - 1
SELECT "player" FROM "table_204_952" WHERE "rank" = (SELECT "rank" FROM "table_204_952" WHERE "player" = 'mark corrigan') - 1