Question: Using INNER JOIN
Explore how to write an SQL INNER JOIN query that combines data from Employees, Skills, and Projects tables. Learn to retrieve employee names alongside their assigned projects by mastering multi-table joins and understanding table relationships.
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 |
...