sql-challenge

Fictious employee data was loaded into a SQL database from CSVs to query and then visualize with Pandas.

Data Engineering

• CSV files were loaded into SQL tables, as depicted above, using the schema

Data Analysis

• Different queries were run to answer a variety of questions about the employees. For example, Find any employees whose first name is Hercules and last name starts with a B

SELECT emp_no, "last_name", "first_name", "sex"
FROM employees AS e
WHERE first_name = 'Hercules'
AND last_name LIKE 'B%'
LIMIT 50;

• Additional analysis was done with Pandas to visualize the salary data