← SQL PlaygroundEmployees With Department And Pay Band
MediumJoinsPremiumFor each employee return their 'name', their department 'name' as 'department', and 'salary'. Join 'employees' to 'departments'.
Schema
departments (id, name)
employees (id, name, department_id, salary, hire_date)