What job does he have?
SELECT job FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name   =   T2.friend WHERE T2.name   =   'Alice' AND T1.gender   =   'male'
job of a person refers to the 'job' column in the Person table; the context implies looking for the job of a male person who is a friend of 'Alice', which involves joining tables 'Person' and 'PersonFriend' based on the name and friend relationship;