what clause sorts the rows returned?

a

$.$

order by

b

$.$

from

c

$.$

group by

d

$.$

$$where