-- 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 |
-- -- What is the education required to be account representative? Mention account representative full name and salary who got poor in performance status.

SELECT T2.educationrequired, T1.firstname, T1.lastname, T1.salary FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T1.performance = 'Poor' AND T2.positiontitle = 'Account Representative';