filter rows in table to get only the first by column value

[1655653]

I have a table composed as follows

name | YEAR | sum(salesbyYear)

and i want to have as result, for each Year, the sum of all sales. The problem is that i get every year for all the people.

so, instead of  something like

John | 2021 | 100

Jack |2020 | 300

Mike|2019| 300

i get something like:

John |2021| 100

Jack |2021 | 3

Mike |2021| 5

Jack |2020| 300

...

Any helps?