Employee management exercise 14

Back to Employee management

Select the name and last name of employees working for departments with second lowest budget.

| SELECT code, budget FROM departments
| ORDER budget NUMERIC
| LIMIT 1 1
| PROJECT code
| RENAME code department
| SELECT name, lastname, department FROM employees WHERE name
| JOIN department
| PROJECT name, lastname
2 rows 1 msec
name lastname
George ODonnell
David Smith