user: ### NOW ANSWER:
Question: WHAT RANK DOES Leonard Nimoy HAVE?
Columns: ['Rank', 'Title', 'Studio', 'Director', 'Gross']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [1.0, 'Ghostbusters', 'Columbia', 'Ivan Reitman', '$238,632,124']
SQL:

assistant: SELECT AVG("Rank") FROM "Table" WHERE "Director" = 'Leonard Nimoy';