WHAT RANK DOES LEONARD NIMOY HAVE?
CREATE TABLE table_name_16 (
    rank INTEGER,
    director VARCHAR
)
SELECT AVG(rank) FROM table_name_16 WHERE director = "leonard nimoy"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: WHAT RANK DOES LEONARD NIMOY HAVE? ### Input: CREATE TABLE table_name_16 (
    rank INTEGER,
    director VARCHAR
) ### Response: SELECT AVG(rank) FROM table_name_16 WHERE director = "leonard nimoy"