melindamalone/Pewlett-Hackard-Analysis

The Pewlett Hackard Analysis repo uses Structured Query Language (SQL) in a Postgres relational database using pgAdmin. An entity-relationship diagram (ERD) was initially designed to organize employee data for six separate CSV files containing employee, department, employees by department, managers by department, salary, and title information. The datasets were imported into pgAdmin and queries using Joins, Where, Order By, Group By, Count, On, and Into clauses and functions, in addition to table aliases, were used to analyze the data and determine how many employees are eligible for retirement and what programs need to be put into place for mentorship opportunities before retirement-eligible employees retire.