Table: acc_football_2010
Columns: institution
nickname
location
founded
joined_acc
school_type
acc_football_titles

Question: what type over school is Clemson?
SQL: SELECT "school_type" FROM acc_football_2010 WHERE "institution" = 'Clemson'

Question: what year did north carolina institution join the acc?
SQL: SELECT MAX("joined_acc") FROM acc_football_2010 WHERE "institution" = 'North Carolina'

Question: how many acc football titles have been won by the institution nicknamed tar heels?
SQL: SELECT "acc_football_titles" FROM acc_football_2010 WHERE "nickname" = 'Tar Heels'

Question: what type of school is the institution nicknamed seminoles?
SQL: SELECT "school_type" FROM acc_football_2010 WHERE "nickname" = 'Seminoles'

Question: when did the institution at chapel hill, North carolina join acc?
SQL: SELECT "joined_acc" FROM acc_football_2010 WHERE "location" = 'Chapel Hill, North Carolina'