Table: film_1987
Columns: rank
title
studio
director
gross

Question: What is the rank of the film directed by danny devito?
SQL: SELECT "rank" FROM film_1987 WHERE "director" = 'danny devito'

Question: What is the sum of the ranks for the film, eddie murphy raw?
SQL: SELECT SUM("rank") FROM film_1987 WHERE "title" = 'eddie murphy raw'

Question: Who directed Predator that was filmed with Fox Studio?
SQL: SELECT "director" FROM film_1987 WHERE "studio" = 'fox' AND "title" = 'predator'

Question: What is the total number of ranks that had vestron as the studio?
SQL: SELECT COUNT("rank") FROM film_1987 WHERE "studio" = 'vestron'