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: Que tipo de Semana 4 tem uma Semana 9 de todos os companheiros de casa?
 ###Tabelas: CREATE TABLE chronological_list_of_grand_slam_singles_titles_leaders (chronological_list_of_grand_slam_singles_titles_leaders_id AUTO_INCREMENT PRIMARY KEY, Years led VARCHAR, Span of years led INT, Player VARCHAR, Titles won at point of lead INT, Total Career titles INT, Tournament at which lead began VARCHAR) CREATE TABLE 3a_members (3a_members_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Location VARCHAR, Founded INT, Affiliation VARCHAR, Enrollment INT, Nickname VARCHAR) CREATE TABLE imported (imported_id AUTO_INCREMENT PRIMARY KEY, Model VARCHAR, Build year VARCHAR, Top speed (In operation) （km/h） INT, Power output （kW） VARCHAR, Total production INT) CREATE TABLE nominations (nominations_id AUTO_INCREMENT PRIMARY KEY, Week 1 VARCHAR, Week 2 VARCHAR, Week 3 VARCHAR, Week 4 VARCHAR, Week 5 VARCHAR, Week 6 VARCHAR, Week 7 VARCHAR, Week 8 VARCHAR, Week 9 VARCHAR, Week 10 FINAL VARCHAR) CREATE TABLE weeks (weeks_id AUTO_INCREMENT PRIMARY KEY, English name VARCHAR, Thai name VARCHAR, Transcription VARCHAR, Color VARCHAR, Sanskrit word VARCHAR, Planet VARCHAR)  
SELECT Week 4 FROM nominations WHERE Week 9 = all housemates