user: Question: How many States have an Indian population of 30947?
Columns: ['State/Territory', 'Asian American Population (2010 Census)', 'Chinese', 'Filipino', 'Indian', 'Japanese', 'Korean', 'Vietnamese', 'Other Asian']
Types: ['text', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Alabama', 67036.0, 11154.0, 8224.0, 14951.0, 4336.0, 10624.0, 8488.0, 9259.0]
SQL:

assistant: SELECT COUNT("Filipino") FROM "Table" WHERE "Indian" = 30947.0;