Table: movie_weekend
Columns: date
rank
weekend_gross
theaters
gross_to_date

Question: Name the Theaters that has a Rank larger than 7?
SQL: SELECT MAX("theaters") FROM movie_weekend WHERE "rank" > 7

Question: Name the Gross-to-date which has a Date of august 23–25?
SQL: SELECT "gross_to_date" FROM movie_weekend WHERE "date" = 'august 23–25'