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"