CREATE TABLE table_31588 ("Name" TEXT, "Degree" TEXT, "Degree Year" TEXT, "Award Year" FLOAT, "Award" TEXT)

Tell me the degree for chemistry 1965
SELECT "Degree" FROM table_31588 WHERE "Award Year" = '1965' AND "Award" = 'chemistry'
SELECT "Degree" FROM "table_31588" WHERE "Award Year" = '1965' AND "Award" = 'chemistry'