Table: box_office_1990
Columns: rank
title
studio
director
gross

Question: What is the rank of the film directed by Kevin Costner?
SQL: SELECT COUNT("rank") FROM box_office_1990 WHERE "director" = 'kevin costner'

Question: What director grossed $200,512,643
SQL: SELECT "director" FROM box_office_1990 WHERE "gross" = '$200,512,643'

Question: What is the average rank of the movie from Paramount Studios that grossed $200,512,643?
SQL: SELECT AVG("rank") FROM box_office_1990 WHERE "studio" = 'paramount' AND "gross" = '$200,512,643'

Question: Who directed Teenage Mutant Ninja Turtles?
SQL: SELECT "director" FROM box_office_1990 WHERE "title" = 'teenage mutant ninja turtles'

Question: What director ranked higher than 1 from Universal Studios and grossed $201,957,688?
SQL: SELECT "director" FROM box_office_1990 WHERE "rank" > 1 AND "studio" = 'universal' AND "gross" = '$201,957,688'