CREATE TABLE table_204_174 (id NUMBER, "rank" NUMBER, "name" CLOB, "nationality" CLOB, "result" NUMBER, "notes" CLOB)

who finished directly before lakmali ?
SELECT "name" FROM table_204_174 WHERE "rank" = (SELECT "rank" FROM table_204_174 WHERE "name" = 'nadeeka lakmali') - 1
SELECT "name" FROM "table_204_174" WHERE "rank" = (SELECT "rank" FROM "table_204_174" WHERE "name" = 'nadeeka lakmali') - 1