https://www.google.com.tr/search?q=sql+group+by

Örnek: SELECT ülke, COUNT(*) AS sayı FROM `kisiler` GROUP BY ülke