Cacher is the code snippet organizer for pro developers

SELECT Country, YEAR(HireDate) AS YearHired, COUNT(*) AS NumEmployees
FROM Employees
WHERE HireDate >= '19920101'
GROUP BY Country, YEAR(HireDate)
HAVING COUNT(*) > 1
ORDER BY Country, YearHired DESC