> Great!!! Your Solution Worked, I didn't use Order by.

If you don't use order by, the order is arbitrary. Actually it will
order it by the same columns as the group by, but that is simply an
implementation artifact. A future version of Firebird may change this.

If you care about on the order, you must use the order by line.

Adam