Select the name and last name of employees working for departments with a budget greater than $60,000.
| SELECT name, lastname, department FROM employees
| SELECT code, name, budget FROM departments
| WHERE budget >= 60000
| RENAME code department
| RENAME name departmentname
| JOIN department
| PROJECT name, lastname
8 rows 0 msec
| SELECT code, name, budget FROM departments
| WHERE budget >= 60000
| RENAME code department
| RENAME name departmentname
| JOIN department
| PROJECT name, lastname
8 rows 0 msec
| name | lastname |
|---|---|
| Michael | Rogers |
| Anand | Manikutty |
| Mary-Anne | Foster |
| John | Doe |
| Zacary | Efron |
| Eric | Goldsmith |
| Elizabeth | Doe |
| Kumar | Swamy |