Question: Using RIGHT JOIN
Explore how to apply RIGHT JOIN to combine Employees, Skills, and Projects tables. Learn to write queries that reveal all employees assigned to projects as well as projects without any assignments. This lesson helps you practice JOIN operations essential for SQL interviews.
We'll cover the following...
We'll cover the following...
Question
Given the following Employees, Skills ...
Employees
EmpID | EmpName | Salary |
1 | Susan Lee | 50000.00 |
2 | Alexa Smith | 60000.00 |
3 | Sana Amberson | 45000.00 |
4 | Sarah Ronald | 47000.00 |
Skills
SkillID | EmpID | SkillName |
1 | 1 | C++ |
2 | 4 | Java |
3 | 1 | Python |
4 | 3 | Blender |
5 | NULL | Android |
Projects
ProjectID | EmpID | SkillID | ProjectName |
1 | 1 | 1 | Industrial Robot |
2 | 4 | 2 | Multiplatform GUI |
3 | 3 | 4 | 3D Simulation |
4 | 1 | 3 | Deep Learning Model |
5 | NULL | NULL | IOS App |
6 | 1 | NULL | Advanced Calculator |
7 | NULL | 5 | Android App |
...