Pergunta de entrevista da empresa Singapore Infotech

what a group by clause does? example query