Name who wrote the episode directed by patrick duffy airing on november 7, 1997
CREATE TABLE table_2468961_8 (
    written_by VARCHAR,
    directed_by VARCHAR,
    original_air_date VARCHAR
)
SELECT written_by FROM table_2468961_8 WHERE directed_by = "Patrick Duffy" AND original_air_date = "November 7, 1997"
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: Name who wrote the episode directed by patrick duffy airing on november 7, 1997 ### Input: CREATE TABLE table_2468961_8 (
    written_by VARCHAR,
    directed_by VARCHAR,
    original_air_date VARCHAR
) ### Response: SELECT written_by FROM table_2468961_8 WHERE directed_by = "Patrick Duffy" AND original_air_date = "November 7, 1997"