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 é a data de nascimento com o final do prazo sendo 5 de julho de 1978
 ###Tabelas: CREATE TABLE ghanaian_presidents'_ages (ghanaian_presidents'_ages_id AUTO_INCREMENT PRIMARY KEY, # INT, President VARCHAR, Date of birth VARCHAR, Date of inauguration VARCHAR, Age at inauguration VARCHAR, End of term VARCHAR, Length of retirement VARCHAR, Date of death VARCHAR, Lifespan VARCHAR) CREATE TABLE games_for_zrinjski_in_european_competitions (games_for_zrinjski_in_european_competitions_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Venue VARCHAR, Opponent VARCHAR, Score VARCHAR, Scorers VARCHAR, Competition VARCHAR) CREATE TABLE singles:_7_3–4 (singles:_7_3–4_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Opponent VARCHAR, Score VARCHAR) CREATE TABLE 2005_nfl_draft (2005_nfl_draft_id AUTO_INCREMENT PRIMARY KEY, Round INT, Overall INT, Player VARCHAR, Position VARCHAR, College VARCHAR) CREATE TABLE during_regular_season (during_regular_season_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Outgoing manager VARCHAR, Manner of departure VARCHAR, Date of vacancy VARCHAR, Replaced by VARCHAR, Date of appointment VARCHAR, Position in table VARCHAR)  
SELECT Date of birth FROM ghanaian_presidents'_ages WHERE End of term = 5July1978