Write down the full name, performance status and located city of the employee who's social security number is "767-74-7373".
full name = firstname, lastname; ssn = '767-74-7373'
SELECT T1.firstname, T1.lastname, T2.state, T2.locationcity FROM employee AS T1  INNER JOIN location AS T2  ON T1.locationID = T2.locationID WHERE T1.ssn = '767-74-7373'