Pregunta de entrevista de Clifford Chance

Write SQL query for a problem using group by and having clause and count function