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