1.Give a query for a list of each department(number and name)with their number of employees.
问题描述：
1.Give a query for a list of each department(number and name)with their number of employees.
这是EMP表的问题,2.give a query for a list of each department(number and name) for all department with no employees.
答
select dep.dept_no,dep.name,count(emp.empno) employeeNumberfrom ps_department dep,ps_employee empwhere dep.dept_no = emp.dept_noand dep.current_status = 'Y' /* in use */and emp.current_status = 'Y' /*...