En fazla satin alan kullanıcılar

SELECT k.*,t.toplam_satinalan FROM kulllanicilar as k RIGHT JOIN
(Select COUNT(id) as toplam_satinalan,kullanici_id from Satinalan GROUP BY kullanici_id) as t
ON k.kullanici_id = t.kullanici_id
ORDER BY t.toplam_satinalan DESC