LAG(column [, offset ] [, default])
SELECT member_name, STATUS, LAG(member_name) OVER( ORDER BY STATUS ) AS 'lag_1', LAG(member_name, 2, 'empty') OVER( ORDER BY STATUS ) AS 'lag_2' FROM FamilyMembers;