I have one table with all my employee information, including the start and end dates of their evaluation years (based on an employee's hire date).
I have a second table that has all the accounts the employee has resolved, including the date of resolution. This table lists the employee ID of...