sql keep the first row according to an attribute

I wrote an sql to group by the SEASON in ASC and CHAM in DESC. How can I select the largest value of CHAM in each SEASON? To further development, I need to keep the CHAMPION_ID.

https://stackoverflow.com/questions/67249387/sql-keep-the-first-row-according-to-an-attribute April 25, 2021 at 11:05AM