To sort this table
Employee by department, you would use
ORDER BY Department.
However, if you want a different sort order that is not alphabetical, you have to map the
Department values into different values that sort correctly; this can be done with a CASE expression:
ORDER BY CASE Department
WHEN 'HR' THEN 1
WHEN 'Accountant' THEN 2