How many goals were scored by players with more than 16 caps?
CREATE TABLE table_name_45 (
    goals VARCHAR,
    caps INTEGER
)
SELECT goals FROM table_name_45 WHERE caps > 16
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 were scored by players with more than 16 caps? ### Input: CREATE TABLE table_name_45 (
    goals VARCHAR,
    caps INTEGER
) ### Response: SELECT goals FROM table_name_45 WHERE caps > 16