Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Seems like the normal use for GROUP BY is to sort by COUNT(myfield) rather than some other value.
This is the purpose for doing many group by queries in the first place, exposing those aggregated count values.