Table: ncaarealignment
Columns: conference
old_membership_total
new_membership_total
net_change
members_added
members_lost

Question: What is the smallest number for old membership total?
SQL: SELECT MIN("old_membership_total") FROM ncaarealignment

Question: What is the lowest number of members lost when the  net change is −1?
SQL: SELECT MIN("members_lost") FROM ncaarealignment WHERE "net_change" = '−1'

Question: What is the new membership total if the members lost is bigger than 1.0?
SQL: SELECT MAX("new_membership_total") FROM ncaarealignment WHERE "members_lost" > 1.0

Question: How many members were added at the nchc (men only) conference?
SQL: SELECT "members_added" FROM ncaarealignment WHERE "conference" = 'NCHC (men only)'

Question: What was the new membership total at the nchc (men only) conference?
SQL: SELECT "new_membership_total" FROM ncaarealignment WHERE "conference" = 'NCHC (men only)'