which football club had its most recent promotion a year before the heidelberg football club ?
CREATE TABLE table_204_959 (
    id number,
    "club" text,
    "founded" number,
    "nickname" text,
    "location" text,
    "home ground" text,
    "entered competition" number,
    "most recent promotion" number
)
SELECT "club" FROM table_204_959 WHERE "most recent promotion" = (SELECT "most recent promotion" FROM table_204_959 WHERE "club" = 'heidelberg football club') - 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: which football club had its most recent promotion a year before the heidelberg football club ? ### Input: CREATE TABLE table_204_959 (
    id number,
    "club" text,
    "founded" number,
    "nickname" text,
    "location" text,
    "home ground" text,
    "entered competition" number,
    "most recent promotion" number
) ### Response: SELECT "club" FROM table_204_959 WHERE "most recent promotion" = (SELECT "most recent promotion" FROM table_204_959 WHERE "club" = 'heidelberg football club') - 1