CREATE TABLE table_10118412_6 (filipino VARCHAR, indian VARCHAR)

How many States have an Indian population of 30947?
SELECT COUNT(filipino) FROM table_10118412_6 WHERE indian = 30947
SELECT COUNT("filipino") FROM "table_10118412_6" WHERE "indian" = 30947