Overview
Welcome to our second SQL case study.
Those who submit an entry will be eligible to win a free copy of SQL For Data Analytics by Packt! The more weeks you participate, the more chances you get to win!
There is no deadline for submission.
This case study utilizes intermediate and advanced SQL. If you are just starting your SQL journey, check out our public SQL challenges before tacking our case studies.
Submission Instructions
Make a LinkedIn or twitter post with a screenshot or PDF of your answers. You can explain your thought process if you’d like. Just make sure to tag the Data in Motion LLC LinkedIn page or Twitter page.
Questions
- Find the longest ongoing project for each department.
- Find all employees who are not managers.
- Find all employees who have been hired after the start of a project in their department.
- Rank employees within each department based on their hire date (earliest hire gets the highest rank).
- Find the duration between the hire date of each employee and the hire date of the next employee hired in the same department.
DB Fiddle Instructions
Click ‘Edit on DB Fiddle’ to be taken to the in browser SQL playground where you can run your queries.