LEAD(column [, offset ] [, default])
SELECT member_name, STATUS, LEAD(member_name) OVER( ORDER BY STATUS ) AS 'lead_1', LEAD(member_name, 2, 'empty') OVER( ORDER BY STATUS ) AS 'lead_2' FROM FamilyMembers;