CREATE TABLE table_204_846 (id NUMBER, "tie no" NUMBER, "home team" CLOB, "score" CLOB, "away team" CLOB, "attendance" NUMBER)

what is the difference in attendance in tie no 1 and 4 ?
SELECT ABS((SELECT "attendance" FROM table_204_846 WHERE "tie no" = 1) - (SELECT "attendance" FROM table_204_846 WHERE "tie no" = 4))
SELECT ABS((SELECT "attendance" FROM "table_204_846" WHERE "tie no" = 1) - (SELECT "attendance" FROM "table_204_846" WHERE "tie no" = 4))