User need : I want to display a list with some total, sorted DESC or ASC of the total.
The following SQL does the job :
SELECT name, count(something) FROM myTable SORT BY count(something) DESC
will show name sorted by the number of something (desc)
In the current version of Urungi, this is not possible (IIRC, it used to be in a previous version)