We will discuss advanced SQL and OLAP queries. Please refer to the HR data model below when
Fantastic news! We've Found the answer you've been seeking!
Question:
We will discuss advanced SQL and OLAP queries. Please refer to the HR data model below when you answer those questions.
1.(Assessed) Find all the departments where the total salary of all employees belong to that department is higher than the the average salary of all employees. Show the department_id, the department_name and the total salary in the output in descending order of total salary.(Use WITH statement)
(Assessed) Using top down approach, show all subordinates of Lex De Haan. (hints: use recursive with)
Use bottom up approach, show all superordinates of William Gietz.
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date: