GROUP BY tana haɗa layuka da ke raba darajar iri daya, don haka aggregate functions (kamar COUNT, AVG) suna ƙididdige bawai ga kowane rukuni. HAVING tana tacewa rukunan (kamar WHERE, amma na rukunan/aggregates). Tare dake neman mahimman aikin tahlil da bincike data ta hanyar takaita.
GROUP BY — ƙididdige kowane rukuni
country, () user_count, (age) avg_age
users
country;
