CREATE TABLE table_203_780 (id NUMBER, "rank" NUMBER, "diver" CLOB, "preliminary\ points" NUMBER, "preliminary\ rank" NUMBER, "final\ points" NUMBER, "final\ rank" NUMBER, "final\ total" NUMBER)

what is the difference in the total score between first and second place ?
SELECT ABS((SELECT "final\ntotal" FROM table_203_780 WHERE "rank" = 1) - (SELECT "final\ntotal" FROM table_203_780 WHERE "rank" = 2))
SELECT ABS((SELECT "final\ntotal" FROM "table_203_780" WHERE "rank" = 1) - (SELECT "final\ntotal" FROM "table_203_780" WHERE "rank" = 2))