Question: Write a query thats creates a report for the HR department for departments that employs fewer than three employees. Include number, department name, and the
Create a reports for the HR department for departments that employs fewer than three employees. Include SELECT DEDARTMENTS department,jid, department, name, COUNT(employeejid) number, department name, and the number of FROM DEPARTMENTS employees working in each department. INNER JOIN EMPLOYEES ON DEPARTMENTS department_jd EMPLOYEES department_id GROUP BY department_name
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
