Pergunta de entrevista da empresa Incedo

Q. Question in GROUP BY and HAVING command?