SELECT T2.friend FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name  =  T2.friend WHERE T2.name  =  'Alice' AND T1.gender  =  'male' AND T1.job  =  'doctor'
Who are the friends of Alice that are doctors?
SELECT T2.friend FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.friend WHERE T2.name = 'Alice ' AND T1.gender = 'male ' AND T1.job = 'doctor '
select t2 . friend from person as t1 join personfriend as t2 on t1 . name = t2 . friend where t2 . name = value and t1 . gender = value and t1 . job = value
Who are the friends of Alice that are doctors ?