ASCENDING DESCENDING WITH ORDER BY CLAUSE

SELECT FirstName, LastName, HireDate,City FROM Employees
ORDER BY Country DESC, City ASC