目标（约1700行）

YEAR COUNTRY   NAME              NUM_GOALS
-------------------------------------------
2018 England   Harry Kane                6
2018 France    Antoine Griezmann         4
2014 Argentina Lionel Messi              4
2014 Brazil    Fred                      1
2010 Germany   Thomas Muller             5
2010 Japan     Shinji Okazaki            1
1992 England   Gary Linekar              6

冠军（约500排）

YEAR    COUNTRY NAME    ROLE
-------------------------------------------------
2018    France  Didier Deschamps    Manager
2018    France  Hugo Lloris Goalkeeper
2018    France  Paul Pogba  Midfielder
2014    Germany Joachim Loew    Manager
2014    Germany Mesut Ozil  Midfielder
2014    Germany Miroslav Klose  Forward
2002    Brazil  Da Silva    Midfielder
1994    Brazil  Da Silva    Midfielder
1998    France  Didier Deschamps    Midfielder

写一个查询来确定每个世界杯的金靴奖得主（最高进球者）。
我不确定的是我是否应该包括一个max子句。
我将非常感谢额外的澄清和帮助这一点，或者如果我的查询需要任何调整。
这就是我想说的：

SELECT NAME, YEAR, MAX(NUM_GOALS) as NUM_GOALS 
FROM GOALS;