How to find 2nd level of friends of a user in orientDb

Problem:

How to find 2nd level of friends of a user in orientDb (Friends of Friend)

Solution

select flatten(distinct(in.out.in)) as in from (traverse V.out, E.in from #10:1178 while $depth <=1)

    where @class='Friends'