What is the party affiliation for Senator David Goodman?
CREATE TABLE table_3472 (
    "District" real,
    "Senator" text,
    "Party" text,
    "Residence" text,
    "First elected" text,
    "Term Limited" real
)
SELECT "Party" FROM table_3472 WHERE "Senator" = 'David Goodman'
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: What is the party affiliation for Senator David Goodman? ### Input: CREATE TABLE table_3472 (
    "District" real,
    "Senator" text,
    "Party" text,
    "Residence" text,
    "First elected" text,
    "Term Limited" real
) ### Response: SELECT "Party" FROM table_3472 WHERE "Senator" = 'David Goodman'