CREATE TABLE table_name_6 (goals VARCHAR, country VARCHAR)

How many goals did a player from France have?
SELECT goals FROM table_name_6 WHERE country = "france"
SELECT "goals" FROM "table_name_6" WHERE "country" = "france"