This is a duplicate of this question Problems with QoQ after upgrading to 5.4.3.2
The long and short of it is that grouping by an alias is not standard SQL and doesn’t work in most DB’s. HSQLDB somehow has limited support for it that works in some cases. Native QoQ doesn’t error (it prolly should) but also just won’t match anything in the where clause.
My recommendation right now for you is not to group by an alias.