[IMP] tests cases: use float_compare instead of ==
[IMP]account:use left join for grouping records and use grouped field for grouping or not