Table schema:
CREATE TABLE table_name_40 (dob VARCHAR, surname VARCHAR)

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