Table: newzealandethnicity
Columns: ethnic_group
2001
2001_people
2006
2006_people

Question: How many percentages were recorded under 2006 when in 2001 was 14.6%?
SQL: SELECT COUNT("2006") FROM newzealandethnicity WHERE "2001" = '14.6'

Question: What is the ethnic group that in 2001 had 117,513?
SQL: SELECT "ethnic_group" FROM newzealandethnicity WHERE "2001_people" = '117,513'

Question: How many numbers were recorded under 2001 when 2006 was 18.9?
SQL: SELECT COUNT("2001") FROM newzealandethnicity WHERE "2006" = '18.9'

Question: What was the percentage in 2006 when in 2001 was 66.9 %?
SQL: SELECT "2006" FROM newzealandethnicity WHERE "2001" = '66.9'