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

who scored more than liliya dusmetova but less than lee young sun ?
SELECT "name" FROM table_204_174 WHERE "result" > (SELECT "result" FROM table_204_174 WHERE "name" = 'liliya dusmetova') AND "result" < (SELECT "result" FROM table_204_174 WHERE "name" = 'lee young-sun')
SELECT "name" FROM "table_204_174" WHERE "result" < (SELECT "result" FROM "table_204_174" WHERE "name" = 'lee young-sun') AND "result" > (SELECT "result" FROM "table_204_174" WHERE "name" = 'liliya dusmetova')