What was the attendance when they had a ranking of #4?
CREATE TABLE table_name_42 (
    attendance VARCHAR,
    rank__number VARCHAR
)
SELECT attendance FROM table_name_42 WHERE rank__number = "4"
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 was the attendance when they had a ranking of #4? ### Input: CREATE TABLE table_name_42 (
    attendance VARCHAR,
    rank__number VARCHAR
) ### Response: SELECT attendance FROM table_name_42 WHERE rank__number = "4"