CREATE TABLE table_name_40 (dob VARCHAR2, surname VARCHAR2)

Which DOB has a Surname of cresswell?
SELECT dob FROM table_name_40 WHERE surname = "cresswell"
SELECT "dob" FROM "table_name_40" WHERE "cresswell" = "surname"