Using Oracle Live Sql Human Resource Schema Display Manager Number Salary Lowest Paid Empl Q43896418
*****USING ORACLE LIVE SQL, Human Resource Schema*****
- Display the manager number and the salary of the lowest paidemployee for that manager. Exclude anyone whose manager is notknown. Exclude any groups where the minimum salary is $6,000 orless. Sort the output in descending order of salary.
- Write a query to display each department’s name, location,number of employees, and the average salary for all employees inthat department. Label the columns Department , Location, Number ofWorkers, and Average Salary, respectively. Round the average salaryto two decimal places.
Expert Answer
Answer to *****USING ORACLE LIVE SQL, Human Resource Schema***** Display the manager number and the salary of the lowest paid empl…
OR