How SORT and ORDER BY differ each other?

Question

Where should we use SORT and ORDER BY in query.

Answer 1

I have never seen a SQL keyword 'SORT'

The general syntax is:

SELECT column-names
FROM table-name
WHERE condition
ORDER BY column-names

After ORDER BY can be a ASC or DESC for ascending or descending.