mysql> select Yoresi,count(*) as adet FROM halilar WHERE Sinifi='K' group by Yoresi ORDER BY adet DESC;
+---------------+------+
| Yoresi        | adet |
+---------------+------+
| İzmir        |   91 |
| Cicim         |   64 |
| Köylü       |   48 |
| Uşak         |   39 |
| Sumak         |   34 |
| Durukök      |   32 |
| Karabağ      |   25 |
| Balıkesir    |   21 |
| Göçmen      |   21 |
| Ordu          |   19 |
| Mongol        |   13 |
| Semerkant     |   10 |
| Heybe         |    9 |
| Konya         |    8 |
| Türkmen      |    8 |
| Van           |    8 |
| Malatya       |    8 |
| Koçan        |    7 |
| Çanakkale    |    5 |
| Azeri         |    5 |
| Manastır     |    4 |
| Bahtiyari     |    4 |
| Afgan         |    3 |
| Kars          |    3 |
| Çuval Tuzluk |    2 |
| Bergama       |    2 |
| Nourmak       |    2 |
| Şahseven     |    2 |
| Helvacı      |    2 |
| Moldov        |    2 |
| Gabe          |    2 |
| Pötürge     |    1 |
| izmir         |    1 |
| Mut           |    1 |
| Çuval        |    1 |
| Sivas         |    1 |
| Cİcim        |    1 |
| Adıyaman     |    1 |
+---------------+------+
38 rows in set (0.00 sec)