Depending on the version, you might be served by using MIN_BY(x,y) or MAX_BY(x,y). Returns the min(max) value of x for group y.