Table: north_dakota_colleges
Columns: school
location_s
control
type
enrollment_fall_2010
founded
accreditation

Question: What is the enrollment for the school in bottineau?
SQL: SELECT "enrollment_fall_2010" FROM north_dakota_colleges WHERE "location_s" = 'Bottineau'

Question: What is the control for the school accredited by the higher learning commission ( nca ), ccne?
SQL: SELECT "control" FROM north_dakota_colleges WHERE "accreditation" = 'The Higher Learning Commission ( NCA ), CCNE'

Question: What year was the school founded with an 898 enrollment?
SQL: SELECT MAX("founded") FROM north_dakota_colleges WHERE "enrollment_fall_2010" = 898

Question: How many schools founded in 2006?
SQL: SELECT COUNT("accreditation") FROM north_dakota_colleges WHERE "founded" = 2006

Question: What is the accrediation for united tribes technical college?
SQL: SELECT "accreditation" FROM north_dakota_colleges WHERE "school" = 'United Tribes Technical College'