We have several employees with multiple positions; some subsequent in same department, some in different departments (or a mix of both).
I need to find for each employee the first startdate and last enddate for their positions in each department (ie group by employee and dep)
Emp: empID, name
Dep: depID, name
Positions: empID, DepID, startdate, enddate