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 the 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.

Note: A comma separated values $($csv$)$ file is a plain text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format. A csv file typically stores tabular data $($numbers and text$)$ in plain text, in which case each line will have the same number of fields. Below is a sample taken from the employee$-$sample.csv file $($the header line and two data lines$)$:

Full$\_$Name,Current$\_$Annual$\_$Salary,Gross$\_$Pay$\_$Received,Overtime$\_$Pay,Department,Division,Assignment$\_$Category,Position$\_$Title,Date$\_$First$\_$Hired

$...$

Bisrat Abnet,$48835,55601,9310,$DLC$,$Purchasing,Fulltime$-$Regular,Alcohol Beverage Purchasing Specialist,$5/3/04$

Bista Gopal,$45040,43238,0,$LIB,Bethesda Library,Fulltime$-$Regular,Library Assistant II$,4/10/02$

$...$

Problem: You have to write a Java 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$.)$

a$)$ Query: Search for and list the names of all employees who work in the same department as $$Johnson Jared$-$ himself excluded.

Note: The department in which Johnson 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.

b$)$ Query: List all the division names and the total number of employees working in each $$Transportation$$ division $(=$ divisions whose names start with $$Transportation$.)$

Note: the division names and the count of employees in each division must be determined programmatically, by processing the csv file in an appropriate manner. Hint: there are $9$Transportation$$ divisions that your code should find.