Question d’entretien chez Singapore Infotech

what a group by clause does? example query