Pregunta de entrevista de Singapore Infotech

what a group by clause does? example query