 how many location attendance with team being charlotte
CREATE TABLE table_13557843_7 (location_attendance VARCHAR, team VARCHAR)
SELECT COUNT(location_attendance) FROM table_13557843_7 WHERE team = "Charlotte"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_13557843_7 (location_attendance VARCHAR, team VARCHAR) Question:  how many location attendance with team being charlotte [/INST] SELECT COUNT(location_attendance) FROM table_13557843_7 WHERE team = "Charlotte" </s>