SQL Case Study 2: Human Resources by Data In Motion, LLC by Justice OfokansiSQL Case Study 2: Human Resources by Data In Motion, LLC by Justice Ofokansi

SQL Case Study 2: Human Resources by Data In Motion, LLC

Justice Ofokansi

Typographer

SQL Case Study 2: Human Resources by Data In Motion, LLC

Link to the in browser SQL: https://www.db-fiddle.com/f/xckGL9ZW73A6FWhsmPogm7/6

Create 'departments' table

Create 'employees' table

Create 'projects' table

Insert data into 'departments'

Insert data into 'employees'

Insert data into 'projects'

SQL Challenge Questions

1. Find the longest ongoing project for each department.

2. Find all employees who are not managers.

3. Find all employees who have been hired after the start of a project in their department.

4. Rank employees within each department based on their hire date (earliest hire gets the highest rank).

5. Find the duration between the hire date of each employee and the hire date of the next employee hired in the same department.

SQL Case Study 2: Human Resources by Data In Motion, LLC

SQL Case Study 2: Human Resources by Data In Motion, LLC

Link to the in browser SQL: https://www.db-fiddle.com/f/xckGL9ZW73A6FWhsmPogm7/6

Create 'departments' table

Create 'employees' table

Create 'projects' table

Insert data into 'departments'

Insert data into 'employees'

Insert data into 'projects'

SQL Challenge Questions

1. Find the longest ongoing project for each department.

2. Find all employees who are not managers.

3. Find all employees who have been hired after the start of a project in their department.

4. Rank employees within each department based on their hire date (earliest hire gets the highest rank).

5. Find the duration between the hire date of each employee and the hire date of the next employee hired in the same department.

Challenges

Challenges