Querying-Employee-Data

6 CSV files with data on employees of a corporation from the 1980s and 1990s are used to complete the following tasks:

• List the following details of each employee: employee number, last name, first name, sex, and salary.
• List first name, last name, and hire date for employees who were hired in 1986.
• List the manager of each department with the following information: department number, department name, the manager's employee number, last name, first name.
• List the department of each employee with the following information: employee number, last name, first name, and department name.
• List first name, last name, and sex for employees whose first name is "Hercules" and last names begin with "B."
• List all employees in the Sales department, including their employee number, last name, first name, and department name.
• List all employees in the Sales and Development departments, including their employee number, last name, first name, and department name.
• In descending order, list the frequency count of employee last names, i.e., how many employees share each last name. Tables were designed to hold data in th 6 CSVs, and the the csvs were imported into SQL database.

2 sql files are included; one for data engineering, and one for data analysis.

ERD for the sql database tabels: