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 renda domiciliar mediana para Cape Girardeau?
 ###Tabelas: CREATE TABLE planned_for_theatrical_release_but_never_screened_theatrically (planned_for_theatrical_release_but_never_screened_theatrically_id AUTO_INCREMENT PRIMARY KEY, Title VARCHAR, Series VARCHAR, Director VARCHAR, Characters VARCHAR, Release date VARCHAR) CREATE TABLE missouri_counties_ranked_by_per_capita_income (missouri_counties_ranked_by_per_capita_income_id AUTO_INCREMENT PRIMARY KEY, County VARCHAR, Per capita income VARCHAR, Median household income VARCHAR, Median family income VARCHAR, Population INT, Number of households INT) CREATE TABLE gt300 (gt300_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Make VARCHAR, Drivers VARCHAR, Tyre VARCHAR, Rounds VARCHAR) CREATE TABLE current_judges (current_judges_id AUTO_INCREMENT PRIMARY KEY, Position VARCHAR, Name VARCHAR, Stationed In VARCHAR, Appointed INT, Nominated by VARCHAR, Position Prior to Appointment VARCHAR) CREATE TABLE round_two (round_two_id AUTO_INCREMENT PRIMARY KEY, Pick # INT, CFL Team VARCHAR, Player VARCHAR, Position VARCHAR, College VARCHAR)  
SELECT Median household income FROM missouri_counties_ranked_by_per_capita_income WHERE County = cape girardeau