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
| 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 |