The sql-challenge from bigtoga

Step	√	Requirement
1	√	Create an ERD using a visual tool - dbDiagram.io https://www.quickdatabasediagrams.com/
2	√	Save your ERD as an image
3a	√	Create tables that match your ERD. Specify data types, primary keys, foreign keys, and other constraints
3b	√	Import the data
3c	√	Create a .sql file of your table schema

Step	Status	Requirement
1	√	List the following details of each employee: employee number, last name, first name, gender, and salary.
2	√	List employees who were hired in 1986.
3	√	List the manager of each department with the following information: department number, department name, the manager's employee number, last name, first name, and start and end employment dates.
4	√	List the department of each employee with the following information: employee number, last name, first name, and department name.
5	√	List all employees whose first name is "Hercules" and last names begin with "B."
6	√	List all employees in the Sales department, including their employee number, last name, first name, and department name.
7	√	List all employees in the Sales and Development departments, including their employee number, last name, first name, and department name.
8	√	In descending order, list the frequency count of employee last names, i.e., how many employees share each last name.

Step	Status	Requirement
1	√	ERD includes all correct tables, correct table names, correct column names, correct data types, PKs on all, FKs
2	√	SQL script runs without error
3	√	All required columns
4	√	Columns are set to the correct data type
5	√	Primary key for each table
6	√	Correctly references related tables using Foreign Keys
7	√	Correctly uses NOT NULL condition on necessary columns
8	√	Accurately defines value length for columns
9	√	Queries provided for all questions
10	√	All queries provide the expected results
11	√	BONUS: Correctly queries tables from the postgres database into pandas dataframes
13	√	BONUS: Create a histogram to visualize the most common salary ranges for employees
14	√	BONUS: Plot has titles and axes labels
15	√	BONUS: Create a bar chart of average salary by title
14	√	BONUS: Plot has titles and axes labels

bigtoga / sql-challenge Goto Github PK