CREATE TABLE table_name_3 (qualifying_goals INT, player VARCHAR, finals_goals VARCHAR)

What is the Average Qualifying Goals for Jack Froggatt where the Final Goals is greater than 0?
SELECT AVG(qualifying_goals) FROM table_name_3 WHERE player = "jack froggatt" AND finals_goals > 0
SELECT AVG("qualifying_goals") FROM "table_name_3" WHERE "finals_goals" > 0 AND "jack froggatt" = "player"