WITH KK AS(SELECT inviter,COUNT(*) AS NN FROM T1 GROUP BY inviter)SELECT KK.*,RANK_OVER(PARTITION BY inviter ORDER BY NN DESC) AS RN FROM KK
