FIGURE 1: Most recent order for each employee (with duplicates)
EmployeeID OrderID CustomerID ShipVia OrderDate
---------- ------- ---------- ------- ---------
9 11058 BLAUS 3 1998-04-29
8 11075 RICSU 2 1998-05-06
7 11074 SIMOB 2 1998-05-06
6 11045 BOTTM 2 1998-04-23
5 11043 SPECD 2 1998-04-22
4 11076 BONAP 2 1998-05-06
3 11063 HUNGO 2 1998-04-30
2 11073 PERIC 2 1998-05-05
2 11070 LEHMS 1 1998-05-05
1 11077 RATTC 2 1998-05-06