select RANK() over (order by username) as ranking, * from member where Email like '%reiko%' order by Username desc