Sign Up
View All Projects
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.
Partner With Justice
View Services
More Projects by Justice
Ocean Cleanup Dataset
Netflix Analysis Project
How it Works
Contra For Independents
Contra For Hiring
Success Stories
Commission-Free
Company
Mission
Careers
Newsroom
Resources
FAQ
Tips & Guides
Hire
Support
Dіscover Freelancers
Design
Engineering
Marketing
Music & Audio
Social Media
Video & Animation
Writing
Drops
Freelance Industry Report
Social
Terms & Conditions
Privacy Policy
Cookie Policy
© 2024 Contra.Work Inc All Rights Reserved.
