Retrieve activities "Followed By" certain activities in SQL

Transact-SQL
, ,
21

OR

if you always have 4 rows for each person

then
row_number() over( partition by person order by (select null)) as rn

where
rn = 1 and ActivityName = FR
rn = 2 and ActivityName = ISRO
rn = 3 and ActivityName = VIS
rn = 4 and ActivityName = REC