Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual DOB tem um Sobrenome de cresswell?
 ###Tabelas: CREATE TABLE scholarly_journals (scholarly_journals_id AUTO_INCREMENT PRIMARY KEY, ISSN VARCHAR, Language VARCHAR, Country VARCHAR, Frequency VARCHAR, Publication range VARCHAR, Status VARCHAR, Document Type VARCHAR) CREATE TABLE composition_of_the_15th_seanad (composition_of_the_15th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT) CREATE TABLE team_all-around (team_all-around_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Team VARCHAR, Floor Exercise INT, Pommel Horse INT, Rings INT, Vault INT, Parallel Bars INT, Horizontal Bar INT, Total INT) CREATE TABLE repechage_1 (repechage_1_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Rowers VARCHAR, Country VARCHAR, Time VARCHAR, Notes VARCHAR) CREATE TABLE player_roster (player_roster_id AUTO_INCREMENT PRIMARY KEY, Surname VARCHAR, First VARCHAR, D.O.B. VARCHAR, Bats VARCHAR, Throws VARCHAR, Position VARCHAR)  
SELECT D.O.B. FROM player_roster WHERE Surname = cresswell