Life without SQL (25 points). A comma separated values (csv) file is given on Canvas: employee-sample.csv. It contains a dataset with employee salary information, which includes Full Name, Current Annual Salary, Gross Pay Received, Overtime Pay, Department (This is the abbreviation of department name; for example BOA stands for Board of Appeals), Division, Assignment Category (Parttime-Regular, Fulltime-Regular), Position Title (Supervisor, Manager, Social worker, Library assistant, ), and Date First Hired.

Problem: You have to write a Python program to answer one of queries a) or b) below. Your code must process the csv data file directly (meaning, solve the problem without importing the data in a DBMS and using SQL.)

1. Query: Search for and list the names of all employees who work in the same department as Adcock Sr Gerald W- himself excluded.

Note: The department in which Adcock works must be found programmatically, by searching the csv file it must not be hardcoded in your program; the same applies for finding the employees working in that department. Hint: there are 29 employees that your code should find.

2. Query: List all the department codes and the total number of employees working in each department.

Note: the department codes (= abbreviations) and the count of employees in each department must be determined programmatically, by processing the csv file in an appropriate manner. Hint: there are 31 departments that your code should find.

• Your source code file(s) for data retrieval task Query a) or Query b), which processes the given csv file directly.
• A readme file to explain how to run your code from command line; indicate any parameters the code expects, paths to any files / resources that the code uses.