SQL Function Reference

Window function. Returns the rank of each row, if identical ones are found, returns the same rank, skipping the next value

RANK()

SELECT 
    member_name, 
    status, 
    RANK() OVER(ORDER BY status) AS 'rank' 
    FROM FamilyMembers;