how many acc football titles have been won by the institution nicknamed tar heels?
CREATE TABLE table_28744929_1 (acc_football_titles VARCHAR, nickname VARCHAR)
SELECT acc_football_titles FROM table_28744929_1 WHERE nickname = "Tar Heels"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_28744929_1 (acc_football_titles VARCHAR, nickname VARCHAR) Question: how many acc football titles have been won by the institution nicknamed tar heels? [/INST] SELECT acc_football_titles FROM table_28744929_1 WHERE nickname = "Tar Heels" </s>