Tell me the degree for chemistry 1965
CREATE TABLE table_31588 (
    "Name" text,
    "Degree" text,
    "Degree Year" text,
    "Award Year" real,
    "Award" text
)
SELECT "Degree" FROM table_31588 WHERE "Award Year" = '1965' AND "Award" = 'chemistry'
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: Tell me the degree for chemistry 1965 ### Input: CREATE TABLE table_31588 (
    "Name" text,
    "Degree" text,
    "Degree Year" text,
    "Award Year" real,
    "Award" text
) ### Response: SELECT "Degree" FROM table_31588 WHERE "Award Year" = '1965' AND "Award" = 'chemistry'