LAST_VALUE(column)
SELECT member_name, STATUS, LAST_VALUE(member_name) OVER( PARTITION BY STATUS ORDER BY STATUS ) AS 'last_value' FROM FamilyMembers;