Query Run
select ROW_NUMBER() OVER(ORDER BY reviews DESC) AS rank, -- count(rc_id)... 3 years ago