State the email of those who are staff of Murphy Diane whose number is 1002 and living in San Francisco
staff of refers to reportsTO; San Francisco is a city;
SELECT T1.email FROM employees AS T1 INNER JOIN offices AS T2 ON T1.officeCode = T2.officeCode WHERE T1.reportsTo = 1002 AND T2.city = 'San Francisco'