SQL Function Reference

RANK
Window function. Returns the rank of each row, if identical ones are found, returns the same rank, skipping the next value
MySQL
RANK()
Examples
MySQL
SELECT 
    member_name, 
    status, 
    RANK() OVER(ORDER BY status) AS 'rank' 
    FROM FamilyMembers;