Domanda di colloquio di Singapore Infotech

what a group by clause does? example query