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 vaga aconteceu em 4 de novembro de 2008?
 ###Tabelas: CREATE TABLE nevada_places_ranked_by_per_capita_income (nevada_places_ranked_by_per_capita_income_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Place VARCHAR, County VARCHAR, Per Capita Income VARCHAR, Median House- hold Income VARCHAR, Population INT, Number of Households INT) CREATE TABLE managerial_changes (managerial_changes_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) CREATE TABLE winners_knockout (winners_knockout_id AUTO_INCREMENT PRIMARY KEY, Home (1st leg) VARCHAR, Home (2nd leg) VARCHAR, 1st Leg VARCHAR, 2nd leg VARCHAR, Aggregate VARCHAR) CREATE TABLE important_originating_express_trains (important_originating_express_trains_id AUTO_INCREMENT PRIMARY KEY, Train No. VARCHAR, Train Name VARCHAR, Destination VARCHAR, Category VARCHAR, Frequency VARCHAR) CREATE TABLE cast (cast_id AUTO_INCREMENT PRIMARY KEY, Actor VARCHAR, Character VARCHAR, Duration VARCHAR, No. of series VARCHAR, Episodes INT)  
SELECT Position in managerial_changes FROM managerial_changes WHERE Date of vacancy = 4 November 2008