Table: asian_american_demographics
Columns: state_territory
asian_american_population_2010_census
chinese
filipino
indian
japanese
korean
vietnamese
other_asian

Question: What is the the Chinese population for the state that has a Filipino population of 1474707?
SQL: SELECT MIN("chinese") FROM asian_american_demographics WHERE "filipino" = 1474707

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

Question: What is the highest Indian population?
SQL: SELECT MAX("indian") FROM asian_american_demographics