Employee management exercise 10

Back to Employee management

Select the name and last name of each employee, along with the name and budget of the employee's department.

| SELECT name, lastname, department FROM employees
| SELECT code, name, budget FROM departments
| RENAME code department
| RENAME name departmentname
| JOIN department
| PROJECT name, lastname, departmentname, budget
12 rows 0 msec
name lastname departmentname budget
Michael Rogers IT 65000
Anand Manikutty IT 65000
Carol Smith Accounting 15000
Joe Stevens Accounting 15000
Mary-Anne Foster IT 65000
George ODonnell Research 55000
John Doe Human Resources 240000
David Smith Research 55000
Zacary Efron Human Resources 240000
Eric Goldsmith Human Resources 240000
Elizabeth Doe IT 65000
Kumar Swamy IT 65000