How many goals ranked 6?
CREATE TABLE table_name_36 (
    goals VARCHAR,
    rank VARCHAR
)
SELECT COUNT(goals) FROM table_name_36 WHERE rank = 6
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: How many goals ranked 6? ### Input: CREATE TABLE table_name_36 (
    goals VARCHAR,
    rank VARCHAR
) ### Response: SELECT COUNT(goals) FROM table_name_36 WHERE rank = 6