Employee Project Assignments With Department
Medium
joins
Google
Meta
LinkedIn
Join employees, departments, and project_assignments to list each employee's name, department, and assigned project.
Expected Output
| emp_name | dept_name | project_name |
|---|---|---|
| Alice | Engineering | Apollo |
| Bob | Engineering | Beacon |
| Carol | Marketing | Beacon |
| Dave | Finance | Capstone |
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...