SELECT
Count(yorum.id) AS sayi,
yorum.yazan
FROM
yorum
GROUP BY
yorum.yazan
ORDER BY
sayi
DESC