What is the average ticket sales gross in dollars of films?
CREATE TABLE film (Gross_in_dollar INTEGER)
SELECT AVG(Gross_in_dollar) FROM film
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE film (Gross_in_dollar INTEGER) Question: What is the average ticket sales gross in dollars of films? [/INST] SELECT AVG(Gross_in_dollar) FROM film </s>