In Java, create code to perform the two queries below on the CSV file directly. I have already completed the two queries using SQL but for this specific problem I must use solely java. The goal is to create code in java to

Query 1: List people who work in the same department as Adcock Sr Gerald W- himself excluded.

Query 2: List all the departments and total number of employees working in that department.

Excel file: https://drive.google.com/file/d/0B6wUR2OjN6GcZldwN1YzMlo2YWs/view?usp=sharing

SQL Code

Query 1:

SELECT FULL_NAME FROM Employees WHERE DEPARTMENT = DTS AND FULL_NAME NOT IN( SELECT FULL_NAME FROM Employees WHERE FULL_NAME = Adcock Sr Gerald W);

Query 2:

SELECT DEPARTMENT, COUNT(FULL_NAME) AS NUM_OF_EMPLOYEES FROM Employees GROUP BY DEPARTMENT;