How can I select distinct col1 rows with the maximum col2 value in SQL

join shbcf.ru