Retrieving the Highest Value for Each Group by Checking Two Columns' Values Using Correlated Subqueries and Aggregation Functions