Use HR database (Sample tables and data are in DatabaseHR.pdf file). Write a query that shows: department name, the numb
Posted: Mon Jul 11, 2022 9:50 am
Use HR database (Sample tables and data are in DatabaseHR.pdffile). Write a query that shows: department name, the number ofemployees in each department (include departments with 0employees), min, max, and average salary for all the departments inthe database. Then use UNION ALL toappend at the end text: Totals and the total number of employees,average, min, and max salary for the entire company.