how many historic sites were listed before 1965 ?
CREATE TABLE table_204_423 (
    id number,
    "name" text,
    "location" text,
    "city" text,
    "listing date" text
)
SELECT COUNT("name") FROM table_204_423 WHERE "listing date" < 1965
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: how many historic sites were listed before 1965 ? ### Input: CREATE TABLE table_204_423 (
    id number,
    "name" text,
    "location" text,
    "city" text,
    "listing date" text
) ### Response: SELECT COUNT("name") FROM table_204_423 WHERE "listing date" < 1965