DENSE_RANK
Window function. Returns the rank of each row. But unlike the RANK function, it returns the rank for identical values, without skipping the next one
Examples
SELECT
member_name,
status,
DENSE_RANK() OVER(ORDER BY status) AS 'dense_rank'
FROM FamilyMembers;