user: ### NOW ANSWER:
Question: What is the median household income for Cape Girardeau?
Columns: ['County', 'Per capita income', 'Median household income', 'Median family income', 'Population', 'Number of households']
Types: ['text', 'text', 'text', 'text', 'real', 'real']
Sample row: ['Platte', '$34,037', '$65,948', '$79,472', 89322.0, 36103.0]
SQL:

assistant: SELECT "Median household income" FROM "Table" WHERE "County" = 'Cape Girardeau';