Pewlett Hackard Analysis

Objectives

Technical Analysis Deliverable 1: Number of Retiring Employees by Title

• Create three new tables, one showing number of titles retiring, one showing number of employees with each title, and
  one showing a list of current employees born between Jan. 1, 1952 and Dec. 31, 1955. New tables are exported as CSVs.

Technical Analysis Deliverable 2: Mentorship Eligibility

• Create a table containing employees who are eligible for the mentorship program You will submit your table and the
  CSV containing the data (and the CSV containing the data)

Resources

• postgreSQL
• pgadmin4

Summary of Results

• Number of Individuals Retiring - 33,118
• Number of Employees Available for mentorship - 1,549

Entity Relationship Diagram (ERD)

Technical Analysis Deliverable 1

Code for Creation of Tables.

Number of Titles Retiring

Number of Employees with Each Title

List of current employees born between January 1, 1952 and December 31, 1955

Technical Analysis Deliverable 2

List of Employees Eligible for Mentorship Program

Eligible Mentees by Job Title