user: ### NOW ANSWER:
Question: How many households have Yadkin as the county?
Columns: ['County', 'Per capita income', 'Median household income', 'Median family income', 'Population', 'Number of households']
Types: ['text', 'text', 'text', 'text', 'real', 'real']
Sample row: ['Orange', '$32,912', '$52,981', '$79,811', 133801.0, 51457.0]
SQL:

assistant: SELECT "Number of households" FROM "Table" WHERE "County" = 'Yadkin';