CREATE TABLE table_204_475 (id DECIMAL, "home team" TEXT, "score" TEXT, "away team" TEXT, "date" TEXT, "agg" TEXT)

what home team is above clydebank ?
SELECT "home team" FROM table_204_475 WHERE id = (SELECT id FROM table_204_475 WHERE "home team" = 'clydebank') - 1
SELECT "home team" FROM "table_204_475" WHERE "id" = (SELECT "id" FROM "table_204_475" WHERE "home team" = 'clydebank') - 1