What is the appropriate sequence for the elements in a SQL query clause that displays the rows returned in a particular order?

command, operator $($if any$),$ major sort key, minor sort key

primary sort key followed by operator $($if any$),$ secondary sort key followed by operator $($if any$),$ command

command, major sort key followed by operator $($if any$),$ minor sort key followed by operator $($if any$)$

command, secondary sort key followed by operator $($if any$),$ primary sort key followed by operator $($if any$)$