Pregunta de entrevista de InfoCepts

Question on SQL using ground by and having