Wouldn’t you folks be better off using a join and a group by for this?

To be honest I’m much more bothered by the fact that we don’t have subqueries in the select clause in H5 than I am by them not being allowed in order by. Perhaps that’s something we can fix in H6 if it’s not already fixed.