CREATE TABLE table_7836 ("Rank" FLOAT, "Title" CLOB, "Studio" CLOB, "Director" CLOB, "Gross" CLOB)

WHAT RANK DOES LEONARD NIMOY HAVE?
SELECT AVG("Rank") FROM table_7836 WHERE "Director" = 'leonard nimoy'
SELECT AVG("Rank") FROM "table_7836" WHERE "Director" = 'leonard nimoy'