Table: phi_sigs_chapters
Columns: chapter
chartered
school
state
status
charter_range

Question: What years were the inactive North Carolina chapter active?
SQL: SELECT "charter_range" FROM phi_sigs_chapters WHERE "status" = 'inactive' AND "state" = 'north carolina'

Question: What years were the inactive Idaho chapter active?
SQL: SELECT "charter_range" FROM phi_sigs_chapters WHERE "status" = 'inactive' AND "state" = 'idaho'

Question: Which chapter was active from 1906-1991?
SQL: SELECT "chapter" FROM phi_sigs_chapters WHERE "charter_range" = '1906-1991'

Question: What are the active dates for the Montana State University chapter?
SQL: SELECT "charter_range" FROM phi_sigs_chapters WHERE "school" = 'montana state university'

Question: What state had an active chapter from 1906-1991?
SQL: SELECT "state" FROM phi_sigs_chapters WHERE "charter_range" = '1906-1991'