When was Emily Wood hired? Mention her position and salary.
Emily Wood is the full name of an employee; full name = firstname, lastname; when was she hired refers to hiredate
SELECT T1.hiredate, T2.positiontitle, T1.salary FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T1.firstname = 'Emily' AND T1.lastname = 'Wood'