SQL-ETL-Views

1 flashcards · Computer Science · by aramay

1. Write SQL - which department does each employee work for? Employees table Departments table The final result should look like

   select A.first_name, A.department_id, b.department.name from hr.employees A join hr.departments B on A.department_id=B.department.id