Who was the home team for the away game that Canvey Island played?
CREATE TABLE table_50974 (
    "Tie no" text,
    "Home team" text,
    "Score" text,
    "Away team" text,
    "Attendance" text
)
SELECT "Home team" FROM table_50974 WHERE "Away team" = 'canvey island'
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: Who was the home team for the away game that Canvey Island played? ### Input: CREATE TABLE table_50974 (
    "Tie no" text,
    "Home team" text,
    "Score" text,
    "Away team" text,
    "Attendance" text
) ### Response: SELECT "Home team" FROM table_50974 WHERE "Away team" = 'canvey island'