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: quantos presidentes com data de posse em 4 de junho de 1979
 ###Tabelas: CREATE TABLE list_of_some_notable_incidents_involving_time_bombs (list_of_some_notable_incidents_involving_time_bombs_id AUTO_INCREMENT PRIMARY KEY, Year INT, Event VARCHAR, Location VARCHAR, Perpetrator(s) VARCHAR, Deaths VARCHAR) CREATE TABLE installations (installations_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Park VARCHAR, Country VARCHAR, Inversions INT, Opened VARCHAR, Status VARCHAR) 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 doubles_titles_23 (doubles_titles_23_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date INT, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score in the final VARCHAR) CREATE TABLE current_fleet_roster (current_fleet_roster_id AUTO_INCREMENT PRIMARY KEY, Builder VARCHAR, Model VARCHAR, Length (ft/m) VARCHAR, Order Year VARCHAR, Fuel Propulsion VARCHAR, Fleet Series (Quantity) VARCHAR)  
SELECT COUNT President FROM ghanaian_presidents'_ages WHERE Date of inauguration = 4June1979