Table: film_1984_rankings
Columns: rank
title
studio
director
gross

Question: WHAT RANK DOES LEONARD NIMOY HAVE?
SQL: SELECT AVG("rank") FROM film_1984_rankings WHERE "director" = 'leonard nimoy'

Question: WHAT IS THE RANK OF MARTIN BREST?
SQL: SELECT SUM("rank") FROM film_1984_rankings WHERE "director" = 'martin brest'

Question: WHAT IS THE STUDIO WITH A GROSS $81,198,894?
SQL: SELECT "studio" FROM film_1984_rankings WHERE "gross" = '$81,198,894'

Question: WHAT IS THE GROSS DOLLARS WITH A RANK OF 7 OR MORE, AND DIRECTOR BARRY LEVINSON?
SQL: SELECT "gross" FROM film_1984_rankings WHERE "rank" > 7 AND "director" = 'barry levinson'

Question: WHAT IS THE GROSS WITH A DIRECTOR OF RICHARD TUGGLE?
SQL: SELECT "gross" FROM film_1984_rankings WHERE "director" = 'richard tuggle'