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 governador teve William Henry Ashley como vice-governador?
 ###Tabelas: CREATE TABLE governors_of_missouri (governors_of_missouri_id AUTO_INCREMENT PRIMARY KEY, Governor VARCHAR, Took office VARCHAR, Left office VARCHAR, Party VARCHAR, Lieutenant Governor VARCHAR, Terms VARCHAR) CREATE TABLE sixteenth_round (sixteenth_round_id AUTO_INCREMENT PRIMARY KEY, Pick INT, Team VARCHAR, Player VARCHAR, Position VARCHAR, College VARCHAR) CREATE TABLE nominal_morphology (nominal_morphology_id AUTO_INCREMENT PRIMARY KEY, Case/Suffix VARCHAR, we two VARCHAR, you and I VARCHAR, you two VARCHAR, them two (the two) VARCHAR, who-two VARCHAR) CREATE TABLE force_composition (force_composition_id AUTO_INCREMENT PRIMARY KEY, NATO member VARCHAR, Aircraft carriers VARCHAR, Battleships VARCHAR, Cruisers VARCHAR, Escorts VARCHAR, Submarines VARCHAR, Torpedo boat squadrons VARCHAR, s Motor ship / s Naval trawler VARCHAR, Grand Total INT) CREATE TABLE championship_teams_and_drivers (championship_teams_and_drivers_id AUTO_INCREMENT PRIMARY KEY, Constructor VARCHAR, Chassis VARCHAR, Engine VARCHAR, Tyre VARCHAR, Driver VARCHAR, Rounds VARCHAR)  
SELECT Governor FROM governors_of_missouri WHERE Lieutenant Governor = william henry ashley