CREATE TABLE PersonFriend (friend VARCHAR(255), name VARCHAR(255)); CREATE TABLE Person (name VARCHAR(255), job VARCHAR(255), gender VARCHAR(255))
Find the male friend of Alice whose job is a doctor?
    
SQL: 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'