Sorting Employees by StartDate then by Hourly Rate within Department

Name Department Hourly Rate Start Date Primary Language
Bill Jones Accounting 45 03/06/1999 ASP
Robert Witherford Engineering 90 03/22/2000 C++
Walter Jackson Internet 20 01/21/2000 ASP
John Smith Internet 25 04/22/2000 VB
Walter Duncan Internet 40 08/16/2000 ASP
Dennis Hammer Internet 50 04/21/1999 HTML
Mark Donalds Internet 100 01/29/2001 XML
Jessy Hammonds Internet 120 07/01/2000 XSL
Richard Manning Internet 150 03/23/2001 XML
Mark Garmand Research 29 04/22/2000 HTML
Mark Henson Sales 25 03/01/1998 ADA
Jack Sanford Sales 35 05/12/1999 ASP
Bill Ratford Sales 85 01/12/2001 COBOL
Bill Snakeson Sales 95 06/01/2000 HTML
Jack Simmons Support 4.50 04/22/2000 HTML
Jim Miller Support 10 02/28/2000 HTML


Sorting Employees by StartDate then by Hourly Rate within Department(descending)

Name Department Hourly Rate Start Date Primary Language
Bill Jones Accounting 45 03/06/1999 ASP
Robert Witherford Engineering 90 03/22/2000 C++
Richard Manning Internet 150 03/23/2001 XML
Jessy Hammonds Internet 120 07/01/2000 XSL
Mark Donalds Internet 100 01/29/2001 XML
Dennis Hammer Internet 50 04/21/1999 HTML
Walter Duncan Internet 40 08/16/2000 ASP
John Smith Internet 25 04/22/2000 VB
Walter Jackson Internet 20 01/21/2000 ASP
Mark Garmand Research 29 04/22/2000 HTML
Bill Snakeson Sales 95 06/01/2000 HTML
Bill Ratford Sales 85 01/12/2001 COBOL
Jack Sanford Sales 35 05/12/1999 ASP
Mark Henson Sales 25 03/01/1998 ADA
Jim Miller Support 10 02/28/2000 HTML
Jack Simmons Support 4.50 04/22/2000 HTML