CREATE TABLE table_204_846 (id DECIMAL, "tie no" DECIMAL, "home team" TEXT, "score" TEXT, "away team" TEXT, "attendance" DECIMAL)

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))