user: ### NOW ANSWER:
Question: Which DOB has a Surname of Cresswell?
Columns: ['Surname', 'First', 'D.O.B.', 'Bats', 'Throws', 'Position']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Brice', 'Tom', '24 August 1981', 'L', 'L', 'OF']
SQL:

assistant: SELECT "D.O.B." FROM "Table" WHERE "Surname" = 'Cresswell';