SELECT first_name, COUNT(first_name) AS names_count FROM employees GROUP BY first_name HAVING COUNT(first_name) < 200 AND hire_date > '1999-01-01' ORDER BY first_name DESC;

Hi Marcus! Thanks for reaching out. By executing the query you suggest, don't you obtain an error message saying that the 'hire_date' in the HAVING clause is unknown? If not, what output do you obtain on execution of the given query? Thank you. Looking forward to your answer. Best, Martin