If needed, you can specify the order of sorting and grouping the resulting data set. Select the required fields and move them into the ORDER BY or GROUP BY list depending on the situation.

See also:Where clause