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

what home team is above gloucester city ?
SELECT "home team" FROM table_204_146 WHERE id = (SELECT id FROM table_204_146 WHERE "home team" = 'gloucester city') - 1
SELECT "home team" FROM "table_204_146" WHERE "id" = (SELECT "id" FROM "table_204_146" WHERE "home team" = 'gloucester city') - 1