Basic inner join report
SQL
Easy
5 views
Problem Description
List employee name with department name.
Sample Test Case
Input:
Employees(name, dept_id), Departments(dept_id, dept_name)
Official Solution
SELECT e.name, d.dept_name FROM Employees e JOIN Departments d ON d.dept_id = e.dept_id;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!