what is the number of sites when the number of screens is 687 and rank is more than 7?
CREATE TABLE table_name_8 (
    sites INTEGER,
    screens VARCHAR,
    rank VARCHAR
)
SELECT AVG(sites) FROM table_name_8 WHERE screens = 687 AND rank > 7
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 is the number of sites when the number of screens is 687 and rank is more than 7? ### Input: CREATE TABLE table_name_8 (
    sites INTEGER,
    screens VARCHAR,
    rank VARCHAR
) ### Response: SELECT AVG(sites) FROM table_name_8 WHERE screens = 687 AND rank > 7