Use HR database (Sample tables and data are in DatabaseHR.pdf file). Write a query that shows: department name, the numb

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Use HR database (Sample tables and data are in DatabaseHR.pdf file). Write a query that shows: department name, the numb

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”