help after count() data

[eluser]Thorpe Obazee[/eluser]
[quote author="newbie boy" date="1242048984"]
but i need to show on top the group with the highest total of user down to the lowest.[/quote]

Do you need to sort the group according to the number of members, descending?

If yes, you'll still be using the order_by and probably use sub queries.