You will be using the existing file /jaunty/labdata for this lab. Its data is laid out in the following manner:

Employee number (the lower the number, the longer employed), Last name, First name, Department, Security Level. Take a look at it to familiarize yourself with the layout and delimiter. You may copy it to your own directory if you want to cut keystrokes when writing your commands. From your home directory, issue this command:

cp /jaunty/labdata .

1. Show the records of everyone with a Security Level of 9. Sort the results alphabetically by last name.

Show your full command and its results. (10 points)

2. Sort the records by length of employment, oldest to newest. Produce this sorted list showing only Last name and First name. Show your full command and its results. (10 points)

3. Show all employees except those in Engineering. Sort by Security level, highest to lowest. Show your full command and its results. (10 points)

4. Produce a list of the number of employees who work in each department. Your results should show each department name once with the total number of employees it has, nothing more. Show your full command and its results. (20 points)

The file contains:

004,Hendrix,James,Engineering,9

237,Cauthon,Mat,Marketing,2

889,Wallace,Mia,Accounting,9

096,Uffhark,Joan,Administration,9

120,Carringtion,Blake,Accounting,8

053,Draper,Don,Marketing,3

3 413,Zappa,Francesco,Engineering,9

285,Gunvalson,Victoria,Engineering,9

744,Watts,Charles,Administration,8

409,Wilson,Brian,Engineering,9

346,McCormick,Kenneth,Marketing,2

070,Berlin,Rachel,Marketing,2

555,Zombie,Robert,Administration,7

217,Burns,Fahr,Accounting,8

154,Tennille,Antoinette,Engineering,9

843,Trakand,Elayne,Administration,8

654,Grumby,Jonas,Administration,7

026,Corleone,Michael,Marketing,3

599,March,Christopher,Engineering,9

808,Mann,Yoda,Engineering,9