Table schema:
CREATE TABLE film (Gross_in_dollar INTEGER)

Question: What is the average ticket sales gross in dollars of films?
SQL: SELECT AVG(Gross_in_dollar) FROM film