SELECT column1, column2, ...
FROM table_name
ORDER BY column1 [ASC|DESC], column2 [ASC|DESC], ...;

• ASC (Ascending): This keyword sorts the data in ascending order (from smallest to largest for numbers, A-Z for text, and oldest to newest for dates). If no order is specified, ASC is the default.
• DESC (Descending): This keyword sorts the data in descending order (from largest to smallest for numbers, Z-A for text, and newest to oldest for dates).