根据另一列的最大值获取值

I'm struggling to come up with a query to achieve the return data I require from the following table in SQL:I'm struggling to come up with a query to achie