I want to know the average crowd for away team of melbourne
CREATE TABLE table_name_43 (crowd INTEGER, away_team VARCHAR)
SELECT AVG(crowd) FROM table_name_43 WHERE away_team = "melbourne"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (crowd INTEGER, away_team VARCHAR) Question: I want to know the average crowd for away team of melbourne [/INST] SELECT AVG(crowd) FROM table_name_43 WHERE away_team = "melbourne" </s>