Among the employees with poor performance, provide the managers' full names, location city, address and its zip code.
poor performance refers to performance = 'Poor'; full name = firstname, lastname; managers is a position title
SELECT T1.firstname, T1.lastname, T2.locationcity, T2.address, T2.zipcode FROM employee AS T1  INNER JOIN location AS T2  ON T1.locationID = T2.locationID INNER JOIN position AS T3  ON T3.positionID = T1.positionID WHERE T3.positiontitle = 'Manager' AND T1.performance = 'Poor'
database name:db_id human_resources
location table location Cols: location id dtype integer, location city dtype text, address dtype text, state dtype text, zip code dtype integer, office phone dtype text, 
position table position Cols: position id dtype integer, position title dtype text, education required dtype text, minimum salary dtype text, maximum salary dtype text, 
employee table employee Cols: social security number dtype text, last name dtype text, first name dtype text, hire date dtype text, salary dtype text, gender dtype text, performance dtype text, position id dtype integer, location id dtype integer, 
