CREATE TABLE table_name_92 (goals NUMBER, player VARCHAR2)

What is the smallest number of goals for andy williams?
SELECT MIN(goals) FROM table_name_92 WHERE player = "andy williams"
SELECT MIN("goals") FROM "table_name_92" WHERE "andy williams" = "player"