CREATE TABLE table_name_4 (goals VARCHAR, years_active VARCHAR)

How many goals did a player active since 2006 have?
SELECT goals FROM table_name_4 WHERE years_active = "2006"
SELECT "goals" FROM "table_name_4" WHERE "2006" = "years_active"