Syntax options:

    ASC | DESC

    Determines whether the values for sort keys are sorted in
    ascending or descending order.

    If you do not specify the sort order for the sort key, the
    default order is ascending.

    If your dialect is set to 'SQLV40' (the default dialect) then the
    sort order is inherited from the preceding sort key.