What is the record in the atlantic coast conference for the Miami team?
CREATE TABLE table_28744929_2 (acc_record VARCHAR, team VARCHAR)
SELECT acc_record FROM table_28744929_2 WHERE team = "Miami"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_28744929_2 (acc_record VARCHAR, team VARCHAR) Question: What is the record in the atlantic coast conference for the Miami team? [/INST] SELECT acc_record FROM table_28744929_2 WHERE team = "Miami" </s>