What database & version is this? No, that SQL doesn't do it, since there's nothing that tells it you want specifically the name from the row with the max score. And what do you want in the case of a tie, multiple rows, a list of names, an arbitrary name, a name decided by some tie breaking logic?