When you need to group resulting data, you must specify the field you want to group on in the GROUP BY clause. When you want to sort data by a field, you must include the field in the ORDER BY list. In Fusion for MySQL, the interface for this clauses is approximately the same. The only difference is that the ORDER BY tab has the Change Order button that you can use to alter sorting direction.
To include fields in the ORDER BY clause, switch to the corresponding tab of the tabbed editor and perform the following steps: