select u.uyeid, u.adi, count(*) as yorum_sayisi
from tblyorum y
join tbluye u on y.uyeid=u.uyeid
group by u.uyeid, u.adi
order by count(*)

select y.uyeid, u.adi, count(*) as giris_sayisi
from tbllog l
join tblyonetici yon l.yoneticiid=y.yoneticiid
where l.TARIH >= NOW() - INTERVAL 1 month) 
group by u.uyeid, u.adi
order by count(*)

makale yazar ayni sekilde


group by degistirerek bu ay encok giren/yorum yazan/ makale /yazan

her ay encok yoru atan ilk 5 uye

bunun gibi sorgularda
row_number partition by order by kullanabilirsin