Basic

ORDER BY x

x can be any datatype.

• NULLs precede non-NULLs.
• The default is ASC (lowest to highest)
• Strings (VARCHAR, etc) are ordered according the COLLATION of the declaration
• ENUMs are ordered by the declaration order of its strings.