Sorting on grouped columns

[PaulPoulain]

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)

[jajm]

For reference, this is mentioned in https://suivi.biblibre.com/view.php?id=38265#c218456

[PaulPoulain]

it's not exactly the same thing, but maybe the same issue:
In my case, I want to do something like :
"SELECT count() as tot, something FROM sometable GROUP BY something ORDER BY tot DESC"
Laurence want to do something like
"SELECT count() as tot, something FROM sometable GROUP BY something WHERE tot>1"

Anyway, in both cases it does not work as expected :
ORDER BY :

WHERE :

[PaulPoulain]

marking this as a bug, as the interface let you do it, but it does not work.