Answer to Question #171899 in Databases | SQL | Oracle | MS Access for Maryam

Question #171899

Task 3: Group Function and Group Rows

 

1.    Display how many employees with salary that is less than 6000 in each job id, in each department.

 

2.    Display the average, maximum and minimum salary of all employees under a manager with ID 110 or 150

 

3.    Display last name, first name, department, city of all employees working with manager of the department with id number 103 or 205.

 

4.    Count how many employees working in each country per department. Display only with number of employees of more than 20.


1
Expert's answer
2021-03-16T18:54:03-0400
Dear Maryam, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS