Schema ESQL personnel Below you see all guys from the departments select * from employee

---

Below you see just some of the guys select * from employee jdbc 1 2 We skipped some. There are some more. There is a total of employees.

---

Below departments and employees are printed. Without the grouping feature, the result would look like this: SELECT department.name, employee.id, employee.name as empName FROM department, employee WHERE department.id = employee.department_id ORDER BY department.name

---

This uses the grouping feature in esql. SELECT department.name, employee.id, employee.name as empName FROM department, employee WHERE department.id = employee.department_id ORDER BY department.name

---

This uses nested queries. SELECT name, id FROM department ORDER BY name

select name from employee where department_id =