-- Database schema
| location : locationID [ INTEGER ] primary_key , locationcity [ TEXT ] , address [ TEXT ] , state [ TEXT ] , zipcode [ INTEGER ] , officephone [ TEXT ] | position : positionID [ INTEGER ] primary_key , positiontitle [ TEXT ] , educationrequired [ TEXT ] , minsalary [ TEXT ] , maxsalary [ TEXT ] | employee : ssn [ TEXT ] primary_key , lastname [ TEXT ] , firstname [ TEXT ] , hiredate [ TEXT ] , salary [ TEXT ] , gender [ TEXT ] , performance [ TEXT ] , positionID [ INTEGER ] employee.positionID = position.positionID , locationID [ INTEGER ] employee.locationID = location.locationID |
-- -- Who is the employee in “New York City” with a good performance? Give the social security number of the employee.

SELECT T1.firstname, T1.lastname, T1.ssn FROM employee AS T1  INNER JOIN location AS T2  ON T1.locationID = T2.locationID WHERE T2.locationcity = 'New York City' AND T1.performance = 'Good';