If we want to order the data differently for per group, we can add a CASE syntax to the ORDER BY.
In this example, we want to order employees from Department 1 by last name and employees from Department 2 by salary.
IdFNameLNamePhoneNumberManagerIdDepartmentIdSalaryHireDate1JamesSmith1234567890NUL...